How to access data in json and insert in a table ?

[BSUN_RO]

Hi, I have the following JSON from a get request:

{ "headers": "",
  "array": [ { "lat": "44.1694124" } ] }

I would like how to access the "lat" parameter and then insert into a infotable. Thankyou very much!

[slangley · Accepted solution]

Hi @BSUN_RO.

Give this a try:

var jsonArray = {
"headers":"",
"array":[ {"lat":"44.1694124"} ]
};

result = jsonArray.array[0].lat;

To store it in an infotable, please refer to this article.

Also, here is another article that may be helpful.

Regards.

--Sharon

[BSUN_RO]

I managed to get the data following your example. Thankyou!