cancel
Showing results for 
Search instead for 
Did you mean: 

Fetching values from JSON

sajin1991
Level 3

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

2 REPLIES 2

Neel1
MVP

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

Neel1_2-1753458714173.png

 

 

Hi @Neel1 

Thankyou for the response.

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

Thanks