JSON integration with UIPath

[shikharno.7]

Below is a sample JSON.
Could anyone help me with the iteration through JSON,

for e.g. i want the result " Huston Rocket " so how could i do that . I have used for each in UIpath .

Any better way to do this ?

{
“quiz”: {
“sport”: {
“q1”: {
“question”: “Which one is correct team name in NBA?”,
“options”: [
“New York Bulls”,
“Los Angeles Kings”,
“Golden State Warriros”,
“Huston Rocket”
],
“answer”: “Huston Rocket”
}
},

[Palaniyappan (Palaniyappan P)]

Kindly have a view on this buddy

Get value from json

Hi ,i’m Chen [%E7%84%A1%E9%A1%8C] I want to get the array,but failed,i tryied like this: first i read into the json.file,and the output of Deserialize json activity is deserializedJson,then i start to retrive data: deserializedJson(“name”).Value(of string) --success deserializedJson(“memberList”).Value(of string) --failed can anyone help me. Thank you.

Cheers @shikharno.7

[HareeshMR (Hareesh Madasi)]

You can get the options array using this @shikharno.7,

To get answer key : data.Root(“quiz”).Item(“sport”).Item(“q1”).Item(“answer”)

To get options array :
data.Root(“quiz”).Item(“sport”).Item(“q1”).Item(“options”)

But your JSON is not in the correct format, some closing roots are missing and , here are the steps to do :

1. replace all the double quotes with single quotes
2. Use deserialize JSON activity and paste the json below :

“{
‘quiz’: {
‘sport’: {
‘q1’: {
‘question’: ‘Which one is correct team name in NBA?’,
‘options’: [
‘New York Bulls’,
‘Los Angeles Kings’,
‘Golden State Warriros’,
‘Huston Rocket’
],
‘answer’: ‘Huston Rocket’
}
}}}”

3. Get the required array of options using above
4. Assign it to array type variable and get the required using array[3] as it is in the 4 index…

or simply if you have answer everytime in your JSON …

Use this : data.Root(“quiz”).Item(“sport”).Item(“q1”).Item(“answer”)

[shikharno.7]

@HareeshMR , @Palaniyappan
Thank you for the prompt response.
I also tried this method .

Could this be solved with some other logic too ? like linkquery

[Palaniyappan (Palaniyappan P)]

Fine
hope this would help you

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 @shikharno.7

[HareeshMR (Hareesh Madasi)]

@shikharno.7

like linkquery

Can you explain a bit more?

@HareeshMR

data.Root(“quiz”).Item(“sport”).Item(“q1”).Item(“answer”)

Using this, you will get the required directly and I don’t understand what you mean by linkquery?

[shikharno.7]

@HareeshMR , looking for an answer somewhat similar to what @Palaniyappan quoted.

[ronanpeter]

There are good number of JSON formatter and verifying tools online

JSON Formatter & Validator

Here is an example JSON flow. It uses a JSON file downloaded form a Football Stats website.

The intention is to extract the home team from the first game. This is done by accessing each branch of the JSON:

Trim(jo_MatchInfo("matches")(1)("homeTeam").ToString)

Hopefully this helps.

JSON.SimpleExample.zip (2.9 KB)