NEW: Check our new hosted service COZYROC Cloud ...
Microsoft Graph Connection
Overview
Configuration is provided for establishing connections with Microsoft Graph service. The configuration is used in the REST Connection Manager.
Check below some common service URLs:
| Description | URL |
|---|---|
| Default | https://graph.microsoft.com/v1.0 |
| Connecting to OneDrive Personal | https://graph.microsoft.com/v1.0/me |
| Connecting to default SharePoint instance | https://graph.microsoft.com/v1.0/sites/root |
| Connecting to specific SharePoint instance | https://graph.microsoft.com/v1.0/sites/<site-id> |
To be able to work with SharePoint sites, please include the following scopes when generating the authentication token: Sites.ReadWrite.All
Setup
Press 
icon to get more information about the connection parameters.
Obtain data
Use REST Source component to get data from service resource.
Insert data
Use REST Destination component to insert data into service resource.
Manage remote files and directories
Use File Transfer Task to manage remote files and directories. You will have to include the following scopes when generating the authentication token: Files.ReadWrite Files.ReadWrite.All
For OneDrive, the Files.ReadWrite.All is required.
Quick Start
In this task, we will show you step-by-step how to create a connection to Microsoft Graph REST API using COZYROC's REST Connection Manager.
Step 1. Run "Visual Studio" under "Administrator account". Right click on Connection managers Tab and Select New Connection. In Add SSIS Connection Manager scroll down and select Connection managers for REST Connection and click Add.
Step 2. From drop-down menu Configuration select Microsoft Graph. Select the default OAuth authentication. Then click New in the Token File parameter to create a new token file.
Take a note of the server host parameter. In this example we will establish a connection to the default SharePoint instance.
Step 3: Specify Scope for your authentication token. For working with SharePoint sites and files include the following scopes: Sites.ReadWrite.All Files.ReadWrite.All Files.ReadWrite
Step 4: Provide user Email. Press Next. Provide Password. Press 'Sign in'.
Step 5: Review the requested permissions and press 'Accept' to consent.
Step 6: Save generated access token to file. Specify token protection password. Click OK.
Step 7. Click "Test Connection" to test your connection.
Congratulations! You have now established a connection to your Microsoft Graph instance.
In this guide, we will show how to read data from the Microsoft Graph service resource using the COZYROC REST Source component. Specifically, we will show how to read Excel sheet data.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open "SSIS Toolbox" and drag and drop COZYROC "REST Source" component.
Step 3. Double click on the "REST Source" component and select Microsoft Graph connection from the combo. Select from available resources listed in the second combo below.
Optionally you can include extra parameters in the grid below if needed.
Step 4. Click on the "Columns tab" and select Microsoft Graph resource columns you want to read.
Step 5. Click Preview to make sure all necessary resource columns are included.
Bravo! You have now learned how to read data from Microsoft Graph service.
In this guide, we will show how to write data to the Microsoft Graph service resource using the COZYROC REST Destination component. We will show how to write data into an Excel sheet.
Step 1. Select an existing "Data Flow task" or create a new "Data Flow Task".
Step 2. Open the "SSIS Toolbox" and drag and drop COZYROC "REST Destination" component.
Step 3. Double click on the "REST Destination" component and select Microsoft Graph connection from the combo. Also, select resource action and the resource you want to work on.
Step 4. Click on the "Mapping" tab and map the input columns for the process you are configuring.
If you want to provide input for other resource composite objects, change the input above and map the columns.
Done. You have now learned how to write data into the Microsoft Graph resource.
Configuration
Base URL address: https://graph.microsoft.com/v1.0.
- OAuth
-
The authentication uses an authorized token. The token will be refreshed with the following expression:
{{=Date.now() + (response.expires_in - 300) * 1000}}.The authentication has the following user-defined parameters:
- client_id: Required. Identifier of application that is associated with the authentication token.
- client_secret: Specify application client secret. Optional.
- tenant: Required. Specify tenant identifier.
- Scope:
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
- Service
-
The authentication uses a session token.
The authentication has the following user-defined parameters:
- Tenant: Required. Specify directory tenant.
- AppID: Required. Specify Application ID.
- AppSecret: Required. Specify Application Secret.
The following request parameters will be automatically processed during the authentication process:
-
Authorization:
Bearer {{=token.Access}}
For further information, please check here.
Template Fields define custom and/or compound data types to enable flexible modelling of entities' fields.
- ShortText
Data type: DT_WSTR ( length 255 )
- LongText
Data type: DT_WSTR ( length 1000 )
- DateTime
Data type: DT_DBTIMESTAMP
- Number
Data type: DT_R8
- Ref
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name.
-
Uses template:
- Identity
-
Field components:
-
Uses template:
ShortText. - Contains the following components: id, displayName, thumbnails.
For further information, please check here.
-
Uses template:
- IdentitySet
-
Field components:
-
Uses template:
Identity. - Contains the following components: user, device, application, group, conversation.
For further information, please check here.
-
Uses template:
- SharepointIds
-
Field components:
-
Uses template:
ShortText. - Contains the following components: listId, listItemId, listItemUniqueId, siteId, siteUrl, tenantId, webId.
For further information, please check here.
-
Uses template:
- ItemReference
-
Field components:
-
Uses template:
ShortText. - Contains the following components: driveId, driveType, id, name, path, shareId, sharepointIds.
For further information, please check here.
-
Uses template:
- File
Field components:
-
Uses template:
ShortText. - Contains the following components: mimeType, hashes.
-
Uses template:
- FileSystemInfo
Field components:
-
Uses template:
DateTime. - Contains the following components: createdDateTime, lastAccessedDateTime, lastModifiedDateTime.
-
Uses template:
- Thumbnail
Field components:
-
Uses template:
LongText. - Contains the following components: width, height, url.
-
Uses template:
- Folder
-
Field components:
- Contains the following components: childCount, view.
For further information, please check here.
- GeoCoordinates
-
Field components:
- Contains the following components: altitude, latitude, longitude.
For further information, please check here.
- Photo
-
Field components:
-
Uses template:
ShortText. - Contains the following components: cameraMake, cameraModel, exposureDenominator, exposureNumerator, fNumber, focalLength, iso, orientation, takenDateTime.
For further information, please check here.
-
Uses template:
- Video
Field components:
-
Uses template:
ShortText. - Contains the following components: audioBitsPerSample, audioChannels, audioFormat, audioSamplesPerSecond, bitrate, duration, fourCC, frameRate, height, width.
-
Uses template:
- Audio
Field components:
-
Uses template:
ShortText. - Contains the following components: album, albumArtist, artist, bitrate, composers, copyright, disc, discCount, duration, genre, hasDrm, isVariableBitrate, title, track, trackCount, year.
-
Uses template:
- Analytics
Field components:
- Contains the following components: allTime, lastSevenDays.
- PhysicalAddress
-
Field components:
-
Uses template:
ShortText. - Contains the following components: city, countryOrRegion, postalCode, state, street.
For further information, please check here.
-
Uses template:
- Location
-
Field components:
-
Uses template:
PhysicalAddress. - Contains the following components: address, coordinates, displayName, locationEmailAddress, locationUri, locationType, uniqueId, uniqueIdType.
For further information, please check here.
-
Uses template:
- EmailAddress
Field components:
-
Uses template:
ShortText. - Contains the following components: name, address.
-
Uses template:
- Attachment
Field components:
-
Uses template:
ShortText. - Contains the following components: id, contentType, contentLocation, contentBytes, contentId, isInline, lastModifiedDateTime, name, size.
-
Uses template:
- Body
-
Field components:
-
Uses template:
ShortText. - Contains the following components: contentType, content.
For further information, please check here.
-
Uses template:
- DateTimeTimeZone
-
Field components:
-
Uses template:
DateTime. - Contains the following components: dateTime, timeZone.
For further information, please check here.
-
Uses template:
- OneNoteLink
Field components:
-
Uses template:
ShortText. - Contains the following components: oneNoteClientUrl, oneNoteWebUrl.
-
Uses template:
- SiteT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name, description, createdDateTime, lastModifiedDateTime, webUrl.
-
Uses template:
- SiteListT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, name, createdDateTime, lastModifiedDateTime, list, columns.
-
Uses template:
- SiteListItemT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, contentType, createdBy, createdDateTime, eTag, lastModifiedBy, lastModifiedDateTime, parentReference, webUrl.
-
Uses template:
- MessageT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, bccRecipients, body, bodyPreview, categories, ccRecipients, changeKey, conversationId, conversationIndex, createdDateTime, flag, from, hasAttachments, importance, inferenceClassification, internetMessageHeaders, internetMessageId, isDeliveryReceiptRequested, isDraft, isRead, isReadReceiptRequested, lastModifiedDateTime, parentFolderId, receivedDateTime, replyTo, sender, sentDateTime, subject, toRecipients, uniqueBody, webLink, extensions, multiValueExtendedProperties, singleValueExtendedProperties.
-
Uses template:
- EventT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, subject, bodyPreview, body, start, end, location, locations, attendees, organizer, allowNewTimeProposals, transactionId, isOnlineMeeting, onlineMeetingProvider.
-
Uses template:
- DriveT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, driveType, owner, quota, createdBy, createdDateTime, description, following, items, lastModifiedBy, lastModifiedDateTime, name, root, sharepointIds, special, system, webUrl.
-
Uses template:
- DriveItemT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, audio, createdBy, createdDateTime, cTag, deleted, description, eTag, file, fileSystemInfo, folder, image, lastModifiedBy, lastModifiedDateTime, location, name, package, parentReference, pendingOperations, photo, publication, remoteItem, searchResult, shared, sharepointIds, size, specialFolder, video, webDavUrl, webUrl.
-
Uses template:
- VendorInformation
Field components:
-
Uses template:
ShortText. - Contains the following components: provider, providerVersion, subProvider, vendor.
-
Uses template:
- Member
Field components:
-
Uses template:
ShortText. - Contains the following components: id, roles, displayName, userId, email, user@odata.bind.
-
Uses template:
- Channel
Field components:
-
Uses template:
ShortText. - Contains the following components: id, description, displayName, isFavoriteByDefault, email, webUrl, membershipType, createdDateTime, tabs.
-
Uses template:
- ChatMessage
-
Field components:
-
Uses template:
ShortText. - Contains the following components: id, replyToId, etag, messageType, createdDateTime, lastModifiedDateTime, lastEditedDateTime, deletedDateTime, subject, summary, importance, locale, policyViolation, from, body, attachments, mentions, reactions.
For further information, please check here.
-
Uses template:
- ShiftItem
-
Field components:
-
Uses template:
ShortText. - Contains the following components: displayName, notes, startDateTime, endDateTime, theme, activities.
For further information, please check here.
-
Uses template:
- TimeOffItem
-
Field components:
-
Uses template:
ShortText. - Contains the following components: timeOffReasonId, startDateTime, endDateTime, theme.
For further information, please check here.
-
Uses template:
- LinkedResource
-
Field components:
-
Uses template:
ShortText. - Contains the following components: id, applicationName, displayName, externalId, webUrl.
For further information, please check here.
-
Uses template:
- Range
Field components:
-
Uses template:
ShortText. - Contains the following components: address, addressLocal, cellCount, columnCount, columnHidden, columnIndex, formulas, formulasLocal, formulasR1C1, hidden, numberFormat, rowCount, rowHidden, rowIndex, text, valueTypes, values.
-
Uses template:
- Language
Field components:
-
Uses template:
ShortText. - Contains the following components: locale, displayName.
-
Uses template:
- CalendarT
Field components:
-
Uses template:
ShortText. - Contains the following components: id, @odata.id, name, color, changeKey, canShare, canViewPrivateItems, hexColor, canEdit, allowedOnlineMeetingProviders, defaultOnlineMeetingProvider, isTallyingResponses, isRemovable, owner.
-
Uses template:
- ContactT
-
Field components:
-
Uses template:
ShortText. - Contains the following components: id, assistantName, birthday, businessAddress, businessHomePage, businessPhones, categories, changeKey, children, companyName, createdDateTime, department, displayName, emailAddresses, fileAs, generation, givenName, homeAddress, homePhones, imAddresses, initials, jobTitle, lastModifiedDateTime, manager, middleName, mobilePhone, nickName, officeLocation, otherAddress, parentFolderId, personalNotes, profession, spouseName, surname, title, yomiCompanyName, yomiGivenName, yomiSurname, photo.
For further information, please check here.
-
Uses template:
- InsightsResourceReference
-
Field components:
-
Uses template:
ShortText. - Contains the following components: id, webUrl, type.
For further information, please check here.
-
Uses template:
- AppRoleAssignment
-
Field components:
-
Uses template:
ShortText. - Contains the following components: id, creationTimestamp, principalDisplayName, principalId, principalType, resourceDisplayName, resourceId, appRoleId.
For further information, please check here.
-
Uses template:
Template Resources enable the reuse of fields and actions across multiple resources.
- [Read] action
-
The result is extracted from:{{=response.value}}.
The result is paginated.The following request parameters will be automatically processed:
-
$select:
{{=_.filter(parameters.fields, function(item) { return item.indexOf('.') == -1; }).join()}} -
$top:
{{=parameters.batchSize}} -
$skiptoken:
{{=parameters.iterator}} -
Prefer:
odata.include-annotations="OData.Community.Display.V1.FormattedValue", odata.maxpagesize={{=parameters.batchSize}} -
_includeUserParameters:
{{=parameters}}
-
$select:
- [Create] action
-
The action uses POST method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Update] action
-
The action uses PATCH method.The following request parameters will be automatically processed:
-
_includeUserParameters:
{{=parameters}} -
application/json:
{{=item}}
-
_includeUserParameters:
- [Delete] action
-
The action uses DELETE method.
- [Read] action
-
The result is extracted from:{{=Graph.getResultFromCSV(response)}}.The action has the following user-defined parameters:
- periodDate: Required. Specify period or date parameter.
- Report Refresh Date
Template: DateTime.
- Report Period
Template: ShortText.
- Report Date
Template: DateTime.
Resources represent entities exposed by the service. The API endpoints are grouped by resources.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/drives.The following request parameters will be automatically processed:
-
top:
For further information check here.
-
top:
- [Read search] action
-
The result is extracted from:{{=Graph.searchData(parameters, 'drive')}}.
The result is paginated.The action has the following user-defined parameters:
- query: Required. Specify query term.
For further information check here.
The resource includes the fields from the DriveT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.FileManager.getChildrenUrl(parameters.path)}}.The action has the following user-defined parameters:
- path: Required. Specify parent path.
The following request parameters will be automatically processed:
-
$select:
{{=_.filter(parameters.fields, function(item) { return item.indexOf('.') == -1; }).join()}}
For further information check here.
- [Read shared] action
-
Endpoint URL address:
/drive/sharedWithMe.For further information check here.
- [Read recent] action
-
Endpoint URL address:
/drive/recent.For further information check here.
- [Read search] action
-
Endpoint URL address:
/root/search(q='{{=parameters.search}}').The action has the following user-defined parameters:
- search: Required. Specify search query.
For further information check here.
- [Create] action
-
The result is extracted from:{{=Graph.createDriveItem(item)}}.
- [Update] action
-
Endpoint URL address:
{{=item.path}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=item.path}}.For further information check here.
The resource includes the fields from the DriveItemT template.
- content
Data type: DT_IMAGE The value is gathered from
/drive/items/{{=item.id}}/contentaddress.- path
Template: ShortText. The gathered value is processed with
{{=item.parentReference.path + '/' + item.name}}expression.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/sites.For further information check here.
- [Read search] action
-
The result is extracted from:{{=Graph.searchData(parameters, 'site')}}.
The result is paginated.The action has the following user-defined parameters:
- query: Required. Specify query term.
For further information check here.
The resource includes the fields from the SiteT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/lists.The following request parameters will be automatically processed:
-
expand:
columns
For further information check here.
-
expand:
- [Read search] action
-
The result is extracted from:{{=Graph.searchData(parameters, 'list')}}.
The result is paginated.The action has the following user-defined parameters:
- query: Required. Specify query term.
For further information check here.
- [Create] action
-
Endpoint URL address:
/lists.For further information check here.
The resource includes the fields from the SiteListT template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}/items.The action has the following user-defined parameters:
- list_id: Required. Specify list identifier.
The following request parameters will be automatically processed:
-
expand:
fields
For further information check here.
- [Read search] action
-
The result is extracted from:{{=Graph.searchData(parameters, 'listItem')}}.
The result is paginated.The action has the following user-defined parameters:
- query: Required. Specify query term.
For further information check here.
- [Create] action
-
Endpoint URL address:
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}/items.The action has the following user-defined parameters:
- list_id: Required. Specify list identifier.
For further information check here.
- [Update] action
-
Endpoint URL address:
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}/items/{{=item.id}}.The action has the following user-defined parameters:
- list_id: Required. Specify list identifier.
For further information check here.
- [Delete] action
-
Endpoint URL address:
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}/items/{{=item.id}}.The action has the following user-defined parameters:
- list_id: Required. Specify list identifier.
For further information check here.
The resource includes the fields from the SiteListItemT template.
- versions
A read-only field. The value is gathered from
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}/items/{{=item.id}}/versionsaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
- Contains the following components: id, lastModifiedBy, lastModifiedDateTime.
- analytics
Template: Analytics. A read-only field. The value is gathered from
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}/items/{{=item.id}}/analyticsaddress.
- [External]
-
The external fields URL address:
/lists/{{=Graph.UI.SiteEditor.getValue(parameters)}}. The external fields list is extracted from:{{=response.columns}}.- fields.{{=external.name}}
Template: {{=Graph.getListColumnTemplate(external)}}. ( length {{=external.text && external.text.maxLength}} ) Before setting, the value is processed with
{{=Graph.setSiteListValue(value)}}expression.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users.For further information check here.
- [Read deleted] action
-
Endpoint URL address:
/directory/deletedItems/microsoft.graph.user.For further information check here.
- [Read delta] action
-
Endpoint URL address:
/users/delta.For further information check here.
- [Create] action
-
Endpoint URL address:
/users.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
Template: ShortText.
- mailNickname
Template: ShortText.
- otherMails
Template: LongText. A composite field.
- proxyAddresses
Template: LongText. A composite field.
- userPrincipalName
Template: ShortText.
- accountEnabled
Data type: DT_BOOL
- onPremisesImmutableId
Template: ShortText.
- passwordProfile
Field components:
-
Uses template:
ShortText. - Contains the following components: forceChangePasswordNextSignIn, forceChangePasswordNextSignInWithMfa, password.
-
Uses template:
- aboutMe
Template: ShortText.
- birthday
Template: DateTime.
- businessPhones
Template: LongText. A composite field.
- city
Template: ShortText.
- country
Template: ShortText.
- department
Template: ShortText.
- givenName
Template: ShortText.
- hireDate
Template: DateTime.
- interests
Template: LongText. A composite field.
- jobTitle
Template: ShortText.
- mobilePhone
Template: ShortText.
- mySite
Template: ShortText.
- officeLocation
Template: ShortText.
- passwordPolicies
Template: LongText.
- pastProjects
Template: LongText. A composite field.
- postalCode
Template: ShortText.
- preferredLanguage
Template: ShortText.
- responsibilities
Template: LongText. A composite field.
- schools
Template: LongText. A composite field.
- skills
Template: LongText. A composite field.
- state
Template: ShortText.
- streetAddress
Template: ShortText.
- surname
Template: ShortText.
- usageLocation
Template: ShortText.
- userType
Template: ShortText.
- appRoleAssignments
A read-only field. The value is gathered from
/users/{{=item.id}}/appRoleAssignmentsaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
-
Uses template:
AppRoleAssignment.
- calendars
A read-only field. The value is gathered from
/users/{{=item.id}}/calendarsaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
-
Uses template:
CalendarT.
- events
A read-only field. The value is gathered from
/users/{{=item.id}}/eventsaddress. Field components:- An array.
-
Uses template:
EventT.
- mailFolders
A read-only field. The value is gathered from
/users/{{=item.id}}/mailFoldersaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
- Contains the following components: id, displayName, parentFolderId, childFolderCount, unreadItemCount, totalItemCount.
- manager
A read-only field. The value is gathered from
/users/{{=item.id}}/manageraddress. The gathered value is processed with{{=response[field.name]}}expression. Field components:-
Uses template:
ShortText. - Contains the following components: id, displayName, jobTitle, mail, userPrincipalName.
-
Uses template:
- mailbox_settings
A read-only field. The value is gathered from
/users/{{=item.id}}/mailboxSettingsaddress. The gathered value is processed with{{=response[field.name]}}expression. Field components:-
Uses template:
ShortText. - Contains the following components: automaticRepliesSetting, timeZone, language, workingHours, dateFormat, timeFormat, delegateMeetingMessageDeliveryOptions.
-
Uses template:
- categories
A read-only field. The value is gathered from
/users/{{=item.id}}/outlook/masterCategoriesaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
- Contains the following components: id, displayName, color.
- languages
A read-only field. The value is gathered from
/users/{{=item.id}}/outlook/supportedLanguagesaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
-
Uses template:
Language.
- photo
Data type: DT_IMAGE A read-only field. The value is gathered from
/users/{{=item.id}}/photo/$valueaddress.
Based on resource template Base.
- [Read] action
-
The result is extracted from:.
- [Read shared] action
-
Endpoint URL address:
/users/{{=parameters.users_id}}/insights/shared.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- [Read trending] action
-
Endpoint URL address:
/users/{{=parameters.users_id}}/insights/trending.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- [Read used] action
-
Endpoint URL address:
/users/{{=parameters.users_id}}/insights/used.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- id
Template: ShortText.
- resourceVisualization
-
Field components:
-
Uses template:
ShortText. - Contains the following components: title, type, mediaType, previewImageUrl, previewText, containerWebUrl, containerDisplayName, containerType.
For further information, please check here.
-
Uses template:
- resourceReference
Template: InsightsResourceReference.
- lastShared
Field components:
-
Uses template:
DateTime. - Contains the following components: sharedDateTime, sharingSubject, sharingType, sharedBy, sharingReference.
-
Uses template:
- weight
Data type: DT_R8
- lastUsed
Field components:
-
Uses template:
DateTime. - Contains the following components: lastAccessedDateTime, lastModifiedDateTime.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups.For further information check here.
- [Read deleted] action
-
Endpoint URL address:
/directory/deletedItems/microsoft.graph.group.For further information check here.
- [Create] action
-
Endpoint URL address:
/groups.For further information check here.
- [Update] action
-
Endpoint URL address:
/groups/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/groups/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- description
Template: ShortText.
Template: ShortText.
- mailEnabled
Data type: DT_BOOL
- mailNickname
Template: ShortText.
- securityEnabled
Data type: DT_BOOL
- owners
Template: LongText. A composite field.
- members
Template: LongText. A composite field.
- visibility
Template: ShortText.
- allowExternalSenders
Data type: DT_BOOL
- assignedLabels
Field components:
- An array.
- Contains the following components: labelId, displayName.
- assignedLicenses
Field components:
- An array.
- Contains the following components: disabledPlans, skuId.
- autoSubscribeNewMembers
Data type: DT_BOOL
- classification
Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- deletedDateTime
Template: DateTime. A read-only field.
- expirationDateTime
Template: DateTime. A read-only field.
- groupTypes
Template: LongText. A composite field.
- hasMembersWithLicenseErrors
Data type: DT_BOOL
- hideFromAddressLists
Data type: DT_BOOL
- hideFromOutlookClients
Data type: DT_BOOL
- isSubscribedByMail
Data type: DT_BOOL
- licenseProcessingState
Template: ShortText. A read-only field.
- membershipRule
Template: ShortText.
- membershipRuleProcessingState
Template: ShortText.
- onPremisesSamAccountName
Template: ShortText.
- onPremisesSecurityIdentifier
Template: ShortText. A read-only field.
- onPremisesSyncEnabled
Data type: DT_BOOL A read-only field.
- preferredDataLocation
Template: ShortText.
- preferredLanguage
Template: ShortText.
- proxyAddresses
Template: LongText. A composite field.
- renewedDateTime
Template: DateTime. A read-only field.
- resourceBehaviorOptions
Template: LongText. A composite field.
- resourceProvisioningOptions
Template: LongText. A composite field.
- securityIdentifier
Template: ShortText.
- theme
Template: ShortText.
- unseenCount
Data type: DT_I4
- appRoleAssignments
A read-only field. The value is gathered from
/groups/{{=item.id}}/appRoleAssignmentsaddress. The gathered value is processed with{{=response.value}}expression. Field components:- An array.
-
Uses template:
AppRoleAssignment.
- events
A read-only field. The value is gathered from
/groups/{{=item.id}}/eventsaddress. Field components:- An array.
-
Uses template:
EventT.
- photo
Data type: DT_IMAGE A read-only field. The value is gathered from
/groups/{{=item.id}}/photo/$valueaddress.
Based on resource template Base.
- [Read] action
-
The result is extracted from:.
- [Read event] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/events/{{=parameters.event_id}}/attachments.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- event_id: Required. Specify event identifier.
For further information check here.
- [Read message] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/messages/{{=parameters.message_id}}/attachments.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- message_id: Required. Specify message identifier.
For further information check here.
- [Read post] action
-
Endpoint URL address:
/groups/{{=parameters.group_id}}/threads/{{=parameters.thread_id}}/posts/{id}/attachments.The action has the following user-defined parameters:
- group_id: Required. Specify group identifier.
- thread_id: Required. Specify thread identifier.
- post_id: Required. Specify post identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=item.contentLocation}}/attachments.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=item.contentLocation}}/attachments/{{=item.id}}.
The resource includes the fields from the Attachment template.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/calendars.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- [Read group] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/calendarGroups/{{=parameters.group_id}}/calendars.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- group_id: Required. Specify group identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}/calendars.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}/calendars/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}/calendars/{{=item.id}}.For further information check here.
The resource includes the fields from the CalendarT template.
- userPrincipalName
Template: ShortText.
Based on resource template Base.
- [Read] action
-
The result is extracted from:{{=Graph.searchData(parameters, 'event')}}.
The result is paginated.The action has the following user-defined parameters:
- query: Required. Specify query term.
For further information check here.
- [Read user] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/events.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- [Read calendar] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/calendar/events.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- [Read user-calendar] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/calendars/{{=parameters.calendar_id}}/events.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- calendar_id: Required. Specify calendar identifier.
- [Create] action
-
Endpoint URL address:
/users/{{=item.user_id}}/calendars/{{=item.calendar_id}}/events.For further information check here.
The resource includes the fields from the EventT template.
- user_id
Template: ShortText.
- calendar_id
Template: ShortText.
- attachments
The value is gathered from
/users/{{=parameters.user_id}}/{{=parameters.get('calendar_id' ? 'calendars/' + parameters.calendar_id : 'calendar'}}/events/{{=item.id}}/attachmentsaddress. Field components:- An array.
-
Uses template:
Attachment.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/places/microsoft.graph.room.For further information check here.
- [Read roomlist-address] action
-
Endpoint URL address:
/places/{{=parameters.roomlist_address}}/microsoft.graph.roomlist/rooms.The action has the following user-defined parameters:
- roomlist_address: Required. Specify room list email address.
For further information check here.
- [Update] action
-
Endpoint URL address:
/places/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- address
Template: PhysicalAddress.
- displayName
Template: ShortText.
- geoCoordinates
Field components:
- Contains the following components: accuracy, altitude, altitudeAccuracy, latitude, longitude.
- phone
Template: ShortText.
- nickname
Template: ShortText.
- label
Template: ShortText.
- capacity
Data type: DT_I4
- building
Template: ShortText.
- floorNumber
Data type: DT_I4
- isManaged
Data type: DT_BOOL
- isWheelChairAccessible
Data type: DT_BOOL
- bookingType
Template: ShortText.
- tags
Template: LongText. A composite field.
- audioDeviceName
Template: ShortText.
- videoDeviceName
Template: ShortText.
- displayDevice
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/contacts.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- [Read user-calendar] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/contactfolders/{{=parameters.folder_id}}/contacts.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- folder_id: Required. Specify folder identifier.
- [Create] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}/contacts.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}/contacts/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.userPrincipalName}}/contacts/{{=item.id}}.For further information check here.
The resource includes the fields from the ContactT template.
- userPrincipalName
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/applications.For further information check here.
- [Create] action
-
Endpoint URL address:
/applications.For further information check here.
- [Update] action
-
Endpoint URL address:
/applications/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/applications/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- appId
Template: ShortText.
- identifierUris
Template: LongText. A composite field.
- displayName
Template: ShortText.
- publisherDomain
Template: ShortText.
- signInAudience
Template: ShortText.
- addIns
Field components:
- An array.
- Contains the following components: id, properties, type.
- api
Field components:
-
Uses template:
LongText. - Contains the following components: acceptMappedClaims, knownClientApplications, oauth2PermissionScopes, preAuthorizedApplications, requestedAccessTokenVersion.
-
Uses template:
- appRoles
Field components:
- An array.
- Contains the following components: id, allowedMemberTypes, description, displayName, isEnabled, origin, value.
- createdDateTime
Template: DateTime. A read-only field.
- deletedDateTime
Template: DateTime. A read-only field.
- groupMembershipClaims
Template: ShortText.
- info
Field components:
-
Uses template:
ShortText. - Contains the following components: logoUrl, marketingUrl, privacyStatementUrl, supportUrl, termsOfServiceUrl.
-
Uses template:
- isFallbackPublicClient
Data type: DT_BOOL
- keyCredentials
Field components:
-
Uses template:
ShortText. - Contains the following components: customKeyIdentifier, displayName, endDateTime, keyId, startDateTime, type, usage, key.
-
Uses template:
- logo
Data type: DT_IMAGE
- optionalClaims
Field components:
-
Uses template:
LongText. - Contains the following components: idToken, accessToken, saml2Token.
-
Uses template:
- parentalControlSettings
Field components:
-
Uses template:
LongText. - Contains the following components: countriesBlockedForMinors, legalAgeGroupRule.
-
Uses template:
- passwordCredentials
Field components:
- An array.
- Contains the following components: customKeyIdentifier, displayName, endDateTime, hint, keyId, secretText, startDateTime.
- publicClient
Field components:
-
Uses template:
LongText. - Contains the following components: redirectUris.
-
Uses template:
- requiredResourceAccess
Field components:
- An array.
- Contains the following components: resourceAccess, resourceAppId.
- tags
Template: LongText. A composite field.
- tokenEncryptionKeyId
Template: ShortText.
- verifiedPublisher
Field components:
-
Uses template:
ShortText. - Contains the following components: displayName, verifiedPublisherId, addedDateTime.
-
Uses template:
- web
Field components:
-
Uses template:
ShortText. - Contains the following components: homePageUrl, implicitGrantSettings, logoutUrl, redirectUris.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/subscriptions.For further information check here.
- [Create] action
-
Endpoint URL address:
/subscriptions.For further information check here.
- [Update] action
-
Endpoint URL address:
/subscriptions/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/subscriptions/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- changeType
Template: ShortText.
- notificationUrl
Template: ShortText.
- lifecycleNotificationUrl
Template: ShortText.
- resource
Template: ShortText.
- applicationId
Template: ShortText.
- expirationDateTime
Template: DateTime.
- clientState
Template: ShortText.
- creatorId
Template: ShortText.
- includeResourceData
Template: ShortText.
- encryptionCertificate
Template: ShortText.
- encryptionCertificateId
Template: ShortText.
- latestSupportedTlsVersion
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/education/schools.For further information check here.
- [Create] action
-
Endpoint URL address:
/education/schools.For further information check here.
- [Update] action
-
Endpoint URL address:
/education/schools/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/education/schools/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- description
Template: ShortText.
- status
Template: ShortText.
- externalSource
Template: ShortText.
- principalEmail
Template: ShortText.
- principalName
Template: ShortText.
- externalPrincipalId
Template: ShortText.
- highestGrade
Template: ShortText.
- lowestGrade
Template: ShortText.
- schoolNumber
Template: ShortText.
- address
Template: PhysicalAddress.
- createdBy
Template: IdentitySet. A read-only field.
- externalId
Template: ShortText.
- phone
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/education/classes.For further information check here.
- [Create] action
-
Endpoint URL address:
/education/classes.For further information check here.
- [Update] action
-
Endpoint URL address:
/education/classes/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/education/classes/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- description
Template: ShortText.
- classCode
Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- displayName
Template: ShortText.
- externalId
Template: ShortText.
- externalName
Template: ShortText.
- externalSource
Template: ShortText.
- mailNickname
Template: ShortText.
- term
Field components:
-
Uses template:
ShortText. - Contains the following components: displayName, externalId, startDate, endDate.
-
Uses template:
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/education/classes/{{=parameters.class_id}}/teachers.The action has the following user-defined parameters:
- class_id: Required. Specify teacher identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/education/classes/{{=item.class_id}}/teachers/$ref.For further information check here.
- [Update] action
-
Endpoint URL address:
/education/users/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/education/classes/{{=item.class_id}}/teachers/{{=item.id}}/$ref.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- givenName
Template: ShortText.
- middleName
Template: ShortText.
- surname
Template: ShortText.
Template: ShortText.
- mobilePhone
Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- externalSource
Template: ShortText.
- mailingAddress
Template: PhysicalAddress.
- primaryRole
Template: ShortText.
- residenceAddress
Template: PhysicalAddress.
- class_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/education/classes/{{=parameters.class_id}}/members.The action has the following user-defined parameters:
- class_id: Required. Specify teacher identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/education/classes/{{=item.class_id}}/members/$ref.For further information check here.
- [Update] action
-
Endpoint URL address:
/education/users/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/education/classes/{{=item.class_id}}/members/{{=item.id}}/$ref.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- givenName
Template: ShortText.
- middleName
Template: ShortText.
- surname
Template: ShortText.
Template: ShortText.
- mobilePhone
Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- externalSource
Template: ShortText.
- mailingAddress
Template: PhysicalAddress.
- primaryRole
Template: ShortText.
- residenceAddress
Template: PhysicalAddress.
- teacher
Field components:
-
Uses template:
ShortText. - Contains the following components: externalId, teacherNumber.
-
Uses template:
- class_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/messages.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- [Read search] action
-
The result is extracted from:{{=Graph.searchData(parameters, 'message')}}.
The result is paginated.The action has the following user-defined parameters:
- query: Required. Specify query term.
For further information check here.
- [Create] action
-
Endpoint URL address:
/users/{{=item.user_id}}/messages.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.user_id}}/messages/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.user_id}}/messages/{{=item.id}}.For further information check here.
The resource includes the fields from the MessageT template.
- user_id
A key field. Template: ShortText.
- attachments
The value is gathered from
/users/{{=parameters.user_id}}/messages/{{=item.id}}/attachmentsaddress. Field components:- An array.
-
Uses template:
Attachment.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/onenote/notebooks.For further information check here.
- [Create] action
-
Endpoint URL address:
/onenote/notebooks.For further information check here.
- id
A key field. Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- createdDateTime
Template: DateTime. A read-only field.
- isDefault
Data type: DT_BOOL
- isShared
Data type: DT_BOOL
- lastModifiedBy
Template: IdentitySet.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- links
Template: OneNoteLink.
- displayName
Template: ShortText.
- sectionGroupsUrl
Template: ShortText.
- sectionsUrl
Template: ShortText.
- self
Template: ShortText.
- userRole
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/onenote/sections.For further information check here.
- [Create] action
-
Endpoint URL address:
/onenote/notebooks/{{=item.notebook_id}}/sections.For further information check here.
- id
A key field. Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- createdDateTime
Template: DateTime. A read-only field.
- isDefault
Data type: DT_BOOL
- lastModifiedBy
Template: IdentitySet. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- links
Template: OneNoteLink.
- displayName
Template: ShortText.
- pagesUrl
Template: ShortText.
- self
Template: ShortText.
- notebook_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/onenote/pages.For further information check here.
- [Create] action
-
Endpoint URL address:
/onenote/sections/{{=item.section_id}}/pages.For further information check here.
- [Update] action
-
Endpoint URL address:
/onenote/pages/{{=item.id}}/content.For further information check here.
- [Delete] action
-
Endpoint URL address:
/onenote/pages/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- content
Template: ShortText.
- contentUrl
Template: ShortText.
- createdByAppId
Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- level
Data type: DT_I4
- links
Template: OneNoteLink.
- order
Data type: DT_I4
- self
Template: ShortText.
- title
Template: ShortText.
- section_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/people.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- id
A key field. Template: ShortText.
- birthday
Template: ShortText.
- companyName
Template: ShortText.
- department
Template: ShortText.
- displayName
Template: ShortText.
- scoredEmailAddresses
Field components:
- An array.
- Contains the following components: address, relevanceScore.
- givenName
Template: ShortText.
- imAddress
Template: ShortText.
- isFavorite
Data type: DT_BOOL
- jobTitle
Template: ShortText.
- officeLocation
Template: ShortText.
- personNotes
Template: ShortText.
- personType
Field components:
-
Uses template:
ShortText. - Contains the following components: class, subclass.
-
Uses template:
- phones
Field components:
- An array.
- Contains the following components: number, type.
- postalAddresses
Field components:
- An array.
-
Uses template:
Location.
- profession
Template: ShortText.
- surname
Template: ShortText.
- userPrincipalName
Template: ShortText.
- websites
Field components:
- An array.
- Contains the following components: type, address, displayName.
- yomiCompany
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/auditLogs/directoryaudits.The following request parameters will be automatically processed:
-
$select:
For further information check here.
-
$select:
- id
Template: ShortText.
- activityDateTime
Template: DateTime.
- activityDisplayName
Template: ShortText.
- additionalDetails
Field components:
- An array.
- Contains the following components: key, value.
- category
Template: ShortText.
- correlationId
Template: ShortText.
- initiatedBy
Field components:
-
Uses template:
Identity. - Contains the following components: app, user.
-
Uses template:
- loggedByService
Template: ShortText.
- result
Template: ShortText.
- resultReason
Template: ShortText.
- targetResources
Field components:
- An array.
- Contains the following components: id, displayName, type, userPrincipalName, groupType, modifiedProperties.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/auditLogs/signIns.The following request parameters will be automatically processed:
-
$select:
For further information check here.
-
$select:
- id
Template: ShortText.
- createdDateTime
Template: DateTime.
- appDisplayName
Template: ShortText.
- appId
Template: ShortText.
- ipAddress
Template: ShortText.
- clientAppUsed
Template: ShortText.
- correlationId
Template: ShortText.
- conditionalAccessStatus
Template: ShortText.
- appliedConditionalAccessPolicy
Field components:
- An array.
- Contains the following components: id, displayName, enforcedGrantControls, enforcedSessionControls, result.
- isInteractive
Template: ShortText.
- deviceDetail
Field components:
-
Uses template:
ShortText. - Contains the following components: browser, deviceId, displayName, isCompliant, isManaged, operatingSystem, trustType.
-
Uses template:
- location
Field components:
-
Uses template:
ShortText. - Contains the following components: city, countryOrRegion, geoCoordinates, state.
-
Uses template:
- riskDetail
Template: ShortText.
- riskLevelAggregated
Template: ShortText.
- riskLevelDuringSignIn
Template: ShortText.
- riskState
Template: ShortText.
- riskEventTypes
Template: LongText. A composite field.
- riskEventTypes_v2
Template: LongText. A composite field.
- resourceDisplayName
Template: ShortText.
- resourceId
Template: ShortText.
- status
Field components:
-
Uses template:
ShortText. - Contains the following components: additionalDetails, errorCode, failureReason.
-
Uses template:
- userDisplayName
Template: ShortText.
- userId
Template: ShortText.
- userPrincipalName
Template: ShortText.
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getTeamsDeviceUsageUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read count] action
-
Endpoint URL address:
/reports/getTeamsDeviceUsageUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read distribution] action
-
Endpoint URL address:
/reports/getTeamsDeviceUsageDistributionUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Last Activity Date
Template: DateTime.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Used Web
Data type: DT_BOOL
- Used Windows Phone
Data type: DT_BOOL
- Used iOS
Data type: DT_BOOL
- Used Mac
Data type: DT_BOOL
- Used Android Phone
Data type: DT_BOOL
- Used Windows
Data type: DT_BOOL
- Web
Data type: DT_BOOL
- Windows Phone
Data type: DT_BOOL
- Android Phone
Data type: DT_BOOL
- Mac
Data type: DT_BOOL
- Windows
Data type: DT_BOOL
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getTeamsUserActivityUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read activity] action
-
Endpoint URL address:
/reports/getTeamsUserActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getTeamsUserActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Last Activity Date
Template: DateTime.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Assigned Products
Data type: DT_I4
- Team Chat Message Count
Data type: DT_I4
- Private Chat Message Count
Data type: DT_I4
- Call Count
Data type: DT_I4
- Meeting Count
Data type: DT_I4
- Has Other Action
Data type: DT_BOOL
- Team Chat Messages
Data type: DT_I4
- Private Chat Messages
Data type: DT_I4
- Calls
Data type: DT_I4
- Meetings
Data type: DT_I4
- Other Actions
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getEmailActivityUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read activity] action
-
Endpoint URL address:
/reports/getEmailActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getEmailActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Send Count
Data type: DT_I4
- Receive Count
Data type: DT_I4
- Read Count
Data type: DT_I4
- Assigned Products
Data type: DT_I4
- Send
Data type: DT_I4
- Receive
Data type: DT_I4
- Read
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getEmailAppUsageUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read apps] action
-
Endpoint URL address:
/reports/getEmailAppUsageAppsUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getEmailAppUsageUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read versions] action
-
Endpoint URL address:
/reports/getEmailAppUsageVersionsUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Mail For Mac
Data type: DT_BOOL
- Outlook For Mac
Data type: DT_BOOL
- Outlook For Windows
Data type: DT_BOOL
- Outlook For Mobile
Data type: DT_BOOL
- Other For Mobile
Data type: DT_BOOL
- Outlook For Web
Data type: DT_BOOL
- POP3 App
Data type: DT_BOOL
- IMAP4 App
Data type: DT_BOOL
- SMTP App
Data type: DT_BOOL
- Outlook 2016
Data type: DT_I4
- Outlook 2013
Data type: DT_I4
- Outlook 2010
Data type: DT_I4
- Outlook 2007
Data type: DT_I4
- Undetermined
Data type: DT_I4
- Outlook M365
Data type: DT_I4
- Outlook 2019
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getMailboxUsageDetail({{=parameters.periodDate}}).For further information check here.
- [Read mailbox] action
-
Endpoint URL address:
/reports/getMailboxUsageMailboxCounts({{=parameters.periodDate}}).For further information check here.
- [Read quota] action
-
Endpoint URL address:
/reports/getMailboxUsageQuotaStatusMailboxCounts({{=parameters.periodDate}}).For further information check here.
- [Read storage] action
-
Endpoint URL address:
/reports/getMailboxUsageStorage({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Date
Template: DateTime.
- Created Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Item Count
Data type: DT_I4
- Storage Used (Byte)
Data type: DT_I4
- Issue Warning Quota (Byte)
Data type: DT_I4
- Prohibit Send Quota (Byte)
Data type: DT_I4
- Prohibit Send/Receive Quota (Byte)
Data type: DT_I4
- Deleted Item Count
Data type: DT_I4
- Deleted Item Size (Byte)
Data type: DT_I4
- Total
Data type: DT_I4
- Active
Data type: DT_I4
- Under Limit
Data type: DT_I4
- Warning Issued
Data type: DT_I4
- Send Prohibited
Data type: DT_I4
- Send/Receive Prohibited
Data type: DT_I4
- Indeterminate
Data type: DT_I4
- [Read] action
-
Endpoint URL address:
/reports/getOffice365ActivationsUserDetail.
The result is extracted from:{{=Graph.getResultFromCSV(response)}}.For further information check here.
- [Read activation] action
-
Endpoint URL address:
/reports/getOffice365ActivationCounts.
The result is extracted from:{{=Graph.getResultFromCSV(response)}}.For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getOffice365ActivationsUserCounts.
The result is extracted from:{{=Graph.getResultFromCSV(response)}}.For further information check here.
- Report Refresh Date
Template: DateTime.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- Product Type
Template: ShortText.
- Last Activated Date
Template: DateTime.
- Windows
Data type: DT_I4
- Mac
Data type: DT_I4
- Windows 10 Mobile
Data type: DT_I4
- iOS
Data type: DT_I4
- Android
Data type: DT_I4
- Activated On Shared Computer
Data type: DT_I4
- Assigned
Data type: DT_I4
- Activated
Data type: DT_I4
- Shared Computer Activation
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getOffice365ActiveUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getOffice365ActiveUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read services] action
-
Endpoint URL address:
/reports/getOffice365ServicesUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Has Exchange License
Data type: DT_BOOL
- Has OneDrive License
Data type: DT_BOOL
- Has SharePoint License
Data type: DT_BOOL
- Has Skype For Business License
Data type: DT_BOOL
- Has Yammer License
Data type: DT_BOOL
- Has Teams License
Data type: DT_BOOL
- Exchange Last Activity Date
Template: DateTime.
- OneDrive Last Activity Date
Template: DateTime.
- SharePoint Last Activity Date
Template: DateTime.
- Skype For Business Last Activity Date
Template: DateTime.
- Yammer Last Activity Date
Template: DateTime.
- Teams Last Activity Date
Template: DateTime.
- Exchange License Assign Date
Template: DateTime.
- OneDrive License Assign Date
Template: DateTime.
- SharePoint License Assign Date
Template: DateTime.
- Skype For Business License Assign Date
Template: DateTime.
- Yammer License Assign Date
Template: DateTime.
- Teams License Assign Date
Template: DateTime.
- Assigned Products
Data type: DT_I4
- Office 365
Data type: DT_I4
- Exchange
Data type: DT_I4
- OneDrive
Data type: DT_I4
- SharePoint
Data type: DT_I4
- Skype For Business
Data type: DT_I4
- Yammer
Data type: DT_I4
- Teams
Data type: DT_I4
- Exchange Active
Data type: DT_I4
- Exchange Inactive
Data type: DT_I4
- OneDrive Active
Data type: DT_I4
- OneDrive Inactive
Data type: DT_I4
- SharePoint Active
Data type: DT_I4
- SharePoint Inactive
Data type: DT_I4
- Skype For Business Active
Data type: DT_I4
- Skype For Business Inactive
Data type: DT_I4
- Yammer Active
Data type: DT_I4
- Yammer Inactive
Data type: DT_I4
- Teams Active
Data type: DT_I4
- Teams Inactive
Data type: DT_I4
- Office 365 Active
Data type: DT_I4
- Office 365 Inactive
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getOffice365GroupsActivityDetail({{=parameters.periodDate}}).For further information check here.
- [Read activity] action
-
Endpoint URL address:
/reports/getOffice365GroupsActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read group] action
-
Endpoint URL address:
/reports/getOffice365GroupsActivityGroupCounts({{=parameters.periodDate}}).For further information check here.
- [Read storage] action
-
Endpoint URL address:
/reports/getOffice365GroupsActivityStorage({{=parameters.periodDate}}).For further information check here.
- [Read file] action
-
Endpoint URL address:
/reports/getOffice365GroupsActivityFileCounts({{=parameters.periodDate}}).For further information check here.
- Group Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Owner Principal Name
Template: ShortText.
- Last Activity Date
Template: DateTime.
- Group Type
Template: ShortText.
- Member Count
Data type: DT_I4
- Guest Count
Data type: DT_I4
- Exchange Received Email Count
Data type: DT_I4
- SharePoint Active File Count
Data type: DT_I4
- Yammer Posted Message Count
Data type: DT_I4
- Yammer Read Message Count
Data type: DT_I4
- Yammer Liked Message Count
Data type: DT_I4
- Exchange Mailbox Total Item Count
Data type: DT_I4
- Exchange Mailbox Storage Used (Byte)
Data type: DT_I4
- SharePoint Total File Count
Data type: DT_I4
- SharePoint Site Storage Used (Byte)
Data type: DT_I4
- Group Id
Template: ShortText.
- Exchange Emails Received
Data type: DT_I4
- Yammer Messages Posted
Data type: DT_I4
- Yammer Messages Read
Data type: DT_I4
- Yammer Messages Liked
Data type: DT_I4
- Total
Data type: DT_I4
- Active
Data type: DT_I4
- Mailbox Storage Used (Byte)
Data type: DT_I4
- Site Storage Used (Byte)
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getOneDriveActivityUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getOneDriveActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read file] action
-
Endpoint URL address:
/reports/getOneDriveActivityFileCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Viewed Or Edited File Count
Data type: DT_I4
- Synced File Count
Data type: DT_I4
- Shared Internally File Count
Data type: DT_I4
- Shared Externally File Count
Data type: DT_I4
- Assigned Products
Data type: DT_I4
- Viewed Or Edited
Data type: DT_I4
- Synced
Data type: DT_I4
- Shared Internally
Data type: DT_I4
- Shared Externally
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getOneDriveUsageAccountDetail({{=parameters.periodDate}}).For further information check here.
- [Read account] action
-
Endpoint URL address:
/reports/getOneDriveUsageAccountCounts({{=parameters.periodDate}}).For further information check here.
- [Read file] action
-
Endpoint URL address:
/reports/getOneDriveUsageFileCounts({{=parameters.periodDate}}).For further information check here.
- [Read storage] action
-
Endpoint URL address:
/reports/getOneDriveUsageStorage({{=parameters.periodDate}}).For further information check here.
- Site URL
Template: ShortText.
- Owner Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Last Activity Date
Template: DateTime.
- File Count
Data type: DT_I4
- Active File Count
Data type: DT_I4
- Storage Used (Byte)
Data type: DT_I4
- Storage Allocated (Byte)
Data type: DT_I4
- Owner Principal Name
Template: ShortText.
- Site Type
Template: ShortText.
- Total
Data type: DT_I4
- Active
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSharePointActivityUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read file] action
-
Endpoint URL address:
/reports/getSharePointActivityFileCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getSharePointActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read pages] action
-
Endpoint URL address:
/reports/getSharePointActivityPages({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Viewed Or Edited File Count
Data type: DT_I4
- Synced File Count
Data type: DT_I4
- Shared Internally File Count
Data type: DT_I4
- Shared Externally File Count
Data type: DT_I4
- Visited Page Count
Data type: DT_I4
- Assigned Products
Data type: DT_I4
- Viewed Or Edited
Data type: DT_I4
- Synced
Data type: DT_I4
- Shared Internally
Data type: DT_I4
- Shared Externally
Data type: DT_I4
- Visited Page
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSharePointSiteUsageDetail({{=parameters.periodDate}}).For further information check here.
- [Read file] action
-
Endpoint URL address:
/reports/getSharePointSiteUsageFileCounts({{=parameters.periodDate}}).For further information check here.
- [Read site] action
-
Endpoint URL address:
/reports/getSharePointSiteUsageSiteCounts({{=parameters.periodDate}}).For further information check here.
- [Read storage] action
-
Endpoint URL address:
/reports/getSharePointSiteUsageStorage({{=parameters.periodDate}}).For further information check here.
- [Read pages] action
-
Endpoint URL address:
/reports/getSharePointSiteUsagePages({{=parameters.periodDate}}).For further information check here.
- Site Id
Template: ShortText.
- Site URL
Template: ShortText.
- Owner Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Last Activity Date
Template: DateTime.
- File Count
Data type: DT_I4
- Active File Count
Data type: DT_I4
- Page View Count
Data type: DT_I4
- Visited Page Count
Data type: DT_I4
- Storage Used (Byte)
Data type: DT_I4
- Storage Allocated (Byte)
Data type: DT_I4
- Root Web Template
Template: ShortText.
- Owner Principal Name
Template: ShortText.
- Site Type
Template: ShortText.
- Total
Data type: DT_I4
- Active
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSkypeForBusinessActivityUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read activity] action
-
Endpoint URL address:
/reports/getSkypeForBusinessActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getSkypeForBusinessActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Deleted Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Total Peer-to-peer Session Count
Data type: DT_I4
- Total Organized Conference Count
Data type: DT_I4
- Total Participated Conference Count
Data type: DT_I4
- Peer-to-peer Last Activity Date
Template: DateTime.
- Organized Conference Last Activity Date
Template: DateTime.
- Participated Conference Last Activity Date
Template: DateTime.
- Peer-to-peer IM Count
Data type: DT_I4
- Peer-to-peer Audio Count
Data type: DT_I4
- Peer-to-peer Audio Minutes
Data type: DT_I4
- Peer-to-peer Video Count
Data type: DT_I4
- Peer-to-peer Video Minutes
Data type: DT_I4
- Peer-to-peer App Sharing Count
Data type: DT_I4
- Peer-to-peer File Transfer Count
Data type: DT_I4
- Organized Conference IM Count
Data type: DT_I4
- Organized Conference Audio/Video Count
Data type: DT_I4
- Organized Conference Audio/Video Minutes
Data type: DT_I4
- Organized Conference App Sharing Count
Data type: DT_I4
- Organized Conference Web Count
Data type: DT_I4
- Organized Conference Dial-in/out 3rd Party Count
Data type: DT_I4
- Organized Conference Dial-in/out Microsoft Count
Data type: DT_I4
- Organized Conference Dial-in Microsoft Minutes
Data type: DT_I4
- Organized Conference Dial-out Microsoft Minutes
Data type: DT_I4
- Paricipated Conference IM Count
Data type: DT_I4
- Participated Conference Audio/Video Count
Data type: DT_I4
- Participated Conference Audio/Video Minutes
Data type: DT_I4
- Participated Conference App Sharing Count
Data type: DT_I4
- Participated Conference Web Count
Data type: DT_I4
- Participated Conference Dial-in/out 3rd Party Count
Data type: DT_I4
- Assigned Products
Data type: DT_I4
- Peer-to-peer
Data type: DT_I4
- Organized
Data type: DT_I4
- Participated
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSkypeForBusinessDeviceUsageUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read distribution] action
-
Endpoint URL address:
/reports/getSkypeForBusinessDeviceUsageDistributionUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getSkypeForBusinessDeviceUsageUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Last Activity Date
Template: DateTime.
- Used Windows
Data type: DT_BOOL
- Used Windows Phone
Data type: DT_BOOL
- Used Android Phone
Data type: DT_BOOL
- Used iPhone
Data type: DT_BOOL
- Used iPad
Data type: DT_BOOL
- Windows
Data type: DT_I4
- Windows Phone
Data type: DT_I4
- Android Phone
Data type: DT_I4
- iPhone
Data type: DT_I4
- iPad
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSkypeForBusinessOrganizerActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getSkypeForBusinessOrganizerActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read minute] action
-
Endpoint URL address:
/reports/getSkypeForBusinessOrganizerActivityMinuteCounts({{=parameters.periodDate}}).For further information check here.
- IM
Data type: DT_I4
- Audio/Video
Data type: DT_I4
- App Sharing
Data type: DT_I4
- Web
Data type: DT_I4
- Dial-in/out 3rd Party
Data type: DT_I4
- Dial-in/out Microsoft
Data type: DT_I4
- Dial-in Microsoft
Data type: DT_I4
- Dial-out Microsoft
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSkypeForBusinessParticipantActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getSkypeForBusinessParticipantActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read minute] action
-
Endpoint URL address:
/reports/getSkypeForBusinessParticipantActivityMinuteCounts({{=parameters.periodDate}}).For further information check here.
- IM
Data type: DT_I4
- Audio/Video
Data type: DT_I4
- App Sharing
Data type: DT_I4
- Web
Data type: DT_I4
- Dial-in/out 3rd Party
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getSkypeForBusinessPeerToPeerActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getSkypeForBusinessPeerToPeerActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read minute] action
-
Endpoint URL address:
/reports/getSkypeForBusinessPeerToPeerActivityMinuteCounts({{=parameters.periodDate}}).For further information check here.
- IM
Data type: DT_I4
- Audio
Data type: DT_I4
- Video
Data type: DT_I4
- App Sharing
Data type: DT_I4
- File Transfer
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getYammerActivityUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read activity] action
-
Endpoint URL address:
/reports/getYammerActivityCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getYammerActivityUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- User State
Template: ShortText.
- State Change Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Posted Count
Data type: DT_I4
- Read Count
Data type: DT_I4
- Liked Count
Data type: DT_I4
- Assigned Products
Data type: DT_I4
- Liked
Data type: DT_I4
- Posted
Data type: DT_I4
- Read
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getYammerDeviceUsageUserDetail({{=parameters.periodDate}}).For further information check here.
- [Read distribution] action
-
Endpoint URL address:
/reports/getYammerDeviceUsageDistributionUserCounts({{=parameters.periodDate}}).For further information check here.
- [Read user] action
-
Endpoint URL address:
/reports/getYammerDeviceUsageUserCounts({{=parameters.periodDate}}).For further information check here.
- User Principal Name
Template: ShortText.
- Display Name
Template: ShortText.
- User State
Template: ShortText.
- State Change Date
Template: DateTime.
- Last Activity Date
Template: DateTime.
- Used Web
Data type: DT_I4
- Used Windows Phone
Data type: DT_I4
- Used Android Phone
Data type: DT_I4
- Used iPhone
Data type: DT_I4
- Used iPad
Data type: DT_I4
- Used Others
Data type: DT_I4
- Web
Data type: DT_I4
- Windows Phone
Data type: DT_I4
- Android Phone
Data type: DT_I4
- iPhone
Data type: DT_I4
- iPad
Data type: DT_I4
- Other
Data type: DT_I4
Based on resource template Report.
- [Read] action
-
Endpoint URL address:
/reports/getYammerGroupsActivityDetail({{=parameters.periodDate}}).For further information check here.
- [Read group] action
-
Endpoint URL address:
/reports/getYammerGroupsActivityGroupCounts({{=parameters.periodDate}}).For further information check here.
- [Read activity] action
-
Endpoint URL address:
/reports/getYammerGroupsActivityCounts({{=parameters.periodDate}}).For further information check here.
- Group Display Name
Template: ShortText.
- Is Deleted
Data type: DT_BOOL
- Owner Principal Name
Template: ShortText.
- Last Activity Date
Template: DateTime.
- Group Type
Template: ShortText.
- Office 365 Connected
Data type: DT_BOOL
- Member Count
Data type: DT_I4
- Posted Count
Data type: DT_I4
- Read Count
Data type: DT_I4
- Liked Count
Data type: DT_I4
- Total
Data type: DT_I4
- Active
Data type: DT_I4
- Liked
Data type: DT_I4
- Posted
Data type: DT_I4
- Read
Data type: DT_I4
- [Read] action
-
Endpoint URL address:
/search/query.
The result is extracted from:{{=response.value[0].hitsContainers[0].hits}}.
The action uses POST method.
The result is paginated.The action has the following user-defined parameters:
- entity: Required. Specify entity type.
- query: Required. Specify query terms.
The following request parameters will be automatically processed:
-
application/json:
{{={ requests: [{ from: parameters.iterator, size: parameters.batchSize, entityTypes: [parameters.entity], query: { queryString: parameters.query } }] } }}
For further information check here.
- hitId
Template: ShortText.
- rank
Data type: DT_I4
- summary
Template: ShortText.
- contentSource
Template: ShortText.
- [External]
-
The external fields list is extracted from:
{{=[{ name: 'resource', template: Graph.getQueryResourceTemplate(parameters.entity) }]}}.- {{=external.name}}
Template: {{=external.template}}.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/security/alerts.For further information check here.
- [Update] action
-
Endpoint URL address:
/security/alerts/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- activityGroupName
Template: ShortText. A read-only field.
- assignedTo
Template: ShortText.
- azureSubscriptionId
Template: ShortText. A read-only field.
- azureTenantId
Template: ShortText. A read-only field.
- category
Template: ShortText. A read-only field.
- closedDateTime
Template: DateTime.
- cloudAppStates
A read-only field. Field components:
- An array.
- Contains the following components: destinationServiceIp, destinationServiceName, riskScore.
- comments
Template: LongText. A composite field.
- confidence
Data type: DT_I4 A read-only field.
- createdDateTime
Template: DateTime. A read-only field.
- description
Template: ShortText.
- detectionIds
Template: LongText. A read-only field. A composite field.
- eventDateTime
Template: DateTime. A read-only field.
- feedback
Template: ShortText.
- fileStates
A read-only field. Field components:
- An array.
- Contains the following components: fileHash, name, path, riskScore.
- hostStates
A read-only field. Field components:
- An array.
- Contains the following components: fqdn, isAzureAadJoined, isAzureAadRegistered, isHybridAzureDomainJoined, netBiosName, os, privateIpAddress, publicIpAddress, riskScore.
- incidentIds
Template: LongText. A read-only field. A composite field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- malwareStates
A read-only field. Field components:
- An array.
- Contains the following components: category, family, name, severity, wasRunning.
- networkConnections
A read-only field. Field components:
- An array.
- Contains the following components: applicationName, destinationAddress, destinationDomain, destinationLocation, destinationPort, destinationUrl, direction, domainRegisteredDateTime, localDnsName, natDestinationAddress, natDestinationPort, natSourceAddress, natSourcePort, protocol, riskScore, sourceAddress, sourceLocation, sourcePort, status, urlParameters.
- processes
A read-only field. Field components:
- An array.
- Contains the following components: accountName, commandLine, createdDateTime, fileHash, integrityLevel, isElevated, name, parentProcessCreatedDateTime, parentProcessId, parentProcessName, path, processId.
- recommendedActions
Template: LongText. A read-only field. A composite field.
- registryKeyStates
A read-only field. Field components:
- An array.
- Contains the following components: hive, key, oldKey, oldValueData, oldValueName, operation, processId, valueData, valueName, valueType.
- securityResources
A read-only field. Field components:
- An array.
- Contains the following components: resource, resourceType.
- severity
Template: ShortText. A read-only field.
- sourceMaterials
Template: LongText. A read-only field. A composite field.
- status
Template: ShortText.
- tags
Template: LongText. A composite field.
- title
Template: ShortText. A read-only field.
- triggers
A read-only field. Field components:
- An array.
- Contains the following components: name, type, value.
- userStates
A read-only field. Field components:
- An array.
- Contains the following components: aadUserId, accountName, domainName, emailRole, isVpn, logonDateTime, logonId, logonIp, logonLocation, logonType, onPremisesSecurityIdentifier, riskScore, userAccountType, userPrincipalName.
- vendorInformation
Template: VendorInformation.
- vulnerabilityStates
A read-only field. Field components:
- An array.
- Contains the following components: cve, severity, wasRunning.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/informationProtection/threatAssessmentRequests.For further information check here.
- [Create] action
-
Endpoint URL address:
/informationProtection/threatAssessmentRequests.For further information check here.
- id
A key field. Template: ShortText.
- @odata.type
Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- contentType
Template: ShortText.
- expectedAssessment
Template: ShortText.
- category
Template: ShortText.
- status
Template: ShortText.
- requestSource
Template: ShortText.
- recipientEmail
Template: ShortText.
- destinationRoutingReason
Template: ShortText.
- fileName
Template: ShortText.
- contentData
Data type: DT_IMAGE
- url
Template: ShortText.
- messageUri
Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/security/secureScores.For further information check here.
- id
A key field. Template: ShortText.
- azureTenantId
Template: ShortText.
- activeUserCount
Data type: DT_I4
- createdDateTime
Template: DateTime.
- currentScore
Data type: DT_R8
- enabledServices
Template: LongText. A composite field.
- licensedUserCount
Data type: DT_I4
- maxScore
Data type: DT_R8
- averageComparativeScores
Field components:
- An array.
- Contains the following components: basis, averageScore.
- controlScores
Field components:
- An array.
- Contains the following components: controlCategory, controlName, description, score.
- vendorInformation
Template: VendorInformation.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/security/secureScoreControlProfiles.For further information check here.
- [Update] action
-
Endpoint URL address:
/security/secureScoreControlProfiles/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- azureTenantId
Template: ShortText.
- actionType
Template: ShortText.
- actionUrl
Template: ShortText.
- controlCategory
Template: ShortText.
- title
Template: ShortText.
- deprecated
Data type: DT_BOOL
- implementationCost
Template: ShortText.
- lastModifiedDateTime
Template: DateTime.
- maxScore
Data type: DT_R8
- rank
Data type: DT_I4
- remediation
Template: ShortText.
- remediationImpact
Template: ShortText.
- service
Template: ShortText.
- threats
Template: LongText. A composite field.
- tier
Template: ShortText.
- userImpact
Template: ShortText.
- complianceInformation
Field components:
- An array.
- Contains the following components: certificationName, certificationControls.
- controlStateUpdates
Field components:
- An array.
- Contains the following components: assignedTo, comment, state, updatedBy, updatedDateTime.
- vendorInformation
Template: VendorInformation.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups/{{=parameters.group_id}}/planner/plans.The action has the following user-defined parameters:
- group_id: Required. Specify group identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/planner/plans.For further information check here.
- id
A key field. Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- createdDateTime
Template: DateTime. A read-only field.
- owner
Template: ShortText.
- title
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/planner/plans/{{=parameters.plan_id}}/tasks.The action has the following user-defined parameters:
- plan_id: Required. Specify plan identifier.
For further information check here.
- [Read user] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/planner/tasks.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier.
For further information check here.
- [Read bucket] action
-
Endpoint URL address:
/planner/buckets/{{=parameters.bucket_id}}/tasks.The action has the following user-defined parameters:
- bucket_id: Required. Specify bucket identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/planner/tasks.For further information check here.
- [Update] action
-
Endpoint URL address:
/planner/tasks/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/planner/tasks/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- activeChecklistItemCount
Data type: DT_I4
- appliedCategories
Template: LongText. A composite field.
- assigneePriority
Template: ShortText.
- assignments
The gathered value is processed with
{{=_.map(value, function(v, k) { return _.extend({ id: k }, v); })}}expression. Before setting, the value is processed with{{=_.map(value, function(item) { var result = {}; result[item.id] = item; return result; })}}expression. Field components:- An array.
- Contains the following components: id, assignedBy, assignedDateTime, orderHint.
- bucketId
Template: ShortText.
- checklistItemCount
Data type: DT_I4
- completedBy
Template: IdentitySet.
- completedDateTime
Template: DateTime.
- conversationThreadId
Template: ShortText.
- createdBy
Template: IdentitySet. A read-only field.
- createdDateTime
Template: DateTime.
- dueDateTime
Template: DateTime.
- hasDescription
Data type: DT_BOOL
- orderHint
Template: ShortText.
- percentComplete
Data type: DT_I4
- planId
Template: ShortText.
- previewType
Template: ShortText.
- referenceCount
Data type: DT_I4
- startDateTime
Template: DateTime.
- title
Template: ShortText.
- details
The value is gathered from
/planner/tasks/{{=item.id}}/detailsaddress. The gathered value is processed with{{=response[field.name]}}expression. The value is sent to/planner/tasks/{{=item.id}}/detailsaddress. Field components:-
Uses template:
ShortText. - Contains the following components: checklist, description, previewType, references.
-
Uses template:
Based on resource template Base.
- [Create] action
-
Endpoint URL address:
/planner/buckets.For further information check here.
- [Update] action
-
Endpoint URL address:
/planner/buckets/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/planner/buckets/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- name
Template: ShortText.
- orderHint
Template: ShortText.
- planId
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/groups.
The result is extracted from:{{=_.filter(response.value, function(item) { return _.contains(item.resourceProvisioningOptions, 'Team'); })}}.For further information check here.
- [Read user] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/joinedTeams.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- description
Template: ShortText.
- classification
Template: ShortText.
- specialization
Template: ShortText.
- visibility
Template: ShortText.
- funSettings
Field components:
-
Uses template:
ShortText. - Contains the following components: allowGiphy, giphyContentRating, allowStickersAndMemes, allowCustomMemes.
-
Uses template:
- guestSettings
Field components:
- Contains the following components: allowCreateUpdateChannels, allowDeleteChannels.
- internalId
Template: ShortText.
- isArchived
Data type: DT_BOOL
- memberSettings
Field components:
- Contains the following components: allowCreatePrivateChannels, allowCreateUpdateChannels, allowDeleteChannels, allowAddRemoveApps, allowCreateUpdateRemoveTabs, allowCreateUpdateRemoveConnectors.
- messagingSettings
Field components:
- Contains the following components: allowUserEditMessages, allowUserDeleteMessages, allowOwnerDeleteMessages, allowTeamMentions, allowChannelMentions.
- webUrl
Template: ShortText. A read-only field.
- discoverySettings
Field components:
- Contains the following components: showInTeamsSearchAndSuggestions.
- members
Field components:
- An array.
-
Uses template:
Member.
- channels
Field components:
- An array.
-
Uses template:
Channel.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/members.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Read group] action
-
Endpoint URL address:
/groups/{{=group_id}}/members.The action has the following user-defined parameters:
- group_id: Required. Specify group identifier.
For further information check here.
- [Read channel] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels/{{=parameters.channel_id}}/members.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
- channel_id: Required. Specify channel identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/entity/{{=item.entity_id}}/members.For further information check here.
- [Update] action
-
Endpoint URL address:
/entity/{{=item.entity_id}}/members/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/entity/{{=item.entity_id}}/members/{{=item.id}}.For further information check here.
The resource includes the fields from the Member template.
- entity
A key field. Template: ShortText.
- entity_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels/{{=item.id}}.For further information check here.
The resource includes the fields from the Channel template.
- team_id
Template: ShortText.
- filesFolder
Template: DriveItemT. The value is gathered from
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels/{{=item.id}}/filesFolderaddress.- messages
The value is gathered from
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels/{{=item.id}}/messagesaddress. Field components:- An array.
-
Uses template:
ChatMessage.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels/{{=parameters.channel_id}}/messages.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
- channel_id: Required. Specify channel identifier.
For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels/{{=item.channel_id}}/chatMessages/{{=item.id}}.For further information check here.
The resource includes the fields from the ChatMessage template.
- team_id
Template: ShortText.
- channel_id
Template: ShortText.
- replies
The value is gathered from
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels/{{=parameters.channel_id}}/messages/{{=item.id}}/repliesaddress. Field components:- An array.
-
Uses template:
ChatMessage.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/appCatalogs/teamsApps.For further information check here.
- [Read team] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/installedApps.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Read user] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/teamwork/installedApps.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier.
For further information check here.
- [Update] action
-
Endpoint URL address:
/appCatalogs/teamsApps/{{=item.id}}.The following request parameters will be automatically processed:
-
application/zip:
{{=item.package}}
For further information check here.
-
application/zip:
- [Delete] action
-
Endpoint URL address:
/appCatalogs/teamsApps/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- externalId
Template: ShortText.
- displayName
Template: ShortText.
- distributionMethod
Template: ShortText.
- package
Data type: DT_IMAGE
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/channels/{{=parameters.channel_id}}/tabs.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
- channel_id: Required. Specify channel identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels/{{=item.channel_id}}/tabs.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels/{{=item.channel_id}}/tabs/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/channels/{{=item.channel_id}}/tabs/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- configuration
Field components:
-
Uses template:
ShortText. - Contains the following components: entityId, contentUrl, websiteUrl, removeUrl.
-
Uses template:
- sortOrderIndex
Template: ShortText.
- teamsApp
Field components:
-
Uses template:
ShortText. - Contains the following components: id, displayName, distributionMethod.
-
Uses template:
- webUrl
Template: ShortText.
- team_id
A key field. Template: ShortText.
- channel_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/shifts.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/shifts.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/shifts/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/shifts/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- userId
Template: ShortText.
- schedulingGroupId
Template: ShortText.
- lastModifiedBy
Template: IdentitySet.
- sharedShift
Template: ShiftItem.
- draftShift
Template: ShiftItem.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/schedulingGroups.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/schedulingGroups.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/schedulingGroups/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/schedulingGroups/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- createdDateTime
Template: DateTime.
- lastModifiedDateTime
Template: DateTime.
- displayName
Template: ShortText.
- isActive
Data type: DT_BOOL
- userIds
Template: LongText. A composite field.
- lastModifiedBy
Template: IdentitySet.
- team_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/offerShiftRequests.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/offerShiftRequests.For further information check here.
- recipientActionDateTime
Template: ShortText.
- recipientActionMessage
Template: ShortText.
- recipientUserId
Template: ShortText.
- senderShiftId
Template: ShortText.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/openShifts.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/openShifts.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}/schedule/openShifts/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}/schedule/openShifts/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- schedulingGroupId
Template: ShortText.
- draftOpenShift
Template: ShiftItem. Field components:
- Contains the following components: openSlotCount.
- sharedOpenShift
Template: ShiftItem. Field components:
- Contains the following components: openSlotCount.
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- lastModifiedBy
Template: IdentitySet.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/openShiftsChangeRequests.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/openShiftsChangeRequests.For further information check here.
- id
A key field. Template: ShortText.
- openShiftId
Template: ShortText.
- assignedTo
Template: ShortText.
- state
Template: ShortText.
- senderUserId
Template: ShortText.
- senderDateTime
Template: DateTime.
- senderMessage
Template: ShortText.
- managerUserId
Template: ShortText.
- managerActionDateTime
Template: DateTime.
- managerActionMessage
Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- lastModifiedBy
Template: IdentitySet. A read-only field.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/swapShiftsChangeRequests.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/swapShiftsChangeRequests.For further information check here.
- id
Template: ShortText.
- senderShiftId
Template: ShortText.
- recipientShiftId
Template: ShortText.
- assignedTo
Template: ShortText.
- state
Template: ShortText.
- senderUserId
Template: ShortText.
- senderDateTime
Template: DateTime.
- senderMessage
Template: ShortText.
- recipientUserId
Template: ShortText.
- recipientActionDateTime
Template: DateTime.
- recipientActionMessage
Template: ShortText.
- managerUserId
Template: ShortText.
- managerActionDateTime
Template: DateTime.
- managerActionMessage
Template: ShortText.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/timesOff.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/timesOff.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/timesOff/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/timesOff/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- userId
Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- lastModifiedBy
Template: IdentitySet. A read-only field.
- sharedTimeOff
Template: TimeOffItem.
- draftTimeOff
Template: TimeOffItem.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teams/{{=Graph.UI.TeamEditor.getValue(parameters)}}/schedule/timeOffReasons.The action has the following user-defined parameters:
- team_id: Required. Specify team identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/timeOffReasons.For further information check here.
- [Update] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/timeOffReasons/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teams/{{=item.team_id}}/schedule/timeOffReasons/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- iconType
Template: ShortText.
- isActive
Data type: DT_BOOL
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- lastModifiedBy
Template: IdentitySet.
- team_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/teamwork/workforceIntegrations.For further information check here.
- [Create] action
-
Endpoint URL address:
/teamwork/workforceIntegrations.For further information check here.
- [Update] action
-
Endpoint URL address:
/teamwork/workforceIntegrations/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/teamwork/workforceIntegrations/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- apiVersion
Data type: DT_I4
- displayName
Template: ShortText.
- encryption
Field components:
-
Uses template:
ShortText. - Contains the following components: protocol, secret.
-
Uses template:
- isActive
Data type: DT_BOOL
- supportedEntities
Template: ShortText.
- url
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/todo/lists.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
For further information check here.
- [Create] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.id}}/tasks.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- displayName
Template: ShortText.
- isOwner
Data type: DT_BOOL
- isShared
Data type: DT_BOOL
- wellknownListName
Template: ShortText.
- user_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/todo/lists/{{=parameters.tasklist_id}}/tasks.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- tasklist_id: Required. Specify task list identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.tasklist_id}}/tasks.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.tasklist_id}}/tasks/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.tasklist_id}}/tasks/{{=item.id}}.For further information check here.
- id
A key field. Template: ShortText.
- body
Template: Body.
- completedDateTime
Template: DateTimeTimeZone.
- dueDateTime
Template: DateTimeTimeZone.
- importance
Template: ShortText.
- isReminderOn
Data type: DT_BOOL
- recurrence
Field components:
- Contains the following components: pattern, range.
- reminderDateTime
Template: DateTimeTimeZone.
- status
Template: ShortText.
- title
Template: ShortText.
- createdDateTime
Template: DateTime. A read-only field.
- lastModifiedDateTime
Template: DateTime. A read-only field.
- bodyLastModifiedDateTime
Template: DateTime. A read-only field.
- linkedResources
Field components:
- An array.
-
Uses template:
LinkedResource.
- user_id
A key field. Template: ShortText.
- tasklist_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
/users/{{=parameters.user_id}}/todo/lists/{{=parameters.tasklist_id}}/tasks/{{=parameters.task_id}}/linkedResources.The action has the following user-defined parameters:
- user_id: Required. Specify user identifier - id or userPrincipalName.
- tasklist_id: Required. Specify task list identifier.
- task_id: Required. Specify task identifier.
For further information check here.
- [Create] action
-
Endpoint URL address:
/users/{{item.user_id}}/todo/lists/{{=item.tasklist_id}}/tasks/{{=item.task_id}}/linkedResources.For further information check here.
- [Update] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.tasklist_id}}/tasks/{{=item.task_id}}/linkedResources/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
/users/{{=item.user_id}}/todo/lists/{{=item.tasklist_id}}/tasks/{{=item.task_id}}/linkedResources/{{=item.id}}.For further information check here.
The resource includes the fields from the LinkedResource template.
- user_id
A key field. Template: ShortText.
- tasklist_id
A key field. Template: ShortText.
- task_id
A key field. Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getWorkbookUrl(parameters.workbook_path)}}/workbook/worksheets.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Graph.Workbook.getWorkbookUrl(item.workbook_path)}}/workbook/worksheets/add.For further information check here.
- [Update] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.id)}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.id)}}.For further information check here.
- id
A key field. Template: ShortText.
- position
Data type: DT_I4 A read-only field.
- name
Template: ShortText.
- visibility
Template: ShortText. A read-only field.
- workbook_path
Template: ShortText.
- usedRange
Template: Range. A read-only field. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, item.id)}}/usedRangeaddress.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getWorkbookUrl(parameters.workbook_path)}}/workbook/comments.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
For further information check here.
- id
A key field. Template: ShortText.
- content
Template: ShortText.
- contentType
Template: ShortText.
- replies
The value is gathered from
/workbook/comments/{{=item.id}}/repliesaddress. Field components:- An array.
- Contains the following components: id, content, contentType.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
- sheet_id: Required. Specify sheet id or name.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/add.For further information check here.
- [Update] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.id}}/delete.
The action uses POST method.For further information check here.
- id
A key field. Template: ShortText.
- highlightFirstColumn
Data type: DT_BOOL
- highlightLastColumn
Data type: DT_BOOL
- name
Template: ShortText.
- showBandedColumns
Data type: DT_BOOL
- showBandedRows
Data type: DT_BOOL
- showFilterButton
Data type: DT_BOOL
- showHeaders
Data type: DT_BOOL
- showTotals
Data type: DT_BOOL
- style
Template: ShortText.
- legacyId
Template: ShortText.
- workbook_path
Template: ShortText.
- sheet_id
Template: ShortText.
- range
Template: Range. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=item.id}}/rangeaddress.- image
Data type: DT_IMAGE The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/charts/{{=item.name}}/imageaddress. The gathered value is processed with{{=response.value}}expression.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/charts.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
- sheet_id: Required. Specify sheet id or name.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/charts.For further information check here.
- [Update] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/charts/{{=item.name}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/charts/{{=item.name}}/delete.
The action uses POST method.For further information check here.
- id
A key field. Template: ShortText.
- height
Data type: DT_I4
- left
Data type: DT_I4
- name
Template: ShortText.
- top
Data type: DT_I4
- width
Data type: DT_I4
- workbook_path
Template: ShortText.
- sheet_id
Template: ShortText.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/rows.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
- sheet_id: Required. Specify sheet id or name.
- table_id: Required. Specify table id or name.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.table_id}}/rows/add.For further information check here.
- [Update] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.table_id}}/rows/{{=item.index}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.table_id}}/rows/{{=item.index}}/delete.
The action uses POST method.For further information check here.
- index
A key field. Data type: DT_I4
- values
Template: LongText. A composite field.
- workbook_path
Template: ShortText.
- sheet_id
Template: ShortText.
- table_id
Template: ShortText.
- range
Template: Range. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/rows/{{=item.index}}/rangeaddress.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/columns.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
- sheet_id: Required. Specify sheet id or name.
- table_id: Required. Specify table id or name.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.table_id}}/columns.For further information check here.
- [Update] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.table_id}}/columns/{{=item.id}}.For further information check here.
- [Delete] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(item.workbook_path, item.sheet_id)}}/tables/{{=item.table_id}}/columns/{{=item.id}}/delete.
The action uses POST method.For further information check here.
- id
Template: ShortText.
- index
Data type: DT_I4
- name
Template: ShortText.
- values
Template: LongText. A composite field.
- workbook_path
Template: ShortText.
- sheet_id
Template: ShortText.
- table_id
Template: ShortText.
- dataBodyRange
Template: Range. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/columns/{{=item.id}}/dataBodyRangeaddress.- headerRowRange
Template: Range. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/columns/{{=item.id}}/headerRowRangeaddress.- range
Template: Range. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/columns/{{=item.id}}/rangeaddress.- totalRowRange
Template: Range. The value is gathered from
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id)}}/tables/{{=parameters.table_id}}/columns/{{=item.id}}/totalRowRangeaddress.
Based on resource template Base.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getWorkbookUrl(parameters.workbook_path)}}/workbook/names.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
For further information check here.
- [Create] action
-
Endpoint URL address:
{{=Graph.Workbook.getWorkbookUrl(item.workbook_path)}}/workbook/names/add.For further information check here.
- [Update] action
-
Endpoint URL address:
{{=Graph.Workbook.getWorkbookUrl(item.workbook_path)}}/workbook/names/{{=item.name}}.For further information check here.
- name
A key field. Template: ShortText.
- comment
Template: ShortText.
- scope
Template: ShortText.
- type
Template: ShortText.
- value
Template: LongText. A composite field.
- visible
Data type: DT_BOOL
- workbook_path
Template: ShortText.
- [Read] action
-
Endpoint URL address:
{{=Graph.Workbook.getSheetUrl(parameters.workbook_path, parameters.sheet_id) + Graph.Workbook.getRangeFragment(parameters.get('range'))}}.
The result is extracted from:{{=Graph.Workbook.getSheetData(parameters, response)}}.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
- sheet_id: Required. Specify sheet id or name.
- range: Specify range in A1-style notation. If not specified, the used range will be used.
- firstRowColumnNames: Specifies if first range row contains column names.
For further information check here.
- [Create] action
-
Endpoint URL address:
.
The result is extracted from:{{=Graph.Workbook.insertSheetData(parameters, batch)}}.The action has the following user-defined parameters:
- workbook_path: Required. Specify workbook path, including extension.
- sheet_id: Required. Specify sheet id or name.
- range: Required. Specify range in A1-style notation.
- firstRowColumnNames: Specifies if first range row contains column names.
- append: Specifies if input data is appended. Default is true.
For further information check here.
- [External]
-
The external fields list is extracted from:
{{=Graph.Workbook.getSheetFields(parameters)}}.- {{=external.name}}
Data type: {{=external.type}} ( length {{=external.length}} )
Knowledge Base
- Where can I find the documentation for the Microsoft Graph Connection?
- Resource not found Error or Scope is not valid while Generating the OAUTH Token for COZYROC Graph, Dataverse or Exchange Online connectors
- How to Register your app on Azure Portal Quick Start
What's New
2.1 SR-1
- New: Improved handling of SharePoint list lookup fields (Thank you, Eric).
- New: Included definitions to retrieve
Drivein Site/User/Group resources (Thank you, Drew).
2.1
- New: Introduced connection.
Related documentation
COZYROC SSIS+ Components Suite is free for testing in your development environment.
A licensed version can be deployed on-premises, on Azure-SSIS IR and on COZYROC Cloud.