Active
This application does not need additional settings. So you can make connectionUnique, active service acces point to a network. There are different types of connections (API key, Oauth…). More only by using your login credentials or by following the instructions below .

Microsoft SharePoint Online

	Important
Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice. Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

Important

Any references to third-party products or services do not constitute Celonis Product Documentation nor do they create any contractual obligations. This material is for informational purposes only and is subject to change without notice.

Celonis does not warrant the availability, accuracy, reliability, completeness, or usefulness of any information regarding the subject of third-party services or systems.

With Microsoft SharePoint Online modulesThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More in Boost.spaceCentralization and synchronization platform, where you can organize and manage your data. More IntegratorPart of the Boost.space system, where you can create your connections and automate your processes. More, you can monitor, retrieve, create, delete, and/or update itemsItems are rows in records (order/request/invoice/purchase...), lists, pages, sites, files, and or/folders in your Microsoft SharePoint Online account.

To use the Microsoft SharePoint Online modules, you must have a Microsoft SharePoint Online or Office 365 E3 userCan use the system on a limited basis based on the rights assigned by the admin. More account. You can create a Microsoft SharePoint Online account at www.microsoft.com.

Connect Microsoft SharePoint Online to Boost.space Integrator

It is only possible to establish a connection between Boost.space Integrator and Microsoft SharePoint Online user accounts. For more information on the Authorization Code Flow connection type used, see the Microsoft OAuth 2.0 authorization code flow documentation.

To establish the connection:

Log in to your Boost.space Integrator account, add a Microsoft SharePoint Online moduleThe module is an application or tool within the Boost.space system. The entire system is built on this concept of modularity. (module - Contacts) More to your scenarioA specific connection between applications in which data can be transferred. Two types of scenarios: active/inactive. More, and click Create a connection.
Optional: In the Connection name field, enter a name for the connection.
Optional: Click Show advanced settings and enter your custom appCreate your own custom apps to be used in the integrator engine and share them with users in your organization. client credentials and tenant ID. Refer to the Microsoft Register an App guide for more information.

If requested, use the following Redirect URI when creating your custom app: https://integrator.boost.space/oauth/cb/azure.
Click Save.
If prompted, authenticate your account and confirm access.

You have successfully established the connection. You can now edit your scenario and add more Microsoft SharePoint Online modules. If your connection requires reauthorization at any point, follow the connection renewal steps here.

	Note
	When you choose to select the Site ID from the drop-down menu, only followed sites are offered in the drop-down menu. To specify a site that is not followed, insert the Site ID manually.

Items

Watch Items

Retrieves itemItems are rows in records (order/request/invoice/purchase...) details when an item is created or updated.

Connection	Establish a connection to your Microsoft SharePoint Online.
Watch Item	Select whether you want to watch for a created or modified items.
Site ID	Enter (map) or use the ID Finder to search for the site ID of the site that you want to watch for items.
List ID	Enter (map) or select the ID of the list you want to watch for items.
Limit	Set the maximum number of items Boost.space Integrator will return during one execution cycleA cycle is the operation and commit/rollback phases of scenario execution. A scenario may have one or more cycles (one is the default)..

List Items

Retrieves all items on a specified list.

Connection	Establish a connection to your Microsoft SharePoint Online.
List Items	Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site that contains the list you want to retrieve items from.
List ID	Enter (map) or use the ID Finder to search for the list ID or select the list you want to retrieve items from.
Limit	Set the maximum number of items Boost.space Integrator will return during one execution cycle. This module has a maximum limit of 3,500 items to be returned.

Get an Item

Returns item details.

Connection	Establish a connection to your Microsoft SharePoint Online.
Get an Item	Select whether you want to specify the Site ID, the List ID, and the Item ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site that contains the list with the item you want to retrieve details for.
List ID	Enter (map) or use the ID Finder to search for the list ID or select the list that contains the item you want to retrieve details about.
Item ID	Enter (map) or use the ID Finder to search for the item ID or select the item you want to retrieve details about.

Create an Item

Creates a new item in a specified list.

Connection

Establish a connection to your Microsoft SharePoint Online.

Search Method

Select whether to specify the Site ID and the List ID from drop-down menus or manually, and item fields dynamically or in key-value pairs.

Search Method

Site ID and List ID

Fields

Select from the list

Select from drop-down menus.

Enter the item’s information into fields that are dynamically loaded, depending on the List ID you select.

Enter manually (dynamic)

Enter or use the ID Finder to search.

It is not possible to map Site ID and List ID values. If the Site ID or List ID values are mapped, item fields will not load dynamically and must be entered as key-value pairs.

Enter the item’s information into fields that are dynamically loaded, depending on the List ID you specify.

Enter manually (key/value pair)

Enter, map, or use the ID Finder to search.

Enter the item’s information as key-value pairs.

Update an Item

Updates an item’s fields.

Connection

Establish a connection to your Microsoft SharePoint Online.

Search Method

Select whether to specify the Site ID and the List ID from drop-down menus or manually, and item fields dynamically or in key-value pairs.

Search Method

Site ID and List ID

Fields

Select from the list

Select from drop-down menus.

Enter the item’s information into fields that are dynamically loaded, depending on the List ID you select.

Enter manually (dynamic)

Enter or use the ID Finder to search.

It is not possible to map Site ID and List ID values. If the Site ID or List ID values are mapped, item fields will not load dynamically and must be entered as key-value pairs.

Enter the item’s information into fields that are dynamically loaded, depending on the List ID you specify.

Enter manually (key/value pair)

Enter, map, or use the ID Finder to search.

Enter item’s information as key-value pairs.

Delete an Item

Deletes an existing item.

Connection	Establish a connection to your Microsoft SharePoint Online.
Delete an Item	Select whether you want to specify the Site ID, the List ID, and the Item ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site that contains the list you want to delete an item from.
List ID	Enter (map) or use the ID Finder to search for the list ID or select the list you want to delete an item from.
Item ID	Enter (map) or use the ID Finder to search for the item ID or select the item you want to delete.

List

Watch Lists

Retrieves list details when a list is created or updated.

Connection	Establish a connection to your Microsoft SharePoint Online.
Watch Lists	Select whether you want to watch the site for created or modified lists.
Site ID	Enter (map) or use the ID Finder to search for the site ID you want to watch for new lists.
Limit	Set the maximum number of lists Boost.space Integrator will return during one execution cycle.

List Lists

Retrieves all lists for the site.

Connection	Establish a connection to your Microsoft SharePoint Online.
List Lists	Select whether you want to specify the Site ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site you want to retrieve list details for.
Limit	Set the maximum number of lists Boost.space Integrator will return during one execution cycle.

Get a List

Returns list details.

Connection	Establish a connection to your Microsoft SharePoint Online.
Get a List	Select whether you want to specify the Site ID and the List ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site that contains the list you want to retrieve details for.
List ID	Enter (map) or use the ID Finder to search for the list ID or select the list you want to retrieve details for.

Create a List

Creates a new list on a specified site.

Connection	Establish a connection to your Microsoft SharePoint Online.
Enter a Site ID	Select whether you want to specify the Site ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site you want to create a list at.
Display Name	Enter the name of the new list.
Description	Enter the description of the new list.
Add Columns	Specify columns of the list.

Page (Beta)

	Note
	APIs under the `beta` version in Microsoft Graph are subject to change. The use of these APIs in production applications is not supported.

Watch Pages

Retrieves page details when a page is modified.

Connection	Establish a connection to your Microsoft SharePoint Online.
Site ID	Enter (map) or use the ID Finder to search for the site ID you want to watch for modified pages.
Limit	Set the maximum number of pages Boost.space Integrator will return during one execution cycle.

List Pages

Retrieves all pages for a specified site.

Connection	Establish a connection to your Microsoft SharePoint Online.
List Pages	Select whether you want to specify the Site ID manually or select from the drop-down menu.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site you want to retrieve pages for.
Limit	Set the maximum number of pages Boost.space Integrator will return during one execution cycle.

Get a Page

Retrieves page details.

Connection	Establish a connection to your Microsoft SharePoint Online.
Get a Page	Select whether you want to specify the Site ID and the Page ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site that contains the page you want to retrieve details about.
Page ID	Enter (map) or use the ID Finder to search for the page ID or select the page you want to retrieve details for.

Publish a Page

Publishes the latest version of a page.

Connection	Establish a connection to your Microsoft SharePoint Online.
Publish a Page	Select whether you want to specify the Site ID and the Page ID manually or select from drop-down menus.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site that contains the page you want to publish.
Page ID	Enter (map) or use the ID Finder to search for the page ID or select the page you want to publish.

Site

Search Sites

Searches for a site by specified criteria.

Connection	Establish a connection to your Microsoft SharePoint Online.
Keyword of Display Name	Enter the search term you want to search the sites for.
Limit	Set the maximum number of sites Boost.space Integrator will return during one execution cycle.

Get a Site

Retrieves site details.

Connection	Establish a connection to your Microsoft SharePoint Online.
Get a Site	Select whether you want to specify the Site ID manually or select from the drop-down menu.
Site ID	Enter (map) or use the ID Finder to search for the site ID or select the site you want to retrieve details about.

Files

Watch Files/Folders

TriggersEvery scenario has a trigger, an event that starts your scenario. A scenario must have a trigger. There can only be one trigger for each scenario. When you create a new scenario, the first module you choose is your trigger for that scenario. Create a trigger by clicking on the empty module of a newly created scenario or moving the... when a file or folder is created or updated in a specific site.

Connection	Establish a connection to your Microsoft SharePoint Online.
Watch Files/Folders	Select whether you want to watch for a created or updated items.
Site ID	Enter (map) or use the ID Finder to search for the site ID of the site that you want to watch for files/folders in.
Drive ID	Select the ID of the drive you want to watch for files/folders in.
Folder	Select the folder you want to watch for files/folders in.
Query Search	Enter a search query (optional).
Choose an Item Type	Select whether to watch for updates in files, folders, or both.
Limit	Set the maximum number of items Boost.space Integrator will return during one execution cycle.

Download a File

Downloads a file from a specified site.

Connection	Establish a connection to your Microsoft SharePoint Online.
Enter (File ID & File Path)	Select whether to enter a file ID or a file path.
Enter a File ID / Enter a File Path	Select whether to select the file id or file path from a list or to enter manually.
Site ID	Enter (map) or use the ID Finder to search for the site ID of the site that you want to download a file from.
Drive ID	Enter (map) or use the ID Finder to search for the drive ID of the drive that you want to download a file from.
File Path	Enter the file path of the file you want to download a file from.
File / File ID	Select or enter the File ID of the file you want to download.
Convert to PDF	Select whether you want to convert the downloaded file to PDF format.

Upload a File

Uploads a new file to a specified site.

Connection	Establish a connection to your Microsoft SharePoint Online.
Enter (Folder Location ID & Path)	Select whether to enter a folder ID or a folder path.
Enter a Folder Location ID / Enter a Folder Location Path	Select whether to select the folder location ID/folder location path from a list or to enter manually.
Site ID	Enter (map), select, or use the ID Finder to search for the site ID of the site that you want to upload a file to.
Drive ID	Enter (map), select, or use the ID Finder to search for the drive ID of the drive that you want to upload a file to.
Folder / Folder ID / Folder Path	Enter or select the folder ID or folder that you want to upload a file to.
File Name	Enter the name of the file that you want to upload.
If the File with the Same Name Exists	Select what to do if a file with the same name already exists.
Description	Enter a description of the file.

Folders

Create a Folder

Creates a folder in OneDrive.

Connection	Establish a connection to your Microsoft SharePoint Online.
Create a Folder	Select whether to create a folder by selecting from the list or entering manually.
Site ID	Enter (map), select, or use the ID Finder to search for the site ID of the site that you want to create a folder in.
Drive ID	Enter (map), select, or use the ID Finder to search for the drive ID of the drive that you want to create a folder in.
Folder / Folder ID	Enter or select the folder ID or folder that you want to create a folder in.
New Folder Name	Enter a name for the new folder.

Other

Make an API Call

Allows you to perform a custom API call.

Connection

Establish a connection to your Microsoft SharePoint Online.

URL

Enter a path relative to https://graph.microsoft.com.For example: /beta/sites.

	Note
	For the list of available endpoints, refer to the SharePoint API in Microsoft Graph Documentation.

Method

Select the HTTP method you want to use:

GET

to retrieve information for an entry.

POST

to create a new entry.

PUT

to update/replace an existing entry.

PATCH

to make a partial entry update.

DELETE

to delete an entry.

Headers

Enter the desired request headers. You don’t have to add authorization headers; we already did that for you.

Query String

Enter the request query string.

Body

Enter the body content for your API call.

Example of Use – List Lists (beta)

The following API call returns all the lists on a specified site using Microsoft SharePoint Online beta API:

URL:

/beta/sites/{site-ID}/lists/

Method:

GET

The result can be found in the module’s Output under BundleA bundle is a chunk of data and the basic unit for use with modules. A bundle consists of items, similar to how a bag may contain separate, individual items. More > Body > value.

In our example, 4 lists were returned:

Permission information for Microsoft SharePoint Online

Create a List – User.Read, Sites.Manage.All, offline_access
Create a Folder – User.Read, offline_access
Create an Item – User.Read, Sites.ReadWrite.All, offline_access
Delete an Item– User.Read, Sites.ReadWrite.All, offline_access
Download a File – User.Read, Files.Read.All, Sites.Read.All, offline_access
Get a List – User.Read, Sites.Read.All, offline_access
Get an Item – User.Read, Sites.Read.All, offline_access
Get a Page – User.Read, Sites.Read.All, offline_access
Get a Site – User.Read, Sites.Read.All, offline_access
List Items – User.Read, Sites.Read.All, offline_access
List Lists – User.Read, Sites.Read.All, offline_access
List Pages – User.Read, Sites.Read.All, offline_access
Make an API Call – User.Read, Sites.ReadWrite.All, Sites.Manage.All, Files.ReadWrite.All, offline_access
Publish a Page – User.Read, Sites.ReadWrite.All, offline_access
Search Sites – User.Read, Sites.Read.All, offline_access
Update an Item – User.Read, Sites.ReadWrite.All, offline_access
Upload a File – User.Read, Files.ReadWrite.All, Sites.ReadWrite.All, offline_access
Watch Files/Folders – User.Read, Files.Read.All, Sites.Read.All, offline_access
Watch Items – User.Read, Sites.Read.All, offline_access
Watch Lists – User.Read, Sites.Read.All, offline_access
Watch Pages – User.Read, Sites.Read.All, offline_access