The following table lists the Microsoft SharePoint Online objects and task operations that you can include in Data Integration tasks:
Objects
Read
Insert
Update
Upsert
Delete
Data Preview
Lookup
List
Yes
Yes
Yes
NA
Yes
Yes
NA
Document Library
Yes
Yes
NA
NA
Yes
Yes
NA
You can update the Title and custom fields in the list object. Based on the ID specified, you can update the Title and custom fields in the list object. You must specify the ID if you want to delete data from the list object and ServerRelativeUrl path if you want to delete data from the document library object.
If the list object is empty, the data preview tab does not display the metadata of the custom fields. To solve this issue, you must add a dummy row in the list object.
The custom fields of the list object supports the following data types:
•Single line of text. For example, File name.
• Multiple lines of text. For example,
File name 1 File name 2 File name 3
•Number. For example, 1001.
•Choice. For example, Choice 1.
•Currency. For example, 50001.23.
•Date and Time. For example, 2015-01-13T11:01:48, 2013-03-12T12:01:38Z, or 3/12/2013.
Note: Microsoft SharePoint Online Connector does not certify the update operation when the column is of Date and Time data type.
•Yes/No. For example, TRUE or FALSE.
•Person or Group. For example, 1.
You need to create custom objects using List or Document Libraries in Microsoft SharePoint Online application. You can use Microsoft SharePoint Online Connector to download attachments from the custom list and Document Library object in Microsoft SharePoint Online. The List object supports attachments up to 185 MB and Document Library object supports attachments up to 171 MB. The field length for an object must not exceed 255 characters.
When you download an attachment and if another file exists with the same name, the Secure Agent overwrites the existing file in the target folder. When you attach a file and if another file exists with the same name, an error occurs. You must provide different file name to attach a file in the Attachment_File_Path folder.
Rules and guidelines for Microsoft SharePoint Online objects and operations
You must follow certain rules and guidelines when you use specific Microsoft SharePoint Online objects and operations:
Server path for target operations
Use the following rules and guidelines when you specify a path for a target operation:
•To perform a delete operation, you must add / at the beginning of the server relative path.
For example, /new folder/new_folder2/sharepoint.txt
•To perform a delete or insert operation in the subsite Microsoft SharePoint Online account, you must provide the complete path of subsite URL.
For example, /sites/new folder/new_folder2/sharepoint.txt
•To perform an insert operation in the document library object, you must not add / at the beginning of the server relative path. For example, folder_1/new folder/new_folder2/sharepoint.txt
List object
Use the following rules and guidelines when you use the list object to perform an Insert operation:
Creating a list item
To create a list item, specify the Title and enter FALSE as the value of the Attachments field. The ServerRedirectedEmbedUrl and Id fields are not required.
For example, enter SharePointOnline as Title and Attachments as FALSE in the fields.
Creating a list item with an attachment
To create a list item and attach a file, specify the Title and enter TRUE as the value of the Attachments field. Enter the file name that you want to attach in the ServerRedirectedEmbedUrl field.
For example, enter SharePointOnline as Title, Attachments as TRUE, and filename.ext in the ServerRedirectedEmbedUrl fields.
Attaching a file to the existing list item
To attach a file to the existing list item, specify the Title and enter TRUE as the value of the Attachments field. Enter the file name that you want to attach in the ServerRedirectedEmbedUrl field and the list Id of the list item in the ID field.
For example, enter SharePointOnline as Title, Attachments as TRUE and filename.ext in the ServerRedirectedEmbedUrl fields. Enter <integer value> in the ID field.
Note: If you use an Expression transformation to set the value for the Attachments field to FALSE or TRUE, specify a String field type and pass the 'FALSE' or 'TRUE' values within single quotes.
Document library object
Use the following rules and guidelines when you use the document library object:
Note: A dummy file must be present in the document library object to perform the insert operation.
Creating a folder
To create a folder in the document library object, enter the folder path where you want to create the folder in the ServerRelativeUrl field and specify the folder name in the Title field. The Name field is not required.
For example, enter the folder path in /Folder/Folder1 format in the ServerRelativeUrl field and the folder name in the Title field.
Attaching file to the existing folder
To attach a file to the existing folder in the document library object, enter the file name in the Name field and the folder path where you want to attach the file in the ServerRelativeUrl field. The Title field is not required.
For example, enter the file name in the file.ext format in the Name field and the folder path in the /Folder/Folder1 format in the ServerRelativeUrl field.
Creating a folder with an attachment
To create a folder and attach a file in the document library object, enter the file name in the Name field and the folder path where you want to create the new folder and attach the file inside the new folder in the ServerRelativeUrl field. Enter the folder name in the Title field.
For example, enter the file name in the file.ext format in the Name field and the folder path in the /Folder/Folder1 format in the ServerRelativeUrl field. Enter the folder name in the Title field.
The new folders created are available under the folder path that you specify in the ServerRelativeUrl column and the attachments are available inside the new folder. You can only attach one file at a time to an existing folder.