Microsoft SharePoint Supported Objects and Task Operations
The following table lists the Microsoft SharePoint objects and task operations that you can include in Data Integration tasks:
Objects
Read
Write
Query
Insert
Update
Upsert
Delete
Data Preview
Lookup
List
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Document Library
Yes
Yes
Yes
Yes
NA
NA
Yes
Yes
Yes
To upsert data using a secondary key, you must map the source key field to the target secondary key field that you intend to use. If you specify the Secondary Key for Upsert field in the advanced target property, you must not map the target ID field in the Field Mapping.
To insert data using a secondary key, you must ensure that the secondary key field does not contain null values.
You must specify the ID to delete data from the list object. You must specify the ID, name, and the path to delete data from the document library object.
Note: You need to create custom objects using list or document libraries in Microsoft SharePoint application. Use Microsoft SharePoint Connector to download attachments from the custom list object in Microsoft SharePoint. The document library object supports attachments up to 10 MB.
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. Field Length for any object should not exceed 65 characters.