cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Handling Pagination of JSON response received from HTTP GET Custom API

Settings.PNGI 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 ?

 

1 REPLY 1
Highlighted
Community Support
Community Support

Re: Handling Pagination of JSON response received from HTTP GET Custom API

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Users online (5,911)