Handling Pagination of JSON response received from HTTP GET Custom API

[ParthNikhra]

I am using MS flows and trying to retrieve Office 365 audit log search report using Office 365 management API there are more than 3000 items but only getting 100 results. I have already enabled the required Pagination settings(refer to the provided screen shot) and constructed the API as per the requirement. I am using HTTP connector to access the below API.

https://outlook.office365.com/psws/service.svc/UnifiedAuditLog?StartDate=@{variables('StartDate')}&E...

Could you please let me know how to retrieve all the items in a report ?

[v-yamao-msft]

Hi @ParthNikhra,

Please check the doc about pagination at here:

https://flow.microsoft.com/en-us/blog/four-connector-action-settings/

From the doc we know that Pagination enables you to handle more records than are returned in a single call from a service. For example, some services only return back 50 items at a time, however, in the flow, you may want to get all the items in the list. By turning on pagination, the flow engine will continue to call the service until it has all of the items.

About your scenario, if you have more than 3000 items, you could turn on Pagination and set the limit to 5000. As currently the maximum items that flow can return is 5000. Please check the doc on limits for more details:

https://docs.microsoft.com/en-us/flow/limits-and-config

Please take a try with it on your side.

Best regards,

Mabel Mao