Microsoft SharePoint icon

Microsoft SharePoint

Interact with Microsoft SharePoint API

List → Get

AI-generated

Summary

Retrieve one SharePoint list from a selected site by choosing the list or entering its ID. By default, request and return common list details; turn off Simplify to request the full list response.

Inputs

  • Site (required) — Select a site from the list or enter its ID.
  • List (required) — Select a list from the chosen site or enter its ID.
  • Simplify — Defaults to true. Requests id, name, displayName, description, createdDateTime, lastModifiedDateTime, and webUrl. When false, omits the $select query so the API can return its default list fields.
  • Request Options — Optional batching, SSL certificate validation, proxy, and timeout settings for the request.

Output shape

A single list record as one n8n output item.

With Simplify enabled, the post-processing also removes @odata.context and @odata.etag from the returned record. API errors, including a list not found, are raised as node errors.

Examples

Example 1: Get a known list by ID

Select a site and enter the list ID; keep Simplify enabled for the common list details.

Example 2: Retrieve all available fields

Select a site and list, then disable Simplify so the request does not specify the common-field $select.

Links

Discussion