Office 365: Get Events

Description

This step retrieves calendar events from a Microsoft 365 user’s calendar. You provide the user and optionally filter by date range. Use this step in workflows that check for scheduling conflicts, audit calendar entries, or collect meeting data for reporting.

Permission:

• Following permissions are required to get events in Office365:

  Permission type	Permission (from least to most privileged)
  Delegated (work or school account)	Calendars.Read, Calendars.ReadWrite offline_access
  Application	Calendars.Read, Calendars.ReadWrite User.Read.All

• • To access a shared mailbox, verify the following configurations are complete:
    • Provide admin consent for the corresponding delegated *.Shared Microsoft Graph permissions

      Mailbox permission on the shared mailbox	Delegated Graph permission (app registration)
      Full Access (calendar read)	Calendars.Read.Shared

Configurations

No.	Field Name	Description
1	Step Name	Name of the step. This name has to be unique in a single workflow.
	Connection:	For details about app registration, see Office 365 App Registration for Grant Type – Password Grant or Office 365 App Registration for Grant Type Refresh Token
2	Grant Type	Select the type of grant from Password Grant or Refresh Token. The data type is string. This field is mandatory. Note: It is recommended to select the grant type from Refresh Token.
3	Tenant ID	Tenant ID of Microsoft Account. The data type is string. This field is mandatory.
4	Client ID	Client ID of the Application created in Microsoft Account. The data type is string. This field is mandatory.
	Client Secret:
5	Accept Value as variable/static	Leave checkbox unchecked to accept Client Secret value from a field in the previous steps of the stream using a drop down list. Else enable checkbox for Client Secret field to appear as Text box.
6	Client Secret	Specify the Client Secret generated in Microsoft Account. Client Secret is entered using a widget. The widget handles both Text (static value or environment variable) and Combo (drop down containing values from previous steps). If checkbox above is enabled Client Secret field appears as a Text box and accepts static or variable values. Else if checkbox above is disabled Client Secret field appears as a drop down to select fields from previous steps. The data type is secure string. This field is mandatory.
7	Username	Specify the name of the user whose email attachments are to be downloaded.
8	Password	Specify the password for the provided user name.
9	Refresh Token	Specify the refresh token required to authenticate the details.
10	Button: Test Connection	Test connection with Client ID and Client Secret provided. Verifies whether the connection is established or not. Note: For the purpose of verification fields coming from previous steps are not allowed since field values can only be accessed when workflow is in running state. Static values and environment variables are allowed.
	Input tab:
	Input Fields:
1	Shared Mailbox Email	Specify the email address of a shared mailbox to read calendar events from the associated calendar for the given date range. Leave the field blank to read calendar events for the currently authenticated account instead. Note: The authenticated account must have access permissions for the shared mailbox, else the step fails and returns a Microsoft Graph permission error. The field supports static values and environment variables.
2	Start Date	Specify the date from which you want to fetch the events. The data type is string. This field is mandatory. Note: Date format supported are ‘YYYY-MM-DD’ and ‘YYYY/MM/DD’.
3	Start Time	Specify the time from which you want to fetch the events. The data type is string. This field is mandatory. Note: Time format supported is ‘hh:mm aa’. Ex: 09:30 AM
4	End Date	Specify the date till which you need to fetch events. The data type is string. This field is mandatory. Note: Date format supported are ‘YYYY-MM-DD’ and ‘YYYY/MM/DD’.
5	End Time	Specify the time till you need to fetch events. The data type is string. This field is mandatory. Note: Time format supported is ‘hh:mm aa’. Ex: 09:30 AM
	Output Tab:
	Output Fields:
1	Output JSON Field Name	Specify the output JSON field name.