Skip to main content
Mar 11, 2021 2:49 PM UTC
Solved

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

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!

slangleyAnswer
Mar 11, 2021 8:08 PM UTC

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

2 replies

slangleyAnswer
Mar 11, 2021 8:08 PM UTC

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_ROAuthor
Mar 15, 2021 7:18 AM UTC

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