SharePoint Online Connector
Documentation
Version: 20
Documentation
SharePoint Online Connector
Version: 20
Toggle navigation
SharePoint Online Connector
What's new
Authentication
User Credentials
Application Credentials
Application Credentials with Certificate (Sign JWT with Private Key)
SSIS
Getting started
Reading data
Writing data
SQL Server
Getting started
Reading data
SQL examples
ODBC
Getting started
Reading data
SQL examples
Tables
[Dynamic Table]
FileReaderWriterCsv
Drives
__DynamicRequest__
FileReaderWriterJson
ListItems
Lists
Sites
SystemLists
Endpoints
Copy item (File or Folder)
Create List Item
Create or Update CSV File (Generic)
Create or Update JSON File (Generic)
Delete Item (File or Folder)
Delete List Item
Download File
Get Item (File or Folder)
List Drives
List Excel Files
List Excel Worksheets of a File (i.e. List Tabs)
List Files
List Folders
List SharePoint Lists
List SharePoint System Lists
List Sites
Move or rename item (File or Folder)
Read CSV File (Generic)
Read Drive
Read Excel Worksheet (Auto Detect Range)
Read Excel Worksheet (From Exact Range)
Read File Data (As Byte Array)
Read JSON File (Generic)
Read List
Read List Fields
Read List Item (By ID)
Read List Items
Read List Items (Dynamic Columns)
Read Main Site
Update List Item
Upload File
Make Generic REST API Request
Make Generic REST API Request (Bulk Write)
Advanced topics
SQL functions
Placeholder functions
Stored procedures
Views
Metadata
SQL syntax
Integration
Applications & ETL tools
Programming languages
Connector file
Download
Source code
Custom connectors
Connector customization
Building your own connector
Discover
All connectors
Community
SharePoint Online Connector
What's new
Authentication
User Credentials
Application Credentials
Application Credentials with Certificate (Sign JWT with Private Key)
SSIS
Getting started
Reading data
Writing data
SQL Server
Getting started
Reading data
SQL examples
ODBC
Getting started
Reading data
SQL examples
Tables
[Dynamic Table]
FileReaderWriterCsv
Drives
__DynamicRequest__
FileReaderWriterJson
ListItems
Lists
Sites
SystemLists
Endpoints
Copy item (File or Folder)
Create List Item
Create or Update CSV File (Generic)
Create or Update JSON File (Generic)
Delete Item (File or Folder)
Delete List Item
Download File
Get Item (File or Folder)
List Drives
List Excel Files
List Excel Worksheets of a File (i.e. List Tabs)
List Files
List Folders
List SharePoint Lists
List SharePoint System Lists
List Sites
Move or rename item (File or Folder)
Read CSV File (Generic)
Read Drive
Read Excel Worksheet (Auto Detect Range)
Read Excel Worksheet (From Exact Range)
Read File Data (As Byte Array)
Read JSON File (Generic)
Read List
Read List Fields
Read List Item (By ID)
Read List Items
Read List Items (Dynamic Columns)
Read Main Site
Update List Item
Upload File
Make Generic REST API Request
Make Generic REST API Request (Bulk Write)
Advanced topics
SQL functions
Placeholder functions
Stored procedures
Views
Metadata
SQL syntax
Integration
Applications & ETL tools
Programming languages
Connector file
Download
Source code
Custom connectors
Connector customization
Building your own connector
Discover
All connectors
Community
Home
»
API Integration Hub
»
SharePoint Online Connector
»
Documentation
» ODBC »
SQL examples
» List sites
ODBC guide
List sites
Gets a list of all available SharePoint sites.
SELECT * FROM Sites