Endpoints
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 |
|---|---|---|
| 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) |
| Create / Update CSV File (Generic) | create_csv_file | |
| Create / Update JSON File (Generic) | create_json_file | |
| Create List Item | create_list_item | |
| Delete Item (File or Folder) | delete_item | |
| Delete List Item | delete_list_item | |
| Download File | download_file_to_disk | |
| Get Item (File or Folder) | get_item | |
| List Drives | list_drives | |
| List Excel Files | list_excel_files | [API reference] |
| List Excel Worksheets of a File (i.e. List Tabs) | list_excel_worksheets | |
| List Files | list_files | [API reference] |
| List Folders | list_folders | |
| List SharePoint Lists | list_lists | |
| List SharePoint System Lists | list_system_lists | |
| List Sites | list_sites | |
| 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) |
| Read CSV File (Generic) | get_csv_file | |
| Read Drive | get_drive | |
| 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 File Data (As Byte Array) | download_file | Get file data as a column field (Binary data) |
| Read JSON File (Generic) | get_json_file | |
| Read List | get_list | |
| Read List Fields | get_list_fields | |
| Read List Item (By ID) | get_list_item | |
| 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 Main Site | get_main_site | |
| Update List Item | update_list_item | |
| Upload File | upload_file | Upload a file to the specified path [API reference] |
| Make Generic API 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. |
| Make Generic API 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. |