Extract information from HTTP call

[Aysan]

Hello,

I have a flow that is calling MS graph and provide Group information 

I am wondering if there is a way to extract the group id from the json 

also, is it possible to make another call and add (put or post) member to the group using the id?

Thank you so much for your help

[abm]

Hi @Aysan 

Add a Parse JSON step to iterate the JSON output. Using Parse JSON step you can retrieve the group Id.

Thanks

[Aysan]

Thanks for your reply, I tried that 

The issue is when I want to set a Variable (string) to pull out the id, it starts a loop 

and then it says that @body('Parse_JSON')?['body']?['value']' is of type 'Null'.

[abm]

Hi @Aysan 

It will start a loop because your JSON 'Value' starts with an array. Have you got more than one group ids? If not its fine to set the variable. Out side the loop you can use the group id using the the variable which been set under the loop. 

Thanks

[Aysan]

Hi @abm 

The issue is when I read pars the Jason and want to make another API call can not use the id 

[abm]

Hi @Aysan 

Most likely you are not mapping the right id. Without seeing the flow / run history and the mapping its difficult to give you an exact answer.

Thanks

[Aysan · Accepted solution]

Posting this for anyone that might face the same issue, I found the solution, instead of using Pars JSON I used Select, and using compose removed unwanted characters from the id string, and could add the user to the group.

[Abdel187]

Hi 🙂

I also get the error @body('Parse_JSON')?['body']?['value']' is of type 'Null'.
But when I look at the JSON it is not empty.

Use case:
I send a GET request to a group using the predefined action Send HTTP requests. I am requesting all dates for the current day. (There is always only one appointment per day in this calendar). The answer I get back is correct.
Now I want to store some single values from the return, for example "bodyPreview" in a variable. For this I use the following flow actions. Unfortunately I always get in the loops the error "The execution of template action 'Apply_all_2' failed: the result of the evaluation of 'foreach' expression '@body('JSON_analyze')?['body']?['value']' is of type 'Null'. The result must be a valid array."

Can someone help me with this ?

Here is the pars JSON schema:

{
"type": "object",
"properties": {
"body": {
"type": "object",
"properties": {
"value": {
"type": "array",
"items": {
"type": "object",
"properties": {
"id": {
"type": "string"
},
"createdDateTime": {
"type": "string"
},
"lastModifiedDateTime": {
"type": "string"
},
"changeKey": {
"type": "string"
},
"categories": {
"type": "array"
},
"transactionId": {
"type": "string"
},
"originalStartTimeZone": {
"type": "string"
},
"originalEndTimeZone": {
"type": "string"
},
"iCalUId": {
"type": "string"
},
"reminderMinutesBeforeStart": {
"type": "integer"
},
"isReminderOn": {
"type": "boolean"
},
"hasAttachments": {
"type": "boolean"
},
"subject": {
"type": "string"
},
"bodyPreview": {
"type": "string"
},
"importance": {
"type": "string"
},
"sensitivity": {
"type": "string"
},
"isAllDay": {
"type": "boolean"
},
"isCancelled": {
"type": "boolean"
},
"isOrganizer": {
"type": "boolean"
},
"responseRequested": {
"type": "boolean"
},
"seriesMasterId": {},
"showAs": {
"type": "string"
},
"type": {
"type": "string"
},
"webLink": {
"type": "string"
},
"onlineMeetingUrl": {},
"isOnlineMeeting": {
"type": "boolean"
},
"onlineMeetingProvider": {
"type": "string"
},
"allowNewTimeProposals": {
"type": "boolean"
},
"occurrenceId": {},
"isDraft": {
"type": "boolean"
},
"hideAttendees": {
"type": "boolean"
},
"responseStatus": {
"type": "object",
"properties": {
"response": {
"type": "string"
},
"time": {
"type": "string"
}
}
},
"body": {
"type": "object",
"properties": {
"contentType": {
"type": "string"
},
"content": {
"type": "string"
}
}
},
"start": {
"type": "object",
"properties": {
"dateTime": {
"type": "string"
},
"timeZone": {
"type": "string"
}
}
},
"end": {
"type": "object",
"properties": {
"dateTime": {
"type": "string"
},
"timeZone": {
"type": "string"
}
}
},
"location": {
"type": "object",
"properties": {
"displayName": {
"type": "string"
},
"locationType": {
"type": "string"
},
"uniqueIdType": {
"type": "string"
},
"address": {
"type": "object"
},
"coordinates": {
"type": "object"
}
}
},
"locations": {
"type": "array"
},
"recurrence": {},
"attendees": {
"type": "array"
},
"organizer": {
"type": "object",
"properties": {
"emailAddress": {
"type": "object",
"properties": {
"name": {
"type": "string"
},
"address": {
"type": "string"
}
}
}
}
},
"onlineMeeting": {},
"calendar@odata.associationLink": {
"type": "string"
},
"calendar@odata.navigationLink": {
"type": "string"
},
"@odata.etag": {
"type": "string"
}
},
"required": [
"@odata.etag",
"id",
"createdDateTime",
"lastModifiedDateTime",
"changeKey",
"categories",
"transactionId",
"originalStartTimeZone",
"originalEndTimeZone",
"iCalUId",
"reminderMinutesBeforeStart",
"isReminderOn",
"hasAttachments",
"subject",
"bodyPreview",
"importance",
"sensitivity",
"isAllDay",
"isCancelled",
"isOrganizer",
"responseRequested",
"seriesMasterId",
"showAs",
"type",
"webLink",
"onlineMeetingUrl",
"isOnlineMeeting",
"onlineMeetingProvider",
"allowNewTimeProposals",
"occurrenceId",
"isDraft",
"hideAttendees",
"responseStatus",
"body",
"start",
"end",
"location",
"locations",
"recurrence",
"attendees",
"organizer",
"onlineMeeting",
"calendar@odata.associationLink",
"calendar@odata.navigationLink"
]
}
},
"@odata.context": {
"type": "string"
}
}
}
}
}