Odata NextLink no work with Api Graph reports

Question

Hi,

When I use the Graph APIs which return JSON, like those for users, no problem, the pagination works well.

But with the Graph report APIs, which are in CSV format in V1.0, when we force beta with the json format, the impression is that it does not understand the following url well

beta/reports/getSharePointSiteUsageDetail(period='D180')?$format=application/json&$top=1000

I only have the 1000 results in the parquet file
wihtout &$top=1000 , only 200.

I tried adding a $ in front $['@odata.nextLink'], same result

In postman, I also have the impression that the whole url is not underlined like in another API but it works when I take it entirely

An idea ?

Thanks for your help.

Best regards

Answer 1

Hi Steph ,

Welcome to Microsoft Q&A platform and thanks for posting your question here. It seems like you are facing an issue with pagination when using the Microsoft Graph API to retrieve SharePoint site usage details in JSON format.

Pagination with Microsoft Graph API typically involves using the @odata.nextLink property in the response to retrieve the next set of results.

Could you please try using None : $['@odata.nextLink'] as pagination treats $ as the json starting position. If we do not provide $ then we need to use body else use none property.

Also, please try having the full baseurl instead of separating it with the endpoint as seen in your screenshot.

Additional resource: Azure Data Factory (ADF) Quick Tip: Using Graph API to Extract Azure AD Information

Paging Microsoft Graph data in your app

Hope it helps. Kindly let us know how it goes. Thankyou.