I have a simple scenario - pull all events from an Outlook calendar and load them into a Google Sheet. This mostly works fine, except for recurring events it only pulls the first instance of the series. Does anyone know how to pull each individual event?
Unfortunately, Microsoft doesn’t allow you to do that.
You will need to calculate each future occurrence yourself using the details in each event’s payload.
If you want individual events, I recommend using Google Calendar, which allows you to get a recurring event as individual events.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
One of the datapoints I’m trying to get is the event ID. When I look at the event in Outlook online, it’s in the URL. So just calculating the events isn’t really helpful, because I need to sync changes.
I’ve tried exporting from Outlook too, but that doesn’t provide the event ID at all.
I’m surprised there’s no way to get these in bulk.
Hmm, upon further searching, it may be possible using a different endpoint.
To include recurring events, use the
/calendarViewendpoint instead of/events, and ensure the date range in your$filtercaptures the full day (e.g.,T23:59:59Z). Also, handle pagination if the result contains more than 1000 events.
For more information, see python - MS Graph - List events (read) - Recurring events - Stack Overflow
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.
How do I change the endpoint like this in my scenario? I don’t see any other Outlook triggers besides ‘search events’ and I don’t see any setting like that.
Unfortunately, Make doesn’t have a module for this particular endpoint yet.
Try using the Microsoft 365 Calendar “Make an API Call” module:
Performs an arbitrary authorized API call.
If the external service has a Developer API Reference/Documentation then you should be able to integrate the endpoints in Make using the app’s universal module (Make an API Call) or generic HTTP “Make a request” module.
You can also suggest for it to be made in the Idea exchange. Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
If you need assistance in setting up the app’s universal module, or the built-in generic HTTP modules, please provide additional information about what you have tried in relation to the external service’s Developer API Reference — how you are setting the connection up, a link to the endpoint are you trying to connect to, and what errors you are encountering.
You can also complete this brand new course/tutorial in the Make Academy on how to use external APIs — API calls with HTTP modules
- API and Endpoints
- Header and body
- Multipart/form-data
- OAuth 2.0
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
Ok thank you. Seems like this is the API docs for calendar: Outlook calendar API overview - Microsoft Graph. I’ll give this a shot.