cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

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

EM_9394924
5-Regular Member

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!

1 ACCEPTED SOLUTION

Accepted Solutions
slangley
23-Emerald I
(To:EM_9394924)

Hi @EM_9394924.

 

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

View solution in original post

2 REPLIES 2
slangley
23-Emerald I
(To:EM_9394924)

Hi @EM_9394924.

 

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

View solution in original post

EM_9394924
5-Regular Member
(To:slangley)

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

Announcements