Hi community,
I am hitting a brick wall with this. It is going to be something simple - but it has me stumped, so thanks in advance for any help.
Scenario: I want to grab an ID of a calendar event (so I can extend the invite to another colleague) there are multiple events with similar subject like 'Event Stream 1' , 'Event Stream 2' etc.
I am using 'Get Events (V4) ' with an odata query to pull out events when the subject contains 'Event Stream ' - this is all working fine. Sample output data below (I have changed the email addresses manually for this post and emptied the body text)
{
"value": [
{
"subject": "Event Stream 2",
"start": "2020-09-24T18:30:00.0000000",
"end": "2020-09-24T18:55:00.0000000",
"body": "",
"isHtml": true,
"responseType": "organizer",
"responseTime": "0001-01-01T00:00:00+00:00",
"id": "AAMkADE3MmJjNjczLWUyMjYtNDU3MS04NzE5LWQyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6rgX48Ph_uBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD-6b1lMvLARKh4i7vuKNUkAAJ2rR8lAAA=",
"createdDateTime": "2020-09-22T19:10:35.2035891+00:00",
"lastModifiedDateTime": "2020-09-23T03:25:03.9362746+00:00",
"organizer": "some.email@company.com",
"timeZone": "UTC",
"categories": [],
"webLink": "https://outlook.office365.com/owa/?itemid=AAMkADE3MmJjNjczLWUyMjYtNDU3MS04NzE5LWyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6WrgX48Ph%2BuBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD%2F6b1lMvLARKh4i7vuKNUkAAJ2rR8lAAA%3D&exvsurl=1&path=/calendar/item",
"requiredAttendees": "some.email@company.com;",
"optionalAttendees": "",
"resourceAttendees": "",
"location": "Microsoft Teams Meeting",
"importance": "normal",
"isAllDay": false,
"recurrence": "none",
"reminderMinutesBeforeStart": 0,
"isReminderOn": true,
"showAs": "busy",
"responseRequested": true
},
{
"subject": "Event Stream 1",
"start": "2020-09-24T18:00:00.0000000",
"end": "2020-09-24T18:25:00.0000000",
"body": "",
"isHtml": true,
"responseType": "organizer",
"responseTime": "0001-01-01T00:00:00+00:00",
"id": "AAMkADE3MmJjNjczLWUyMjYtNDU3MS04NzE5LWQyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6WrgX4Ph_uBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD-6b1lMvLARKh4i7vuKNUkAAJ2rR8kAAA=",
"createdDateTime": "2020-09-22T19:10:27.0862292+00:00",
"lastModifiedDateTime": "2020-09-23T03:25:03.7650273+00:00",
"organizer": "some.email@company.com",
"timeZone": "UTC",
"categories": [],
"webLink": "https://outlook.office365.com/owa/?itemid=AAMkADE3MmJjNjczLWUyMjYtNDU3MS04zE5LWQyYmUzMjMzMmJmZABGAAAAAACO84RtEwf6R6WrgX48Ph%2BuBwCavEk1Z3d8T49R5hImgL0uAAAAB688AAD%2F6b1lMvLARKh4i7vuKNUkAAJ2rR8kAAA%3D&exvsurl=1&path=/calendar/item",
"requiredAttendees": "some.email@company.com;",
"optionalAttendees": "",
"resourceAttendees": "",
"location": "Microsoft Teams Meeting",
"importance": "normal",
"isAllDay": false,
"recurrence": "none",
"reminderMinutesBeforeStart": 0,
"isReminderOn": true,
"showAs": "busy",
"responseRequested": true
}
]
}
Is this data (above) a JSON encoded array or a string or?
I need to extract the Subject and ID so I can later filter on Subject and retrieve the ID for use later in the Flow.
I have tried using Parse JSON as next step, but just get stuck getting hold of the data.
What is the best method please?
thanks
