How to retrieve SharePoint List items via Microsoft Graph REST API
To retrieve a SharePoint list through the Microsoft
Graph Connection by using the REST Source, you need to
perform the following steps:
- Establish a Microsoft Graph Connection (for more details, please check here);
- In the REST Source editor:
- in the Connection box - choose the
established Microsoft Graph Connection (e.g., REST Connection Manager 1 in the screenshot below);
- for Resource choose Site | List
Item from the drop-down menu;
- for Endpoint leave the <default>;
- in
Parameters in the list_Id forValue - you can choose the list
you want from the drop-down menu (see the screenshot below):
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
Navigating the 12 Lookup Column Limitation in Microsoft Graph API for SharePoint List Items
Introduction: When working with the Microsoft Graph REST API to retrieve data from SharePoint lists, it's essential to be aware of certain limitations. One such limitation involves the number of lookup columns that can be viewed in the API responses. ...How to use Microsoft Graph REST Configuration for SharePoint automation
If you are working with SharePoint Online, we recommend switching to Microsoft Graph Connection, which fully supports Modern Authentication. Additionally, we recommend using the latest version 2.2 or higher of COZYROC SSIS+. For upgrading details, ...How to Upload and Download Files in Microsoft Teams Using COZYROC File Transfer Task and Graph Connection
COZYROC's File Transfer Task enables seamless file operations within Microsoft Teams when used with the COZYROC Graph Connection. In the COZYROC Graph Connection configuration, the "Server Host" parameter specifies the base URL for the Microsoft ...How to Retrieve SharePoint Site and Subsite GUID
This article provides step-by-step instructions to retrieve the GUID (Globally Unique Identifier) for a SharePoint site and its subsites Retrieve the SharePoint Site GUID To get the GUID of a SharePoint site, use the following URL structure and copy ...Error Message: The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. Operations that exceed the list view threshold are allowed in the following time window defined by the administrator:
Action: While extracting data from list views using the SharePoint Source component, I am receiving the following error: Error Message: 'The attempted operation is prohibited because it exceeds the list view threshold enforced by the administrator. ...