How to parse a JSON http response ?

Question

Hello Everybody, 
 I would like to parse a JSON http response and show only the values I'm interested in. I am trying with a!fromJson function but I am not able to get multiple values in the result body of the call integration to my webAPI. 
 I would really appreciate getting some help here please. 
 
 This is the Json that I receive. I would like to get some of the values from there and be able to filter those I'm interested in. Any ideas?

Gonzalo

Mike Schmitt · Answer

Calling a!fromJson on that string does return a valid dictionary of data. You should be able to refer to individual elements of the dictionary via standard dot notation in this case. In this case if you stored the result of the fromJson call in local!jsonDictionary, then you could get "temp" just by calling local!jsonDictionary.main.temp

Mike Schmitt · Answer

You should be able to access any of the properties in the dictionary using dot notation in the same syntax.

legotx · Answer

a!fromJSON will return an "Object" with no specific type. From there, you can access the values via dot notation or via index. 
 Assuming local!weatherData is your variable that holds the response. 
 with (
 /* ASSUMING RESPONSE BODY IS JSON STRING */
&#160; &#160;local!weatherData: a!fromJson(ri!httpResponseBody),
&#160; &#160;local!temperature: index(local!weatherData, "main", "temp", null),
&#160; &#160;local!pressure: index(local!weatherData, "main", "pressure", null),
 /* RETURNS BOTH TEMPERATURE AND PRESSURE */
&#160; &#160;{
&#160; &#160; &#160;temperature: local!temperature,
&#160; &#160; &#160;pressure: local!pressure
&#160; }
) 
 I hope this helps.

How to parse a JSON http response ?

Top Replies