SharePoint Online ConnectorsZappySys SharePoint Online Connector provide read / write capability inside your app (see list below), using these drag and drop , high performance connectors you can perform many SharePoint Online operations without any coding. You can use this connector to integrate SharePoint Online data inside apps like SSIS, SQL Server or popular ETL Platforms / BI Tools/ Reporting Apps / Programming languages (i.e. Informatica, Power BI, SSRS, Excel, C#, JAVA, Python) |
![]() |
Click on your App below to get started with SharePoint Online Integration
Choose your App / Scenario for which you like to integrate SharePoint Online
Actions supported by SharePoint Online Connector
SharePoint Online Connector support following actions for REST API integration. If some actions are not listed below then you can easily edit Connector file and enhance out of the box functionality.
Read Main Site
List Sites
List Drives
Parameter | Description |
---|---|
SiteId |
|
Read Drive
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
List Folders
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
List Files
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
List Excel Files
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
List SharePoint Lists
Parameter | Description |
---|---|
SiteId |
|
List SharePoint System Lists
Parameter | Description |
---|---|
SiteId |
|
Read List Fields
Parameter | Description |
---|---|
SiteId |
|
ListId |
|
Expand |
|
Read List
Parameter | Description |
---|---|
SiteId |
|
ListId |
|
Read List Items
Parameter | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
SiteId |
|
||||||||||
ListId |
|
||||||||||
Filter |
|
Read List Items (Dynamic Columns)
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)
Parameter | Description | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
SiteId |
|
||||||||||
ListId |
|
||||||||||
Filter |
|
Read List Item (By ID)
Parameter | Description |
---|---|
SiteId |
|
ListId |
|
ListItemId |
|
Create List Item
Parameter | Description |
---|---|
SiteId |
|
ListId |
|
Update List Item
Parameter | Description |
---|---|
SiteId |
|
ListId |
|
ListItemId |
|
Delete List Item
Parameter | Description |
---|---|
SiteId |
|
ListId |
|
ListItemId |
|
List Excel Worksheets
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
FileId |
|
Read Excel Worksheet
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
FileId |
|
SheetId |
|
Range |
|
Download File as a column field
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
FileId |
|
Download File to disk
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
FileId |
|
Delete File from Sharepoint Site
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
FileId |
|
Upload File
Parameter | Description |
---|---|
SiteId |
|
DriveId |
|
DiskFilePath |
|
SharePointFilePath |
|
Generic Request
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.
Parameter | Description |
---|---|
Url |
|
Body |
|
IsMultiPart |
|
Filter |
|
Headers |
|