SQL examples for SQL Server
The following SQL examples demonstrate common use cases for this connector. Select a scenario below to view the query syntax and parameters required to interact with SharePoint Online.
- Copy a file or folder
- Create a document library item
- Create a list item
- Create a list item with multi-select choice fields
- Create a list item with multi-select lookup or person fields
- Create or update a CSV file
- Create or update a JSON file
- Delete a document library item
- Delete item from a named list
- Download a file
- Get list fields
- Get list items
- Get list items (dynamic metadata)
- Get list items with filter
- Get lists
- List document library items
- List drives (document libraries)
- List Excel files
- List Excel worksheets
- List files
- List files in a folder ID (non-recursive)
- List files in a folder path (recursive)
- List folders
- List folders in a parent folder
- List sites
- Move or rename a file or folder
- Read a drive
- Read compressed CSV file
- Read compressed JSON file
- Read CSV file
- Read Excel data as formatted text
- Read Excel worksheet (auto-detect range)
- Read Excel worksheet (specified range)
- Read file content as Base64
- Read full image path
- Read JSON file
- Read main site details
- Rename a file or folder
- Update / Insert Sharepoint List Data (Mixed Data Types - e.g. Multi Choice, Lookup, Person, DateTime, Number)
- Update a document library item
- Update a list item
- Update a list item with multi-select fields
- Update multi-choice fields (generic API call)
- Upload a file
- Upload a file (overwrite if exists)