SPO API

The SPO API component allows you to interact with the SharePoint REST API.

Creating document sets

A Document Set is a group of related documents that you can manage as a single entity. You can create a Document Set in a single step, and then define its characteristics and metadata.

If the Document Sets feature has not been activated for your site collection, you will need to activate it before you can create or configure new Document Set content types. You must be a Site Collection Administrator to activate the Document Sets feature.

Go to the top-level site in the site collection for which you want to enable Document Sets.

On the Site Actions menu, click Site Settings.

Under Site Collection Administration, click Site collection features.

Find Document Sets in the list, and then click Activate.

For creating and deleting lists or list items, Full Control permission level is required.

Configuration

General

Mode

Options for usage of component.

note

This mode can be overridden by using field mode in the incoming object. Possible values: delete, createFolder, createDocumentSet.

SharePoint

Enable modern authentication (using client certificate)

Enables authentication using a client certificate uploaded to Azure Portal instead of client credentials.

SharePoint username

SharePoint username to use for authentication.

SharePoint password

SharePoint password to use for authentication. Do not use the password of the user if MFA is enabled, but use an app password instead.

note

The SharePoint username and password are required when using client credentials for authentication

Client ID

The unique identifier for the client application registered in Azure Active Directory.

Tenant ID

The unique identifier of the Azure Active Directory tenant where the application is registered.

Certificate thumbprint

A thumbprint is a unique identifier for the certificate uploaded to Azure Portal. It ensures the application is using the correct certificate.

Certificate private key file path

The file path to the private key associated with the certificate.

note

**Client ID**, **Tenant ID**, **Thumbprint certificate** and **Certificate private key file path** are required when using a client certificate for authentication.

Rate limit

Request limit

The max amount of requests during the interval.

Interval

The interval in milliseconds in which the requests happen. Should be a multiple of 250.

Max concurrent

The maximum concurrent executions per message. API components that process an incoming message may need multiple requests towards an external API that maintains a request limit. To be able to keep the rate limiter aligned with this request limit and configurable per request, the message that is being processed in the component will be divided into multiple scheduled tasks that will be executed in order. This setting executes a batch of these scheduled tasks within the maximum request limit/interval.

Inputs | Outputs

SPO-API

Input

Output

Error

00 0 (ilynbrw2)

For using mode: Create document set & Create folder the component expects an incoming object containing the following required fields:

metadata: Object, key/value pairs to be set as metadata. Make sure they exist on the contentType that is being used.
siteUrl: String, site url (excluding documentLibrary/folders)
webUrl: String, site url (including documentLibrary/folders) listId: String, target Library GUID to create documentSets or folders in. contentType: String, contentTypeId for folder or documentSet.
listId: String, target Library GUID to create documentSets or folders in.
contentType: String, contentTypeId for folder or documentSet.


Creating list items such as document sets or folders can have different custom fields depending on the columns added for the contentTypeId.

Example: An example of different sorts of input:

{
 "metadata" : {
  "FileLeafRef": "name",
  "Title": "title",
  "Source" : "SharePoint",
  "Price" : "1234",
  "Partial_x0020_Source_x0020_Path" : "line 1 line 2 line 3",
  "Source_x0020_Migration_x0020_Date" : "2023-05-21T07:47:00.000Z",
  "IsFCDone" : "Yes;#No",
  "Document_x0020_Purpose" : ";#/Test/Testfolder|7bc62056-fe8c-4fab-a140-125c6a4368a0;
  #/Test/Document Purpose|520e01b5-0240-4f98-a1ed-72bfcb56a0b3",
  "Business_x0020_Units": "3;#TEST;#1;#TEST2;#",
  "Reviewed" : "1",
  "Approver" : "[{'Key':'Xillio test'}, {'Key':'test@xillio.com'}]",
  "ApproverSingle" : "[{'Key':'test@xillio.com'}]"
  },
  "siteUrl":"https://tenantName.sharepoint.com/sites/testSite",
  "webUrl":"https://tenantName.sharepoint.com/sites/
  testSite/testDocLib/testSubFolder",
  "listId": "9e30f72e-06bd-43bf-a49e-1ec73b83a983",
  "contentTypeId":"0x012000A819CE8B4B46CD4FB219D6AAABCDBE05"
}

For using mode: Delete list item the component expects an incoming object containing the following required fields:
siteUrl: String, site url (excluding documentLibrary/folders) listId: String, target Library GUID to create documentSets or folders in. listItemId: String, listItemId of target object to delete

{
  "siteUrl":"https://tenantName.sharepoint.com/sites/testSite",
  "listId": "9e30f72e-06bd-43bf-a49e-1ec73b83a983",
  "listItemId":"16"
}