Looping data pull due to API limitation

[Anonymous]

Hi guys.

I am facing a problem with CISCO AMP API. I need to pull data but I am limited to 500 rows and any number greater than 500 gives error:
   DataSource.Error: Web.Contents failed to get contents from 'https://api.eu.amp.cisco.com/v1/computers?limit=501' (400): Bad Request
   Details:
   DataSourceKind=Web
   DataSourcePath=https://api.eu.amp.cisco.com/v1/computers
   Url=https://api.eu.amp.cisco.com/v1/computers?limit=501

I want to try to loop that data pull to give me next 500 rows multiple times to have all of 16k rows.

Can anyone help me with that? This is overwhelming me.

[v-cherch-msft]

Hi @Anonymous 

Please have a look at below posts to check if they could help.

https://community.powerbi.com/t5/Desktop/how-to-create-a-query-that-paginates/td-p/20047/page/7

Loop through Multiple Web Pages using Power Query

Iterating over multiple pages of web data using Power Query

For 3rd party Links:

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Regards,

[Anonymous]

Thank  you for your response but the thing is all records are within one sheet, on one page so the pagination solve different issue from what I see.