I need to fetch particular data from Json Array

Help Studio
, ,
1

Hi,

Please find below Json response

“$type”: “Rest.Api”,
“users”: [
{
“$type”: “Rest.Api”,
“isMailboxMoveStatus”: false,
“directReports”: [
“Test1”
],
“emailAddress”: “Test1@abcandco.com”,
“class”: “User”,
“distinguishedName”: “Test1”,
“objectClass”: “User”,
“additionalAttributes”: {
“$type”: “Rest.Api”
}
}
],
“resumeString”: “”,
“totalNumberOfObjects”: 1,
“numberOfRowsReturned”: 1,
“isSearchFinished”: true,
“errors”: ,
“warnings”:
}

From above response i wanted to print “directReports”.
Can anyone help on this. thanks in Advance

2

Hi!

have a view on this :

Regards,
NaNi

3

Using Deserialize JSON activity - OutPut myJObject

Accessing the first user item
Getting the directReport Items

grafik

5

Hi @Swetha_V

Use Deserialize JSON activity

image
image1426×309 22.5 KB

Use Assign activity

LHS : Create an variable
RHS : item.GetValue(“directReports”).ToString

Regards
Gokul