Last updated:
Import From Microsoft Calendar
The Import From Microsoft Calendar node retrieves calendar events from Microsoft Calendar. It uses Microsoft Graph APIs to securely access calendar data within Microsoft 365, importing events from the default calendar of a specified mailbox.
The node retrieves events based on a given date and returns selected event data such as subject, time, and location.
How it works:
- Select a valid connection to Microsoft.
- Open Advanced to configure the mailbox (email), the date from which events should be retrieved, and the columns to include in the output.
- The node retrieves calendar events.
- The selected data is returned as a new output table.
Configuration
Section titled “Configuration”| Setting | Required | Description |
|---|---|---|
| Connection | Yes | A Microsoft Office 365 connection or an OAuth2 connection (Microsoft Graph). |
| Advanced | Yes | Opens a configuration screen where you define the mailbox, date filter, and output columns. |
Advanced configuration
Section titled “Advanced configuration”- Email: mailbox from which events are retrieved.
- Created from: date from which events are retrieved.
- Columns to import: select which fields should be included in the output.
The node retrieves events from the default calendar of the specified mailbox, and only the selected columns are included in the output.
Filtering behavior
Section titled “Filtering behavior”The Created from field filters on when the event was created or last modified: it does not filter on the event’s start date. This means only events created and modified after the specified date are returned.
Output
Section titled “Output”Each row represents a calendar event and may include:
| Column | Description |
|---|---|
| Id | Microsoft event ID |
| Mailbox used | |
| StartTime | Event start time |
| EndTime | Event end time |
| TimeZone | Timezone of the event |
| Location | Event location |
| Subject | Event title |
| BodyPreview | Preview of the event description |
Only the columns selected in the Advanced configuration are included.
- Use a recent Created from date to limit data volume.
- Ensure the connection has access to the specified mailbox.
- Select only the columns you need to improve performance.