1-Visitor

Solved

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

Forum|Forum|5 years ago
March 11, 2021
1 reply
1750 views

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!

Connectivity

Best answer by slangley

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

Community Manager

Answer

Community Manager

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

Author

1-Visitor

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