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 | [API reference] |
| 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 of a File (i.e. List 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 (From Exact Range) | get_excel_worksheet | |
| Read CSV File (Generic) | get_csv_file | |
| Create / Update CSV File (Generic) | create_csv_file | |
| Read JSON File (Generic) | get_json_file | |
| Create / Update JSON File (Generic) | create_json_file | |
| Read File Data (As Byte Array) | download_file | Get file data as a column field (Binary data) |
| Download File | download_file_to_disk | |
| Upload File | upload_file | Upload a file to the specified path [API reference] |
| Get Item (File or Folder) | get_item | |
| Delete Item (File or Folder) | delete_item | |
| Move or rename item (File or Folder) | move_rename_item | Move or rename an item (File or Folder) to a different location in the same drive or another drive (e.g. different Document Library) |
| Copy item (File or Folder) | copy_item | Copy an item (File or Folder) to a different location in the same drive or another drive (e.g. different User's drive) |
| 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. |