Hey,
I have a json array looking like this:
[
{
“id”: 9,
“number”: 1000025,
“email”: “blabla”,
“name”: “Dan”,
“employment_date”: “2006-03-27”,
“latest_shift_date”: “2020-02-27”,
“shift_count”: {
“30”: 1,
“60”: 5,
“90”: 10
},
“first_aid_expire”: null,
“emergency_team_member”: false,
problem is, when im using the for each, i dont got all the data from the “shift count” list. How do I do that with a nested list? Im convertering the data into excel.
shift_count is another jsonarray in your main jsonarray.
You’d have to build 2 for each loops nested in eachother. The inner loop going through the shift_count node.
here is the file. make notice that there is one more nested list in the json array, called “location_types”.
If you can make a Uipath file, i would appreciate it a lot!
Sure. one question from my side. the attached Json is converted one or raw json.
if you have raw json file could share it with me.
i have checked with other sample json i am able to convert them to json object by using deserialize json activity. But for the attached json i am not able to convert.
The json file is actually coming from a http request, but i cant share it with you, because there is some authentication. but the json file ill shared with you, is the same as from the http request. I might think the problem is because its a json array? - Does it make sense?