How to extract the key value based on a JSON payload?

[tharani.natarajan]

Please help to get key where “IsLatestVersion”: true

input - {
“@odata.context”: UiPath,
“@odata.count”: 2,
“value”: [
{
“Key”: “f943f755-9553-46a8-bfd768”,
“ProcessKey”: “Fedex_Retail_Claim_Process”,
“IsLatestVersion”: false,
“Name”: “Retail_Claims”
},
{
“Key”: “3e7c8a6d-872c-4edbf60d790”,
“ProcessKey”: “Fedex_Retail_Claim_Process”,
“IsLatestVersion”: true,
“Name”: “Fedex_Retail_Claim_Process”
}
]
}

Output:
3e7c8a6d-872c-4edbf60d790

[marian.platonov]

You can try this approach:

1. Make sure that the JSON payload is correct. You can use https://jsonformatter.org/json-pretty-print for that.

2. Add the UiPath.WebAPI.Activities in your project dependencies.

3. Save the payload to a txt file.

4. Read the Text File.

5. Deserialize JSON.

6. Use a Write Line to display the IsLatestVersion.

jsonPayloadObject.SelectToken("$.value.[1].IsLatestVersion").ToString()

7. Results → True

[Anil_G (Anil Gorthi)]

@tharani.natarajan

IsLatestVersion

@tharani.natarajan

After deserializing json as mentioned above…please use this in assign

djson("value").Where(function(x) x("IsLatestVersion").ToString.Tolower.Contains("true")).Select(function(x) x("Key").ToString)(0)

cheers

[tharani.natarajan]

@tharani.natarajan

“IsLatestVersion”

Thanks a lot for explanation