Microsoft SharePoint Online Connector

Microsoft SharePoint Online Connector

Microsoft SharePoint Online Connector assets

Microsoft SharePoint Online Connector assets

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

0 COMMENTS

We’d like to hear from you!