Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Microsoft SharePoint Connector

Microsoft SharePoint Connector

Microsoft SharePoint Supported Objects and Task Operations

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.
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.

0 COMMENTS

We’d like to hear from you!