SharePoint Online Connector

SharePoint Online Connector

The high-performance SharePoint Online Connector provides read/write capabilities within your application, allowing you to perform numerous SharePoint Online operations with minimal coding or even no-coding at all. Integrate SharePoint Online data into applications such as SSIS, SQL Server, any ODBC-compatible application, or even directly within a programming language using this connector.

Download for SSIS Download for SQL Server and ODBC Documentation

Integrate SharePoint Online with these applications

All
Data Integration
Database
BI & Reporting
Productivity
Programming Languages
Automation & Scripting
ODBC applications

Actions supported by SharePoint Online Connector

SharePoint Online Connector supports following actions for REST API integration:

Copy item (File or Folder)

Description

Copy an item (File or Folder) to a different location in the same drive or another drive (e.g. different User's drive).

Parameters

You can provide the following parameters to this action:

  • Source Drive Id
  • Source File or Folder Id you like to copy
  • Target Folder Id (e.g. 01R65QTTRxxxxx -OR- root)
  • Source Site Id (Optional - Select if different than default site)
  • Target Site Id (Optional - Select if different than source SiteId)
  • Target DriveId (Optional - Select if different than source DriveId)
  • Target Item Name (Optional)
  • Source Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Source Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed
  • Target Search Type (For UI Only - Default=Recursive - i.e. Blank)
  • Target Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed
  • Prefer Async Operation (Enable if you get error)
  • Conflict Behavior (What to do if file exists at target location)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Create / Update CSV File (Generic)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File Id or Path (e.g. root:/somefolder/myfile.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

Create / Update JSON File (Generic)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File Id or Path (e.g. root:/somefolder/myfile.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

Create List Item

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId
  • SiteId (Re-Select ListId after you change this)

Input Fields

You can provide the following fields to this action:

  • [Dynamic Column]
  • [Dynamic Column]OdataType
  • [Dynamic Column]LookupId
  • [Dynamic Column]LookupIdOdataType

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedOn
  • CreatedById
  • CreatedByDisplayName
  • ModifiedOn
  • LastModifiedId
  • LastModifiedDisplayName
  • [Dynamic Column]

Visit documentation for more information.

Delete Item (File or Folder)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File/Folder Id or Path (e.g. root:/myfolder: -OR- root:/myfolder/file.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Delete List Item

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId (Re-Enter ListItemId after you change this)
  • ListItemId
  • SiteId (Re-Select ListId after you change this)

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • Output

Visit documentation for more information.

Download File

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File Id or Path (e.g. root:/somefolder/myfile.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Status

Visit documentation for more information.

Get Item (File or Folder)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File/Folder Id or Path (e.g. root:/myfolder: -OR- root:/myfolder/file.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • Id

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

List Drives

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Site Id

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • Description
  • DriveType
  • CreatedAt
  • CreatedByUser
  • LastModifiedAt
  • LastModifiedByUser
  • LastModifiedByUserEmail
  • LastModifiedByUserId
  • QuotaDeleted
  • QuotaRemaining
  • QuotaTotal
  • QuotaUsed
  • WebUrl
  • OwnerDisplayName
  • OwnerEmail
  • OwnerId
  • OdataContext

Visit documentation for more information.

List Excel Files

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type (Default=Recursive)
  • Search Path (Default=Root Folder)
  • Order By Field(s) - Only for Recursive SearchType

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

List Excel Worksheets of a File (i.e. List Tabs)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • FileId -OR- Path
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • Position
  • visibility
  • OdataId

Visit documentation for more information.

List Files

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Path (Default=Root Folder) - Max 200 items listed
  • Order By Field(s) - Only for Recursive SearchType

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

List Folders

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Record Filter (Client Side)
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Path (Default=Root Folder) - Max 200 items listed
  • Order By Field(s) - Only for Recursive SearchType

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

List SharePoint Lists

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Site Id (Re-Select Drive Id after you change this)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • DisplayName
  • ParentReferenceSiteId
  • ListContentTypesEnabled
  • IsListHidden
  • ListTemplate
  • Description
  • CreatedAt
  • CreatedByUserId
  • CreatedByUserEmail
  • CreatedByUser
  • LastModifiedAt
  • LastModifiedByUser
  • LastModifiedByUserEmail
  • LastModifiedByUserId
  • WebUrl

Visit documentation for more information.

List SharePoint System Lists

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Site Id (Re-Select Drive Id after you change this)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • DisplayName
  • ParentReferenceSiteId
  • ListContentTypesEnabled
  • IsListHidden
  • ListTemplate
  • Description
  • CreatedAt
  • CreatedByUserId
  • CreatedByUserEmail
  • CreatedByUser
  • LastModifiedAt
  • LastModifiedByUser
  • LastModifiedByUserEmail
  • LastModifiedByUserId
  • WebUrl

Visit documentation for more information.

List Sites

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • DisplayName
  • Description
  • SiteCollectionHostname
  • CreatedAt
  • LastModifiedAt
  • WebUrl

Visit documentation for more information.

Move or rename item (File or Folder)

Description

Move or rename an item (File or Folder) to a different location in the same drive or another drive (e.g. different Document Library).

Parameters

You can provide the following parameters to this action:

  • Operation
  • Source Drive Id
  • Source File or Folder Id you like to move or rename
  • Source Site Id (Optional - Select if different than default site)
  • Target Site Id (Optional - Select if different than source SiteId)
  • Target DriveId (Optional - Select if different than source DriveId)
  • Target Folder Id (e.g. 01R65Qxxxxxxx123 -OR- root) - Max 200 items listed
  • Target Item Name (Optional for Move - e.g. Myfile.pdf or MyFolder)
  • Source Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Source Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed
  • Target Search Type (For UI Only - Default=Recursive - i.e. Blank)
  • Target Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed
  • Prefer Async Operation (Enable if you get error)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

Read CSV File (Generic)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File Id or Path (e.g. root:/somefolder/myfile.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read Drive

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Site Id (Re-Select Drive Id after you change this)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • Description
  • DriveType
  • CreatedAt
  • CreatedByUser
  • LastModifiedAt
  • LastModifiedByUser
  • LastModifiedByUserEmail
  • LastModifiedByUserId
  • QuotaDeleted
  • QuotaRemaining
  • QuotaTotal
  • QuotaUsed
  • WebUrl
  • OwnerDisplayName
  • OwnerEmail
  • OwnerId
  • OdataContext

Visit documentation for more information.

Read Excel Worksheet (Auto Detect Range)

Description

Use this endpoint to read data from a Sheet without supplying address range (e.g. A1:D100). This endpoint auto detects address range based on used cells in a sheet.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Excel File Id or Path (e.g. root:/somefolder/myfile.xlsx: ) - Max 200 Listed
  • Sheet Id or Name (e.g. {00xx-xxx-xx123} -OR- Sheet1 )
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed
  • AutoDetectByValue

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read Excel Worksheet (From Exact Range)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Excel File Id or Path (e.g. root:/somefolder/myfile.xlsx: ) - Max 200 Listed
  • Sheet Id or Name (e.g. {00xx-xxx-xx123} -OR- Sheet1 )
  • Range
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read File Data (As Byte Array)

Description

Get file data as a column field (Binary data).

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File Id or Path (e.g. root:/somefolder/myfile.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Data

Visit documentation for more information.

Read JSON File (Generic)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • File Id or Path (e.g. root:/somefolder/myfile.xyz: ) - Max 1000 Listed
  • Site Id (Re-Select Drive Id after you change this)
  • Search Type - For UI Only (i.e. Recursive -OR- Non-Recursive) - Default=Recursive)
  • Search Folder (For UI Only - Helps to narrow down File Selection DropDown) - Max 200 Listed

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read List

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId
  • SiteId (Re-Select ListId after you change this)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • displayName
  • ParentReferenceSiteId
  • ListContentTypesEnabled
  • IsListHidden
  • ListTemplate
  • Description
  • CreatedAt
  • CreatedByUserId
  • CreatedByUserEmail
  • CreatedByUser
  • LastModifiedAt
  • LastModifiedByUser
  • LastModifiedByUserEmail
  • LastModifiedByUserId
  • WebUrl

Visit documentation for more information.

Read List Fields

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId
  • SiteId (Re-Select ListId after you change this)
  • Expand

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read List Item (By ID)

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId (Re-Enter ListItemId after you change this)
  • ListItemId
  • SiteId (Re-Select ListId after you change this)
  • Expand (Output Fields)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedOn
  • CreatedById
  • CreatedByDisplayName
  • ModifiedOn
  • LastModifiedId
  • LastModifiedDisplayName
  • [Dynamic Column]
  • [Dynamic Column]LookupId
  • [Dynamic Column]Label
  • [Dynamic Column]TermGuid
  • [Dynamic Column]WssId

Visit documentation for more information.

Read List Items

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId
  • SiteId (Re-Select ListId after you change this)
  • Filter
  • Expand (Output Fields)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedOn
  • CreatedById
  • CreatedByDisplayName
  • ModifiedOn
  • LastModifiedId
  • LastModifiedDisplayName
  • [Dynamic Column]
  • [Dynamic Column]LookupId
  • [Dynamic Column]Label
  • [Dynamic Column]TermGuid
  • [Dynamic Column]WssId

Visit documentation for more information.

Read List Items (Dynamic Columns)

Description

Use this endpoint if you face issue with NULl values in some columns. This endpoint scans metadata from few sample rows and decides datatypes. Use this if other endpoing showing null values for Complex datatypes (e.g. Lookup, Location, Person).

Parameters

You can provide the following parameters to this action:

  • ListId
  • SiteId (Re-Select ListId after you change this)
  • Filter
  • Expand (Output Fields)

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Read Main Site

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • N/A

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • Id
  • Name
  • DisplayName
  • Description
  • SiteCollectionHostname
  • CreatedAt
  • LastModifiedAt
  • WebUrl
  • OdataContext

Visit documentation for more information.

Update List Item

Description

Not available.

Parameters

You can provide the following parameters to this action:

  • ListId (Re-Enter ListItemId after you change this)
  • ListItemId
  • SiteId (Re-Select ListId after you change this)

Input Fields

You can provide the following fields to this action:

  • Id
  • [Dynamic Column]
  • [Dynamic Column]OdataType
  • [Dynamic Column]LookupId
  • [Dynamic Column]LookupIdOdataType

Output Fields

The following fields are returned after calling this action:

  • Id
  • CreatedOn
  • CreatedById
  • CreatedByDisplayName
  • ModifiedOn
  • LastModifiedId
  • LastModifiedDisplayName
  • [Dynamic Column]

Visit documentation for more information.

Upload File

Description

Upload a file to the specified path.

Parameters

You can provide the following parameters to this action:

  • Drive Id
  • Disk File Path (e.g. c:\somefolder\file.xlsx)
  • Target File Path OR Id (e.g. file.xlsx -OR- myfolder/file.xlsx -OR- 0Zxxxx1234)
  • Conflict Behavior (What to do if file exists)
  • Site Id (Re-Select Drive Id after you change this)
  • Use Source File Created/Modified DateTime rather than Uploaded Time

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • id
  • name
  • size
  • createdDateTime
  • lastModifiedDateTime
  • webUrl
  • webUrlPath
  • createdBy_user_id
  • createdBy_user_email
  • createdBy_user_displayName
  • createdBy_application_id
  • createdBy_application_displayName
  • lastModifiedBy_user_id
  • lastModifiedBy_user_email
  • lastModifiedBy_user_displayName
  • lastModifiedBy_application_id
  • lastModifiedBy_application_displayName
  • parentReference_id
  • parentReference_driveId
  • parentReference_driveType
  • parentReference_name
  • parentReference_siteId
  • parentReference_path
  • fileSystemInfo_createdDateTime
  • fileSystemInfo_lastModifiedDateTime
  • folder_childCount
  • file_mimeType
  • file_quickXorHash
  • file_sha1Hash
  • file_sha256Hash
  • shared_scope
  • remoteItem_parentReference_id
  • remoteItem_parentReference_driveId
  • remoteItem_parentReference_driveType
  • remoteItem_parentReference_name
  • remoteItem_parentReference_siteId
  • remoteItem_parentReference_path
  • remoteItem_shared_scope
  • remoteItem_shared_sharedDateTime
  • remoteItem_sharedBy_user_id
  • remoteItem_sharedBy_user_email
  • remoteItem_sharedBy_user_displayName
  • remoteItem_sharepointIds_listId
  • remoteItem_sharepointIds_listItemId
  • remoteItem_sharepointIds_listItemUniqueId
  • remoteItem_sharepointIds_siteId
  • remoteItem_sharepointIds_siteUrl
  • remoteItem_sharepointIds_tenantId
  • remoteItem_sharepointIds_webId
  • id_path

Visit documentation for more information.

Make Generic API Request

Description

This is generic endpoint. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • Body
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Make Generic API Request (Bulk Write)

Description

This is a generic endpoint for bulk write purpose. Use this endpoint when some actions are not implemented by connector. Just enter partial URL (Required), Body, Method, Header etc. Most parameters are optional except URL.

Parameters

You can provide the following parameters to this action:

  • Url
  • IsMultiPart
  • Filter
  • Headers

Input Fields

You can provide the following fields to this action:

  • N/A

Output Fields

The following fields are returned after calling this action:

  • N/A

Visit documentation for more information.

Download for SSIS Download for SQL Server and ODBC