EndPoints for SharePoint Online Connector
On this page you will see possible API actions you can perform with SharePoint Online connector. We will refer this as API EndPoint or just EndPoint.
| Label | Name | Description |
|---|---|---|
| Read Main Site | get_main_site | |
| List Sites | list_sites | |
| List Drives | list_drives | |
| Read Drive | get_drive | |
| List Folders | list_folders | |
| List Files | list_files | [API reference] |
| List Excel Files | list_excel_files | |
| List SharePoint Lists | list_lists | |
| List SharePoint System Lists | list_system_lists | |
| Read List Fields | get_list_fields | |
| Read List | get_list | |
| Read List Items | get_list_items | |
| Read List Items (Dynamic Columns) | get_list_items_dynamic | 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) |
| Read List Item (By ID) | get_list_item | |
| Create List Item | create_list_item | |
| Update List Item | update_list_item | |
| Delete List Item | delete_list_item | |
| List Excel Worksheets (Tabs) | list_excel_worksheets | |
| Read Excel Worksheet (Auto Detect Range) | get_excel_worksheet_autodetect | 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. [API reference] |
| Read Excel Worksheet (Specific Range) | get_excel_worksheet | Use this endpoint to read data from excel worksheets with address range e.g. A1:D100. If you want dynamic range or unsure about end row then use the other endpoint with Auto Detect feature [API reference] |
| Download File as a column field | download_file | Dowloads a File as a column field |
| Download File to disk | download_file_to_disk | Dowloads a File to Local Disk |
| Delete File from Sharepoint Site | delete_file | Delete a File |
| Upload File | upload_file | Uploads a File [API reference] |
| Generic Request | 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. |
| Generic Request (Bulk Write) | generic_request_bulk_write | 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. |