Sharepoint
ToolJet allows you to connect to Microsoft Sharepoint to perform various operations like managing sites, lists, and items using Microsoft Graph API.
Before following this guide, it is assumed that you have already completed the process of Using Marketplace plugins.
Connection
To connect to a Sharepoint data source in ToolJet, you can either click the + Add new data source button on the query panel or navigate to the Data Sources page in the ToolJet dashboard.
You'll need to register your application in Azure Active Directory to get the required credentials. The application needs appropriate Microsoft Graph API permissions.
To connect to Sharepoint, you need the following credentials:
- Client ID
- Client Secret
- Tenant ID
Querying Sharepoint
- Click the + Add button in the query manager at the bottom of the editor and select the Sharepoint data source added earlier.
- Choose the operation you want to perform on your Sharepoint instance.
Query results can be transformed using transformations. Refer to our transformations documentation for more details: link
Supported Operations
ToolJet supports the following Sharepoint operations:
- Get All Sites
- Get Site
- Get Analytics
- Get Pages Of a Site
- Get All Lists
- Get Metadata Of a List
- Create a List
- Get Items Of a List
- Update Item Of a List
- Delete Item Of a List
- Add Item To a List
Get All Sites
This operation retrieves all available Sharepoint sites. For more details, see the Microsoft Graph API documentation here.
Optional Parameters
- Top: The number of sites to retrieve.
- Page: The page number to retrieve.
Response Example
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites",
"value": [
{
"createdDateTime": "2026-03-02T10:45:02Z",
"id": "tooljetxxxx.sharepoint.com,bcxxxx-4b3a-xxxxxx-dfe229c34311,2a4ac5da-xxx-xxxx-b047-18dece61fb95",
"lastModifiedDateTime": "2026-03-02T10:46:15Z",
"name": "appcatalog",
"webUrl": "https://tooljetxxxx.sharepoint.com/sites/appcatalog",
"displayName": "Apps",
"root": {},
"siteCollection": {
"hostname": "tooljetxxxx.sharepoint.com"
}
}
]
}
Get Site
This operation retrieves information about a specific site.
Required Parameter
- Site ID: The ID of the site to retrieve.
Example:
Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
Response Example
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites/$entity",
"createdDateTime": "2026-03-02T10:50:09Z",
"description": "Internal DIA Guidelines",
"id": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb",
"lastModifiedDateTime": "2026-03-02T10:52:23Z",
"name": "NewStyle",
"webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle",
"displayName": "NewStyle",
"root": {},
"siteCollection": {
"hostname": "tooljetxxxx.sharepoint.com"
}
}
Get Analytics
This operation retrieves analytics for a specific site.
Required Parameters
- Site ID: The ID of the site.
- Time Interval: The duration between each automatic synchronization or polling request.
- Last 7 Days
- All Time
Example:
Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
Time Interval: Last 7 Days
Response Example
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#microsoft.graph.itemActivityStat",
"aggregationInterval": "None",
"startDateTime": "2026-03-02T10:55:30Z",
"endDateTime": "2026-03-02T10:55:40Z",
"isTrending": false,
"access": {
"actionCount": 0,
"actorCount": 0,
"timeSpentInSeconds": 0
},
"incompleteData": {
"wasThrottled": false,
"resultsPending": false,
"notSupported": false
}
}
Get Pages Of a Site
This operation retrieves all pages from a specific site.
Required Parameter
- Site ID: The ID of the site.
Optional Parameters
- Top: The number of sites to retrieve.
- Page: The page number to retrieve.
Example:
Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
Response Example
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/pages",
"@odata.nextLink": "https://graph.microsoft.com/v1.0/sites/tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb/pages?$top=1&$skiptoken=UGFnZWQ9VFJVRSZwX0ZpbGVMZWFmUmVmPUV2ZW50UGxhbkhvbWUuYXNweCZwX0lEPTc",
"value": [
{
"@odata.type": "#microsoft.graph.sitePage",
"@odata.etag": ""{2095ED1D-AC76-4480-BBDC-8D63EBAAE2AF},6"",
"createdDateTime": "2026-03-02T11:04:33Z",
"eTag": ""{2095ED1D-AC76-4480-BBDC-8D63EBAAE2AF},6"",
"id": "2095ed1d-ac76-4480-bbdc-8d63ebaae2af",
"lastModifiedDateTime": "2026-03-02T11:04:36Z",
"name": "EventPlanHome.aspx",
"webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle/SitePages/EventPlanHome.aspx",
"title": "Home",
"pageLayout": "home",
"thumbnailWebUrl": "https://tooljetxxxx.sharepoint.com/_layouts/15/getpreview.ashx?guidSite=887cb371-e930-4e5b-a726-8d5769e6b946&guidWeb=6d653d09-1613-4663-99ab-1bb72ff6ceeb&guidFile=bb423735-7402-47df-ab2e-729bddfe6f23",
"promotionKind": "page",
"showComments": false,
"showRecommendedPages": false,
"contentType": {
"id": "0x0101009D1CB255DA76424F860D91F20E6C4118004CC245E37669F3438CDDEB01FCEAE890",
"name": "Site Page"
},
"createdBy": {
"user": {
"displayName": "Oliver Smith",
"email": "[email protected]"
}
},
"lastModifiedBy": {
"user": {
"displayName": "Oliver Smith",
"email": "[email protected]"
}
},
"parentReference": {
"siteId": "887cb371-e930-4e5b-a726-8d5769e6b946"
},
"publishingState": {
"level": "published",
"versionId": "1.0"
},
"reactions": {}
}
]
}
Get All Lists
This operation retrieves all lists from a specific site.
Required Parameter
- Site ID: The ID of the site.
Optional Parameter
- Page: The page number to retrieve.
Example:
Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
Page: 1
Response Example
{
"@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/lists",
"value": [
{
"@odata.etag": ""1a64ae23-9cb6-4521-b489-61d558dde9f7,11"",
"createdDateTime": "2026-03-02T11:08:27Z",
"description": "",
"eTag": ""1a64ae23-9cb6-4521-b489-61d558dde9f7,11"",
"id": "1a64ae23-9cb6-4521-b489-61d558dde9f7",
"lastModifiedDateTime": "2026-03-02T11:08:29Z",
"name": "Test_table_query",
"webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle/Lists/Test_table_query",
"displayName": "test_table_query",
"createdBy": {
"user": {
"email": "[email protected]",
"id": "90ccfd6b-17ea-402b-aa21-1a1799a547d6",
"displayName": "Oliver Smith"
}
},
"lastModifiedBy": {
"user": {
"email": "[email protected]",
"id": "90ccfd6b-17ea-402b-aa21-1a1799a547d6",
"displayName": "Oliver Smith"
}
},
"parentReference": {
"siteId": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb"
},
"list": {
"contentTypesEnabled": false,
"hidden": false,
"template": "genericList"
}
}
]
}
Get Metadata Of a List
This operation retrieves metadata for a specific list.