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 Success Call
Need Help?
Evaluating COZYROC? --> Success Call
Customers --> Submit a Ticket
Related Articles
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 ...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 ...Microsoft Graph OAuth Token Wizard Stuck on "Need Admin Approval"
When generating an OAuth access token for Microsoft Graph using the COZYROC OAuth Token Wizard, the authentication process stops at the "Need admin approval" page, preventing the token from being generated. Resolution Open the COZYROC OAuth Token ...