Extracting value from json after comparison?

[anjasing (Anjali)]

Wanted to extract job ID(abz) from below mentioned json…where name should be Loren and folder should be (abcd/pqrs)
{
“statuses” : [ {
“jobId” : “abx”,
“name” : “Suzan”,
“folder” : “abcd”,
“status” : “Ended Not OK”
}, {
“jobId” : “aby”,
“name” : “Pinacio”,
“folder” : “abcd”,
“status” : “Ended Not OK”
}, {
“jobId” : “abz”,
“name” : “Loren”,
“folder” : “abcd/pqrs”,
“status” : “Ended Not OK”,
],
“returned” : 3,
“total” : 3
}

[Anil_G (Anil Gorthi)]

@anjasing

should

HI @anjasing

please look at this. This is what you need exactly

4. RPA Challenge - Json Parsing

Like I said, there’s no error It’s just that the whole file is not a strict JSON, but a JSON array in itself - if you use Deserialize JSON Array activity instead, it’ll work. Solution attached - Linq and SelectToken variants. Sidenote - for better view if it’s correct change the phone numbers in the file so they’re not all identical. Main.xaml (9.5 KB)

cheers

[Gokul001 (Gokul Balaji)]

Hi @Anil_G

Check out this thread and video

https://forum.uipath.com/search?q=Deserialize%20json%20%40ppr

UiPath Json Array | Deserialize Json Array UiPath | UiPath Json deserialize | UiPath Tutorial

Regards
Gokul

[Yoichi]

Hi,

As there are some syntax errors for json format in the above text, I fixed it as the following.

{
"statuses" : [ {
"jobId" : "abx",
"name" : "Suzan",
"folder" : "abcd",
"status" : "Ended Not OK"
}, {
"jobId" : "aby",
"name" : "Pinacio",
"folder" : "abcd",
"status" : "Ended Not OK"
}, {
"jobId" : "abz",
"name" : "Loren",
"folder" : "abcd/pqrs",
"status" : "Ended Not OK"
}
],
"returned" : 3,
"total" : 3
}

Then, can you try as the following?

Sample20221125-9.zip (2.6 KB)

Regards