Skip to main content

Sharepoint

ToolJet allows you to connect to Microsoft Sharepoint to perform various operations like managing sites, lists, and items using Microsoft Graph API.

info

NOTE: 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.

info

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 details:

  • Client ID
  • Client Secret
  • Tenant ID
Sharepoint Connect

Querying Sharepoint​

  1. Click the + Add button in the query manager at the bottom of the editor and select the Sharepoint data source added earlier.
  2. Choose the operation you want to perform on your Sharepoint instance.
tip

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​

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
Get All Sites
Response Example
{
  "@odata.context": "https://graph.microsoft.com/v1.0/$metadata#sites",
  "value": [
    {
      "createdDateTime": "2024-09-08T15:54:30Z",
      "id": "tooljetxxxx.sharepoint.com,bcxxxx-4b3a-xxxxxx-dfe229c34311,2a4ac5da-xxx-xxxx-b047-18dece61fb95",
      "lastModifiedDateTime": "2024-08-17T18:50:05Z",
      "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 Parameters​

  • Site ID: The ID of the site to retrieve
Get Site

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": "2024-10-22T13:21:10.623Z",
  "description": "Internal DIA Guidelines",
  "id": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb",
  "lastModifiedDateTime": "2024-10-24T13:35:39Z",
  "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:
    • Last 7 Days
    • All Time
Get Analytics

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": "2024-10-30T00:00:00Z",
  "endDateTime": "2024-11-05T00:00:00Z",
  "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 Parameters​

  • Site ID: The ID of the site

Optional Parameters​

  • Top: The number of sites to retrieve
  • Page: The page number to retrieve
Get Pages

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": "2024-10-22T13:21:33Z",
      "eTag": ""{2095ED1D-AC76-4480-BBDC-8D63EBAAE2AF},6"",
      "id": "2095ed1d-ac76-4480-bbdc-8d63ebaae2af",
      "lastModifiedDateTime": "2024-10-22T13:21:35Z",
      "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 Parameters​

  • Site ID: The ID of the site

Optional Parameters​

  • Page: The page number to retrieve
Get All Lists

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": "2024-10-24T11:11:10Z",
      "description": "",
      "eTag": ""1a64ae23-9cb6-4521-b489-61d558dde9f7,11"",
      "id": "1a64ae23-9cb6-4521-b489-61d558dde9f7",
      "lastModifiedDateTime": "2024-10-24T11:11:17Z",
      "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.

Required Parameters​

  • Site ID: The ID of the site
  • List Name: The name of the list, only used if List ID is not provided
  • List ID: The ID of the list, required if List Name is not provided
Get List Metadata

Example:​

Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
List ID: 22f69173-0c1d-4c76-a721-5a31f0bd5af3
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/$entity",
  "@odata.etag": ""1a64ae23-9cb6-4521-b489-61d558dde9f7,11"",
  "createdDateTime": "2024-10-24T11:11:10Z",
  "description": "",
  "eTag": ""1a64ae23-9cb6-4521-b489-61d558dde9f7,11"",
  "id": "1a64ae23-9cb6-4521-b489-61d558dde9f7",
  "lastModifiedDateTime": "2024-11-05T10:27:04Z",
  "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"
  },
  "[email protected]": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/lists('1a64ae23-9cb6-4521-b489-61d558dde9f7')/columns",
  "columns": [
    {
      "columnGroup": "Custom Columns",
      "description": "",
      "displayName": "USER_NAME",
      "enforceUniqueValues": false,
      "hidden": false,
      "id": "fa564e0f-0c70-4ab9-b863-0177e6ddd247",
      "indexed": false,
      "name": "Title",
      "readOnly": false,
      "required": false,
      "text": {
        "allowMultipleLines": false,
        "appendChangesToExistingText": false,
        "linesForEditing": 0,
        "maxLength": 255
      }
    }
  ],
  "[email protected]": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/lists('1a64ae23-9cb6-4521-b489-61d558dde9f7')/items",
  "items": [
    {
      "@odata.etag": ""12b493eb-2452-451b-84e5-ecba8ec898c8,1"",
      "createdDateTime": "2024-10-24T11:11:11Z",
      "eTag": ""12b493eb-2452-451b-84e5-ecba8ec898c8,1"",
      "id": "1",
      "lastModifiedDateTime": "2024-10-24T11:11:11Z",
      "webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle/Lists/Test_table_query/1_.000",
      "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": {
        "id": "036d657d-ed69-4dcc-a669-483ce9788655",
        "siteId": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb"
      },
      "contentType": {
        "id": "0x0100A3D887BE30452F4A9CBA7E684C523E2100098058C6B440D14786561D28914A3EDB",
        "name": "Item"
      },
      "[email protected]": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/lists('1a64ae23-9cb6-4521-b489-61d558dde9f7')/items('1')/fields/$entity",
      "fields": {
        "@odata.etag": ""12b493eb-2452-451b-84e5-ecba8ec898c8,1"",
        "Title": "Null_test",
        "id": "1",
        "AuthorLookupId": "7",
        "EditorLookupId": "7",
        "_UIVersionString": "1.0",
        "Attachments": false,
        "Edit": "",
        "LinkTitleNoMenu": "Null_test",
        "LinkTitle": "Null_test",
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "_ComplianceFlags": "",
        "_ComplianceTag": "",
        "_ComplianceTagWrittenTime": "",
        "_ComplianceTagUserId": ""
      }
    }
  ]
}

Create a List​

This operation creates a new list in a Sharepoint site.

Required Parameters​

  • Site ID: The ID of the site
  • Body: The list configuration in JSON format
Create List

Example:​

Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
Body:
{
  "displayName": "Project Tasks",
  "columns": [
    {
      "name": "TaskName",
      "text": { }
    },
    {
      "name": "DueDate",
      "dateTime": { }
    },
    {
      "name": "Priority",
      "choice": {
        "choices": ["High", "Medium", "Low"]
      }
    }
  ],
  "list": {
    "template": "genericList"
  }
}
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/$entity",
  "@odata.etag": "f7497bc1-a8e6-49d0-a11c-05b3df1d8d2b,10",
  "createdDateTime": "2024-11-05T10:48:51Z",
  "description": "",
  "eTag": "f7497bc1-a8e6-49d0-a11c-05b3df1d8d2b,10",
  "id": "f7497bc1-a8e6-49d0-a11c-05b3df1d8d2b",
  "lastModifiedDateTime": "2024-11-05T10:48:52Z",
  "name": "Project Tasks",
  "webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle/Lists/Project%20Tasks",
  "displayName": "Project Tasks",
  "createdBy": {
    "user": {
      "displayName": "Oliver Smith",
      "email": "[email protected]"
    }
  },
  "parentReference": {
    "siteId": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb"
  },
  "list": {
    "contentTypesEnabled": false,
    "hidden": false,
    "template": "genericList"
  }
}

Get Items Of a List​

This operation retrieves items from a specific list.

Required Parameters​

  • Site ID: The ID of the site
  • List ID: The ID of the list

Optional Parameters​

  • Top: The number of sites to retrieve
  • Page: The page number to retrieve
Get List Items

Example:​

Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
List ID: 22f69173-0c1d-4c76-a721-5a31f0bd5af3
Top: 1
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('1a64ae23-9cb6-4521-b489-61d558dde9f7')/items(fields())",
  "@odata.nextLink": "https://graph.microsoft.com/v1.0/sites/tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb/lists/1a64ae23-9cb6-4521-b489-61d558dde9f7/items?$expand=fields&$top=1&$skiptoken=UGFnZWQ9VFJVRSZwX0lEPTE",
  "value": [
    {
      "@odata.etag": ""12b493eb-2452-451b-84e5-ecba8ec898c8,1"",
      "createdDateTime": "2024-10-24T11:11:11Z",
      "eTag": ""12b493eb-2452-451b-84e5-ecba8ec898c8,1"",
      "id": "1",
      "lastModifiedDateTime": "2024-10-24T11:11:11Z",
      "webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle/Lists/Test_table_query/1_.000",
      "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": {
        "id": "036d657d-ed69-4dcc-a669-483ce9788655",
        "siteId": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb"
      },
      "contentType": {
        "id": "0x0100A3D887BE30452F4A9CBA7E684C523E2100098058C6B440D14786561D28914A3EDB",
        "name": "Item"
      },
      "[email protected]": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/lists('1a64ae23-9cb6-4521-b489-61d558dde9f7')/items('1')/fields/$entity",
      "fields": {
        "@odata.etag": ""12b493eb-2452-451b-84e5-ecba8ec898c8,1"",
        "Title": "Null_test",
        "field_2": 10,
        "field_3": 123.32,
        "field_4": 1,
        "id": "1",
        "ContentType": "Item",
        "Modified": "2024-10-24T11:11:11Z",
        "Created": "2024-10-24T11:11:11Z",
        "AuthorLookupId": "7",
        "EditorLookupId": "7",
        "_UIVersionString": "1.0",
        "Attachments": false,
        "Edit": "",
        "LinkTitleNoMenu": "Null_test",
        "LinkTitle": "Null_test",
        "ItemChildCount": "0",
        "FolderChildCount": "0",
        "_ComplianceFlags": "",
        "_ComplianceTag": "",
        "_ComplianceTagWrittenTime": "",
        "_ComplianceTagUserId": ""
      }
    }
  ]
}

Update Item Of a List​

This operation updates an existing item in a list.

Required Parameters​

  • Site ID: The ID of the site
  • List ID: The ID of the list
  • Item ID: The ID of the item to update
  • Body: The updated values in JSON format
Update Item

Example:​

Site ID: tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb
List ID: 1a64ae23-9cb6-4521-b489-61d558dde9f7
Item ID: 1
Body:
{
  "TaskName": "Update Documentation",
  "Priority": "Medium",
  "DueDate": "2023-11-15T00:00:00Z"
}
Response Example
{
  "id": "1",
  "fields": {
    "TaskName": "Update Documentation",
    "Priority": "Medium",
    "DueDate": "2023-11-15T00:00:00Z"
  }
}

Delete Item Of a List​

This operation removes an item from a list.

Required Parameters​

  • Site ID: The ID of the site
  • List ID: The ID of the list
  • Item ID: The ID of the item to delete
Delete Item

Example:​

Site ID: tooljetxxxx.sharepoint.com,da60e844-ba1d-49bc-b4d4-d5e36bae9019
List ID: 22f69173-0c1d-4c76-a721-5a31f0bd5af3
Item ID: 1
Response Example
{
  "code": 204,
  "status": "No Content",
  "message": "Item having id '1' in List '1a64ae23-9cb6-4521-b489-61d558dde9f7' has been deleted."
}

Add Item To a List​

This operation adds a new item to a list.

Required Parameters​

  • Site ID: The ID of the site
  • List ID: The ID of the list
  • Body: The new item's data in JSON format
Add Item

Example:​

Site ID: tooljetxxxx.sharepoint.com,da60e844-ba1d-49bc-b4d4-d5e36bae9019
List ID: 22f69173-0c1d-4c76-a721-5a31f0bd5af3
Body:
{
  "fields": {
    "Title": "Prepare Presentation"
  }
}
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('1a64ae23-9cb6-4521-b489-61d558dde9f7')/items/$entity",
  "@odata.etag": ""95d95442-f155-45be-ae85-ef9acf1d35f9,1"",
  "createdDateTime": "2024-11-05T11:40:52Z",
  "eTag": ""95d95442-f155-45be-ae85-ef9acf1d35f9,1"",
  "id": "69",
  "lastModifiedDateTime": "2024-11-05T11:40:52Z",
  "webUrl": "https://tooljetxxxx.sharepoint.com/sites/NewStyle/Lists/Test_table_query/69_.000",
  "createdBy": {
    "user": {
      "email": "[email protected]",
      "id": "90ccfd6b-17ea-402b-aa21-1a1799a547d6",
      "displayName": "Oliver Smith"
    }
  },
  "lastModifiedBy": {
    "application": {
      "id": "0dc94ee2-9788-443c-8e67-ce714f0fe579",
      "displayName": "Microsoft Graph"
    },
    "user": {
      "email": "[email protected]",
      "id": "90ccfd6b-17ea-402b-aa21-1a1799a547d6",
      "displayName": "Oliver Smith"
    }
  },
  "parentReference": {
    "id": "036d657d-ed69-4dcc-a669-483ce9788655",
    "siteId": "tooljetxxxx.sharepoint.com,887cb371-e930-4e5b-a726-8d5769e6b946,6d653d09-1613-4663-99ab-1bb72ff6ceeb"
  },
  "contentType": {
    "id": "0x0100A3D887BE30452F4A9CBA7E684C523E2100098058C6B440D14786561D28914A3EDB",
    "name": "Item"
  },
  "[email protected]": "https://graph.microsoft.com/v1.0/$metadata#sites('tooljetxxxx.sharepoint.com%2C887cb371-e930-4e5b-a726-8d5769e6b946%2C6d653d09-1613-4663-99ab-1bb72ff6ceeb')/lists('1a64ae23-9cb6-4521-b489-61d558dde9f7')/items('69')/fields/$entity",
  "fields": {
    "@odata.etag": ""95d95442-f155-45be-ae85-ef9acf1d35f9,1"",
    "Title": "Prepare Presentation",
    "id": "69",
    "ContentType": "Item",
    "Modified": "2024-11-05T11:40:52Z",
    "Created": "2024-11-05T11:40:52Z",
    "AuthorLookupId": "7",
    "EditorLookupId": "7",
    "_UIVersionString": "1.0",
    "Attachments": false,
    "Edit": "",
    "LinkTitleNoMenu": "Prepare Presentation",
    "LinkTitle": "Prepare Presentation",
    "ItemChildCount": "0",
    "FolderChildCount": "0",
    "_ComplianceFlags": "",
    "_ComplianceTag": "",
    "_ComplianceTagWrittenTime": "",
    "_ComplianceTagUserId": "",
    "AppAuthorLookupId": "3",
    "AppEditorLookupId": "3"
  }
}