Microsoft Sharepoint

1. Overview

The Microsoft SharePoint tool in GoInsight lets you automate list records and document-library files through Microsoft Graph API. It is designed to cover the same core Microsoft SharePoint capabilities that n8n's official SharePoint node exposes, so you can read lists, read and maintain list items, and work with files in a site's default drive.

This tool currently supports three main resource areas:

• List: inspect a single SharePoint list or enumerate lists in a site
• Item: create, read, update, delete, paginate, and create-or-update list items
• File: upload, download, and replace file content in the site's default document library

2. Prerequisites

Before using the Microsoft SharePoint tool, make sure you have:

• A valid Microsoft 365 account with access to the target SharePoint site
• An OAuth2 access token for Microsoft Graph API
• Appropriate Microsoft Graph permissions such as Sites.Read.All, Sites.ReadWrite.All, Files.Read, or Files.ReadWrite, depending on the action
• The correct SharePoint site_id, plus list_id, item_id, or file item ID when required

3. Credentials

For credential setup instructions, please refer to our official documentation: Credential Configuration Guide.

4. Supported Operations

Summary

Operation Details

Get a List

Retrieves metadata for a single SharePoint list.

Use when:

• You already know list_id and need to confirm the list exists
• You want the list template, visibility, description, or webUrl

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID format (hostname,siteCollectionId,siteId) or path format (hostname:/sites/sitePath). Example: contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.

Output:

• List (object): Full list metadata object returned by Microsoft Graph, including id, displayName, description, webUrl, list.template, and list.hidden.
• Summary (string): One-sentence description of the result, for example Retrieved list 'Tasks' (id: a1b2c3d4...) from site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried. true for transient errors such as rate limits or timeouts, false for permanent errors such as invalid IDs or missing permissions.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream. Use for debugging.
• StatusCode (number): Normalized status code. 200 = success or business error (check ErrorMessage), -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Get Many Lists

Lists SharePoint lists in the specified site.

Use when:

• You need to discover valid list_id values before reading or writing items
• You need to paginate through all lists in a large site

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing.
• Limit (number): Maximum number of lists to return per page. Defaults to 100 when not specified.

Options:

• PageToken (string): Cursor token from a previous response's NextPageToken. Omit for the first page.

Output:

• Lists (array): Array of list metadata objects. Each object contains id, displayName, description, webUrl, and list.template.
• HasMore (boolean): Whether additional pages are available. Pass NextPageToken to the next call to continue.
• NextPageToken (string): Cursor token to retrieve the next page. Empty string when no more pages exist.
• Summary (string): One-sentence description of the result, for example Retrieved 12 list(s) from site 'contoso.sharepoint.com:/sites/marketing'. No more pages.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Get an Item

Retrieves a single SharePoint list item, including all returned field values.

Use when:

• You already know item_id and want to read its current field values
• You want to verify the current item state before an update

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.
• ItemId (string): Item ID inside the target list. Obtain from Get Many Items. Example: 42.

Output:

• Item (object): Item object containing id (string), fields (object of all column values), createdDateTime (string), lastModifiedDateTime (string), and webUrl (string).
• Summary (string): One-sentence description of the result, for example Retrieved list item 'My Task' (id=42) from list 'a1b2c3d4...' in site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Get Many Items

Returns one page of SharePoint list items.

Use when:

• You need to inspect or export list contents
• You need to discover item_id values before update or delete actions

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.
• Limit (number): Maximum number of items to return per page.

Options:

• PageToken (string): Cursor token from a previous response's NextPageToken. Omit for the first page.

Output:

• Items (array): Array of item objects. Each object contains id, fields, createdDateTime, lastModifiedDateTime, and webUrl.
• HasMore (boolean): Whether additional pages are available.
• NextPageToken (string): Cursor token to retrieve the next page. Empty string when no more pages exist.
• Summary (string): One-sentence description of the result, including page count and whether more pages remain.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Create an Item

Creates a new item in a SharePoint list.

Use when:

• You want to insert a new list record and already know the list schema

Key points:

• Fields must be an object, not a JSON string
• Field names are case-sensitive and must use SharePoint internal column names (not display names)

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.
• Fields (object): Object of field name/value pairs for the new item. Field names are case-sensitive internal column names, for example {"Title": "My Task", "AssignedTo": "alice@contoso.com"}.

Output:

• Item (object): Created item object including id, fields, createdDateTime, lastModifiedDateTime, and webUrl.
• Summary (string): One-sentence description of the result, for example Created list item (id=101) in list 'a1b2c3d4...' of site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Create or Update an Item

Creates a new SharePoint item or updates the first uniquely matched existing item.

Use when:

• You need create-or-update behavior based on a business key such as Title or another unique column

Key points:

• MatchFieldName should be selective enough to identify at most one item; the action fails on ambiguous matches instead of updating an arbitrary record
• Update behavior is PATCH-style: only provided fields are changed and omitted fields remain unchanged
• MatchFieldName must use the SharePoint internal column name, not the display name. Common mappings: Task Name → Title, Assigned To → AssignedTo, Due Date → DueDate
• The lookup sends Prefer: HonorNonIndexedQueriesWarningMayFailRandomly to support non-indexed match fields when allowed by SharePoint

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Can often be copied from the site URL, for example contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.
• MatchFieldName (string): Internal column name used as the create-or-update match key. Example: Title.
• MatchFieldValue (string): Value used to find an existing item by MatchFieldName. Example: Q1 Budget Review.
• Fields (object): Object of field name/value pairs to create or patch. Example: {"Title": "Q1 Budget Review", "Status": "In Progress"}.

Output:

• Operation (string): Result of the upsert. Either created (new item was inserted) or updated (existing item was patched).
• Item (object): The created or updated item object, including id, fields, createdDateTime, lastModifiedDateTime, and webUrl.
• Summary (string): One-sentence description of the result, including the matched field and operation type.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Update an Item

Partially updates one existing SharePoint list item.

Use when:

• You already know item_id and only want to change selected fields

Key points:

• Only fields included in Fields are changed; omitted fields remain unchanged (PATCH semantics)

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.
• ItemId (string): Target item ID. Obtain from Get Many Items. Example: 42.
• Fields (object): Object of field name/value pairs to patch. Only provided fields are changed. Example: {"Status": "Completed", "DueDate": "2025-12-31"}.

Output:

• UpdatedFields (object): The updated item fields returned by Microsoft Graph after the PATCH operation.
• Summary (string): One-sentence description of the result, for example Updated item '42' in list 'a1b2c3d4...' of site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Delete an Item

Permanently deletes one SharePoint list item.

Use when:

• You intentionally want to remove a list record

Key points:

• Confirm must be explicitly set to true; the action returns an error without executing if Confirm is false
• Deletion is permanent and cannot be undone through this tool

Input Parameters:

• SiteId (string): SharePoint site identifier in Graph full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing.
• ListId (string): SharePoint list GUID. Obtain from Get Many Lists. Example: a1b2c3d4-1234-5678-abcd-ef0123456789.
• ItemId (string): Target item ID to delete. Obtain from Get Many Items. Example: 42.
• Confirm (boolean): Must be true to execute permanent deletion. Anything other than true is rejected.

Output:

• Deleted (boolean): true if the item was successfully deleted.
• Summary (string): One-sentence description of the result, for example Deleted list item '42' from list 'a1b2c3d4...' in site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Download a File

Retrieves file metadata and a temporary download URL for a SharePoint file.

Use when:

• You need to hand off a file download link to a downstream step
• You need the file name, size, MIME type, or browser URL before processing the file

Key points:

• DownloadUrl is a pre-authenticated temporary URL that typically expires within 1 hour; use it immediately

Input Parameters:

• SiteId (string): SharePoint site ID in full-ID or path format. Example: contoso.sharepoint.com:/sites/marketing. Obtain from site discovery or by confirming site context via Get Many Lists.
• ItemId (string): Drive item ID of the file. Obtain from Get Many Items. Example: 01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K.

Output:

• DownloadUrl (string): Pre-authenticated temporary download URL. Typically valid for about 1 hour. Empty string on failure.
• FileName (string): File name including extension, for example report.xlsx. Empty string on failure.
• FileSize (number): File size in bytes. 0 on failure.
• MimeType (string): MIME type of the file, for example application/vnd.openxmlformats-officedocument.spreadsheetml.sheet. Empty string on failure.
• WebUrl (string): Browser URL to view the file in SharePoint Online. Empty string on failure.
• Summary (string): One-sentence description of the result, for example Prepared download info for file 'report.xlsx' (item_id=01BYE5RZ...) in SharePoint site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Upload a File

Uploads a small file to the site's default drive.

Use when:

• You want to create a new file in the site's default document library or a known folder

Key points:

• FileContent must be pure Base64 without a data: prefix; the content API supports files up to 250 MB
• If the target path already exists, the content API may overwrite that file

Input Parameters:

• SiteId (string): SharePoint site ID in full-ID or path format. Obtain from site discovery or by confirming site context via Get Many Lists. Example: contoso.sharepoint.com:/sites/marketing.
• FileName (string): Target file name including extension. Example: report.xlsx. File names cannot contain /, \, :, *, ?, ", <, >, or |.
• FileContent (string): Base64-encoded file content only, without a data: prefix. Example: JVBERi0xLjQK... (PDF header). Generate via shell base64 -i report.pdf.

Options:

• ParentFolderItemId (string): Folder item ID for the upload destination. Obtain from Get Many Items. Omit to upload to the site's default document library root.

Output:

• FileId (string): Drive item ID of the uploaded file. Empty string on failure.
• FileName (string): Name of the uploaded file. Empty string on failure.
• FileSize (number): Size of the uploaded file in bytes. 0 on failure.
• WebUrl (string): Browser URL to view the file in SharePoint Online. Empty string on failure.
• DownloadUrl (string): Pre-authenticated temporary download URL. Empty string on failure.
• CreatedDateTime (string): Creation timestamp in ISO 8601 format, for example 2025-01-15T10:30:00Z. Empty string on failure.
• Summary (string): One-sentence description of the result, for example Uploaded file 'report.xlsx' to SharePoint site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

Update a File

Replaces the contents of an existing SharePoint file.

Use when:

• You already know the drive item_id and want to overwrite the file content

Key points:

• This replaces file content only, not list-item metadata (title, columns, etc.)
• This is a full overwrite and is irreversible; the content API supports files up to 250 MB
• FileContent must be pure Base64 without a data: prefix

Input Parameters:

• SiteId (string): SharePoint site ID in full-ID or path format. Obtain from site discovery or by confirming site context via Get Many Lists. Example: contoso.sharepoint.com:/sites/marketing.
• ItemId (string): Drive item ID of the target file. Obtain from Get Many Items. Example: 01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K.
• FileContent (string): Base64-encoded replacement content, without a data: prefix. You can reuse the DownloadUrl content from Download a File or generate via shell base64 -i updated_report.pdf.

Output:

• FileId (string): Drive item ID of the updated file. Empty string on failure.
• FileName (string): Name of the updated file. Empty string on failure.
• FileSize (number): Size of the updated file in bytes after replacement. 0 on failure.
• WebUrl (string): Browser URL to view the updated file in SharePoint Online. Empty string on failure.
• DownloadUrl (string): Pre-authenticated temporary download URL for the updated file. Empty string on failure.
• CreatedDateTime (string): Original creation timestamp in ISO 8601 format. Empty string on failure.
• Summary (string): One-sentence description of the result, for example Updated file 'report.xlsx' (item_id=01BYE5RZ...) in SharePoint site 'contoso.sharepoint.com:/sites/marketing'.
• Hint (string): Actionable next step if the operation failed. Empty string on success.
• Retryable (boolean): Whether the same call can be retried.
• OriginalStatusCode (number): Raw HTTP status code from Microsoft Graph API. 0 means the request never reached upstream.
• StatusCode (number): Normalized status code. 200 = success or business error, -1 = parameter validation error, 500 = network or system error.
• ErrorMessage (string): Detailed error message if any error occurred. Empty string on success.

5. Example Usage

This section walks through a common workflow: reading all items from a SharePoint list and updating a specific item's status field.

Scenario: You have a SharePoint task list named "Project Tasks" and want to mark an item as "Completed" after your workflow processes it.

Workflow Overview: Start → Microsoft SharePoint (Get Many Lists) → Microsoft SharePoint (Get Many Items) → Microsoft SharePoint (Update an Item) → Answer

Step-by-Step Guide:

1. Discover the list ID:
   • Add a Microsoft SharePoint node and select Get Many Lists.
   • Set SiteId to your site, for example contoso.sharepoint.com:/sites/project.
   • Run the node. Locate the id field of "Project Tasks" in the Lists output — this is your list_id.
2. Read the items:
   • Add a second Microsoft SharePoint node and select Get Many Items.
   • Set SiteId to the same site and ListId to the GUID obtained in step 1.
   • Set Limit to 50 for the first page. If HasMore is true, pass NextPageToken into the next call to continue.
   • Identify the target item's id from the Items array.
3. Update the item:
   • Add a third Microsoft SharePoint node and select Update an Item.
   • Set SiteId, ListId, and ItemId using values from the previous steps.
   • Set Fields to {"Status": "Completed"}.
   • Run the node and confirm StatusCode is 200 and ErrorMessage is empty.

Result: The target item's Status column is updated to "Completed". All other fields remain unchanged because Update an Item uses PATCH semantics.

6. FAQs

Q: How do I find my SharePoint site_id?

A: The easiest way is to call Get Many Lists with your site's URL in path format (for example contoso.sharepoint.com:/sites/marketing). If the call succeeds, the site_id you used is correct. Alternatively, you can find the site ID in the SharePoint Admin Center or by making a direct Microsoft Graph call to /v1.0/sites/{hostname}:/sites/{sitePath}.

Q: What is the difference between item_id for a list item and a file?

A: SharePoint exposes two kinds of IDs. List item IDs are short integers (for example 42) scoped to a list and obtained via Get Many Items on a list. Drive item IDs are long alphanumeric strings (for example 01BYE5RZ6QN3ZWBTUFOFD3GSPGOHDJD36K) and refer to files or folders in a document library. File actions (Download a File, Upload a File, Update a File) require a drive item ID, not a list item ID.

Q: Why does Create or Update an Item fail with an ambiguous match error?

A: The MatchFieldName column you specified matched more than one item. This action intentionally rejects ambiguous matches to avoid updating the wrong record. Use a more unique column (or add additional filters to narrow down to a single item) before calling upsert again.

Q: The DownloadUrl I received has expired. What should I do?

A: Pre-authenticated download URLs from Microsoft Graph are temporary and typically expire within one hour. Call Download a File again to get a fresh URL. Design your workflow so the URL is consumed immediately after retrieval rather than stored for later use.

Q: Can I upload files larger than 4 MB?

A: Yes. This tool uses the Microsoft Graph content upload API which supports files up to 250 MB. For files larger than 250 MB, a resumable upload session is required, which is not currently supported by this tool.

Q: Why do my Get Many Items results not include all list columns?

A: Microsoft Graph returns a default set of fields per item. Columns with no value or system-managed columns (such as _ModerationStatus, AppAuthor) may be omitted. This is normal Graph API behavior and does not indicate missing data.

7. Official Documentation

Microsoft Graph SharePoint API Reference