Json Nested array

Help
, ,
1

Hi all , i want to know how to get values from nested array as attached Here , using Serialization Json array activity , when i try to do getting error .
can anyone send the xaml for this !!

Nested Array:

{
    "medications":[{
            "aceInhibitors":[{
                "name":"lisinopril",
                "strength":"10 mg Tab",
                "dose":"1 tab",
                "route":"PO",
                "sig":"daily",
                "pillCount":"#90",
                "refills":"Refill 3"
            }],
            "antianginal":[{
                "name":"nitroglycerin",
                "strength":"0.4 mg Sublingual Tab",
                "dose":"1 tab",
                "route":"SL",
                "sig":"q15min PRN",
                "pillCount":"#30",
                "refills":"Refill 1"
            }],
            "anticoagulants":[{
                "name":"warfarin sodium",
                "strength":"3 mg Tab",
                "dose":"1 tab",
                "route":"PO",
                "sig":"daily",
                "pillCount":"#90",
                "refills":"Refill 3"
            }],
            "betaBlocker":[{
                "name":"metoprolol tartrate",
                "strength":"25 mg Tab",
                "dose":"1 tab",
                "route":"PO",
                "sig":"daily",
                "pillCount":"#90",
                "refills":"Refill 3"
            }],
            "diuretic":[{
                "name":"furosemide",
                "strength":"40 mg Tab",
                "dose":"1 tab",
                "route":"PO",
                "sig":"daily",
                "pillCount":"#90",
                "refills":"Refill 3"
            }],
            "mineral":[{
                "name":"potassium chloride ER",
                "strength":"10 mEq Tab",
                "dose":"1 tab",
                "route":"PO",
                "sig":"daily",
                "pillCount":"#90",
                "refills":"Refill 3"
            }]
        }
    ],
    "labs":[{
        "name":"Arterial Blood Gas",
        "time":"Today",
        "location":"Main Hospital Lab"      
        },
        {
        "name":"BMP",
        "time":"Today",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"BNP",
        "time":"3 Weeks",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"BUN",
        "time":"1 Year",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"Cardiac Enzymes",
        "time":"Today",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"CBC",
        "time":"1 Year",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"Creatinine",
        "time":"1 Year",
        "location":"Main Hospital Lab"  
        },
        {
        "name":"Electrolyte Panel",
        "time":"1 Year",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"Glucose",
        "time":"1 Year",
        "location":"Main Hospital Lab"  
        },
        {
        "name":"PT/INR",
        "time":"3 Weeks",
        "location":"Primary Care Clinic"    
        },
        {
        "name":"PTT",
        "time":"3 Weeks",
        "location":"Coumadin Clinic"    
        },
        {
        "name":"TSH",
        "time":"1 Year",
        "location":"Primary Care Clinic"    
        }
    ],
    "imaging":[{
        "name":"Chest X-Ray",
        "time":"Today",
        "location":"Main Hospital Radiology"    
        },
        {
        "name":"Chest X-Ray",
        "time":"Today",
        "location":"Main Hospital Radiology"    
        },
        {
        "name":"Chest X-Ray",
        "time":"Today",
        "location":"Main Hospital Radiology"    
        }
    ]
}

Regards
Naveen

2

@naveen19

Please check the attached file I hope this will help you get nested value.
json.xaml (8.6 KB)

3

hi @aanandsanraj i not modified anything , just changed the file path of JSON alone but am getting error like below.

image
image1499Ă—790 43.7 KB

4

@naveen19

Your string is not an array string so just add “[” in the begin and “]” end of your json string and try again

[{
“medications”:[{
“aceInhibitors”:[{
“name”:“lisinopril”,
“strength”:“10 mg Tab”,
“dose”:“1 tab”,
“route”:“PO”,
“sig”:“daily”,
“pillCount”:“#90”,
“refills”:“Refill 3”
}],
“antianginal”:[{
“name”:“nitroglycerin”,
“strength”:“0.4 mg Sublingual Tab”,
“dose”:“1 tab”,
“route”:“SL”,
“sig”:“q15min PRN”,
“pillCount”:“#30”,
“refills”:“Refill 1”
}],
“anticoagulants”:[{
“name”:“warfarin sodium”,
“strength”:“3 mg Tab”,
“dose”:“1 tab”,
“route”:“PO”,
“sig”:“daily”,
“pillCount”:“#90”,
“refills”:“Refill 3”
}],
“betaBlocker”:[{
“name”:“metoprolol tartrate”,
“strength”:“25 mg Tab”,
“dose”:“1 tab”,
“route”:“PO”,
“sig”:“daily”,
“pillCount”:“#90”,
“refills”:“Refill 3”
}],
“diuretic”:[{
“name”:“furosemide”,
“strength”:“40 mg Tab”,
“dose”:“1 tab”,
“route”:“PO”,
“sig”:“daily”,
“pillCount”:“#90”,
“refills”:“Refill 3”
}],
“mineral”:[{
“name”:“potassium chloride ER”,
“strength”:“10 mEq Tab”,
“dose”:“1 tab”,
“route”:“PO”,
“sig”:“daily”,
“pillCount”:“#90”,
“refills”:“Refill 3”
}]
}
],
“labs”:[{
“name”:“Arterial Blood Gas”,
“time”:“Today”,
“location”:“Main Hospital Lab”
},
{
“name”:“BMP”,
“time”:“Today”,
“location”:“Primary Care Clinic”
},
{
“name”:“BNP”,
“time”:“3 Weeks”,
“location”:“Primary Care Clinic”
},
{
“name”:“BUN”,
“time”:“1 Year”,
“location”:“Primary Care Clinic”
},
{
“name”:“Cardiac Enzymes”,
“time”:“Today”,
“location”:“Primary Care Clinic”
},
{
“name”:“CBC”,
“time”:“1 Year”,
“location”:“Primary Care Clinic”
},
{
“name”:“Creatinine”,
“time”:“1 Year”,
“location”:“Main Hospital Lab”
},
{
“name”:“Electrolyte Panel”,
“time”:“1 Year”,
“location”:“Primary Care Clinic”
},
{
“name”:“Glucose”,
“time”:“1 Year”,
“location”:“Main Hospital Lab”
},
{
“name”:“PT/INR”,
“time”:“3 Weeks”,
“location”:“Primary Care Clinic”
},
{
“name”:“PTT”,
“time”:“3 Weeks”,
“location”:“Coumadin Clinic”
},
{
“name”:“TSH”,
“time”:“1 Year”,
“location”:“Primary Care Clinic”
}
],
“imaging”:[{
“name”:“Chest X-Ray”,
“time”:“Today”,
“location”:“Main Hospital Radiology”
},
{
“name”:“Chest X-Ray”,
“time”:“Today”,
“location”:“Main Hospital Radiology”
},
{
“name”:“Chest X-Ray”,
“time”:“Today”,
“location”:“Main Hospital Radiology”
}
]
}]

5

@aanandsanraj if i want to access name of all child array , how should i go ?
item.GetValue(“medications”)(“aceInhibitors”)(“name”).ToString
i gave like this but i couldn’t get result.

6

@naveen19

try the below code
((jsonArr(0).SelectToken(“medications”))(0).SelectToken(“aceInhibitors”))(0).SelectToken(“name”).ToString

1 Like
7

thank you so much @aanandsanraj & can u suggest me any sample http req using access token to implement in uipath

8

You’re Welcome @naveen19.
Happy coding

Check this link for webapi access: Read me

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.