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.
Limitation: Viewing Only 12 Lookup Columns:
The limitation in question involves the maximum number of lookup columns that can be included in the response when querying for site list items using the Microsoft Graph API. Currently, only the first 12 lookup columns are visible in the API response.
Implications and Workarounds:
If your SharePoint list includes more than 12 lookup columns, you may encounter limitations when trying to retrieve all related data using Microsoft Graph API. In such cases, you might need to use the COZYROC reusable script as a workaround to retrieve data for each list item separately using the endpoint here.
Stay informed about updates and changes to Microsoft Graph API by referring to the official Microsoft Graph documentation.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
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 ...How to setup your client_id and client_secret values to connect with COZYROC Microsoft Dataverse Connector and Exchange Connector
This KB-Article explains how you can setup your own client_id and client_secret values instead of using default COZYROC app client id to connect with Microsoft Dataverse Connector and Exchange Connector. You can do all of your administrative tasks ...Where can I find the documentation for the Microsoft Graph Connection?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the Microsoft Graph Connection can be found at the following link. For many of the components you can ...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. ...