Read Json response

[Thomas Pedot]

Hello,

I m having difficulties with Lava JSON API lib. I'm not good at Labview but if you can help me. I don't see a documentation or a small exemple.

My REST API return me this kind of string :

[
    {
        "id": "Cartographie",
        "records": [
            "20190801-162634"
        ],
        "name": "Cartographie",
        "description": "",
        "lft": 1,
        "rght": 2,
        "tree_id": 3,
        "level": 0,
        "parent": null
    },
    {
        "id": "Cyclage endurance",
        "records": [
            "20190909-140001",
            "20190703-100000",
            "20190603-110704"
        ],
        "name": "Cyclage endurance",
        "description": "Some descriptions",
        "lft": 1,
        "rght": 2,
        "tree_id": 4,
        "level": 0,
        "parent": null
    }
]

 

I need to make an array of ids or names.

How would you do that easily ?

 

 

[drjdpowell]

4 hours ago, Thomas Pedot said:

How would you do that easily ?

You certainly can do this with LAVA JSON, but I would suggest you use the JSONtext library instead, if possible:

[Thomas Pedot]

Hello,

I tried your solution but I have an empty Array of data.

 

 

JSON vers array.vi

 

Edited September 23, 2019 by Thomas Pedot

[drjdpowell]

Your names are strings, not variants.

[Thomas Pedot]

Ok. I'm not a LabView expert.

I expected values in table Names, e.g. Cartographie instead of name (for exemple).

At the end I want to make a drop down menu for the front end.

 

Thanks !

 

[drjdpowell]

Oops, two things called "name".  The "Names" output is an array of item names.  Your item name is, confusingly, "name".  "Cartographie" is one of your date values.  It is a string, and I in my example provided a string as the data type.  But you provided as data type an empty/void Variant, which will fail.  Use a string like in my example.

[Thomas Pedot]

Ow! Perfect !

I link automatically JSONText ! Thanks that's perfect