SharePoint Get List Item

Get a list item from SharePoint using the PnPjs 'sp' object
Join our community

Overview

This node retrieves a specific item from a SharePoint list using the SharePoint REST API via the PnPjs library. It is useful when you need to fetch detailed information about a single list item by its ID within a given SharePoint site and list. Common scenarios include automating workflows that require reading metadata or content of a particular SharePoint list item, such as processing approvals, syncing data, or generating reports.

For example, you might use this node to get the details of a task item in a project management list or retrieve a document's metadata from a document library by specifying the site URL, list name or ID, and the item ID.

Properties

Name Meaning
Site URL The base URL of the SharePoint site where the target list resides. Example: https://contoso.sharepoint.com/sites/example
List Name or ID The name or GUID of the SharePoint list to query. You can provide either the list's display name or its unique ID. Example: My List or 12345678-1234-1234-1234-123456789012
Item ID The numeric ID of the SharePoint list item to retrieve. Example: 1

Output

The node outputs an array with one element per input item. Each element contains the JSON representation of the requested SharePoint list item. This JSON includes all fields and metadata returned by the SharePoint API for that item.

No binary data output is produced by this node.

Dependencies

  • Requires an API authentication token credential for accessing SharePoint with appropriate permissions.
  • Uses the PnPjs library (sp object) internally to interact with SharePoint REST endpoints.
  • The node expects the SharePoint site URL, list identifier, and item ID to be valid and accessible with the provided credentials.

Troubleshooting

  • Invalid Site URL or List Name/ID: If the site URL or list name/ID is incorrect or inaccessible, the node will fail to retrieve the item. Verify the URLs and list identifiers are correct and that the authenticated user has access.
  • Item Not Found: If the specified item ID does not exist in the list, the node will throw an error indicating the item could not be found. Double-check the item ID.
  • Authentication Errors: Ensure the API authentication token has sufficient permissions to read list items on the specified SharePoint site.
  • Non-numeric Item ID: The node converts the item ID to a number; providing a non-numeric value may cause errors. Always supply a valid numeric item ID.

Links and References

Discussion