Fetching values from JSON

sajin1991 — Fri, 25 Jul 2025 14:14:04 GMT

Hi Team,

I have a JSON response. Can some one help me to get the value of "description".

I have used Json to Collection method to Parse the JSON response.

Since the value of description is inside and array I'm facing difficulty to get the value.

Can some one help me to get the value of "description" with steps I need to follow.

The JSON is as follows

{

"coord": {

"lon": 0.2169,

"lat": 51.4462

"weather": [

{

"id": 803,

"main": "Clouds",

"description": "broken clouds",

"icon": "04d"

}

"base": "stations",

"main": {

"temp": 25.36,

"feels_like": 25.36,

"temp_min": 23.98,

"temp_max": 26.23,

"pressure": 1018,

"humidity": 54,

"sea_level": 1018,

"grnd_level": 1013

"visibility": 10000,

"wind": {

"speed": 4.63,

"deg": 260

"clouds": {

"all": 75

"dt": 1753452386,

"sys": {

"type": 2,

"id": 2011528,

"country": "GB",

"sunrise": 1753416773,

"sunset": 1753473487

"timezone": 3600,

"id": 2651500,

"name": "Dartford",

"cod": 200

}

Thanks

Re: Fetching values from JSON

Neel1 — Fri, 25 Jul 2025 15:52:34 GMT

Description is in nested collection.

1. use Action Json to collection (skipping jarray)

2. use cal stages to get the description. abc is text data item. do no evaluate , directly run the cal stage

Re: Fetching values from JSON

sajin1991 — Fri, 25 Jul 2025 16:58:29 GMT

Hi @Neel1

Thankyou for the response.

The steps you mentioned above is working. Thanks a lot.

Thanks

topic Fetching values from JSON in Product Forum

Fetching values from JSON

Re: Fetching values from JSON

Re: Fetching values from JSON