06-07-2019 01:02 AM - edited 02-20-2020 09:09 PM
I am having a problem with pulling data from AMP API via Power Query(POWER BI/MS Excel). It is limiting me to pull just 500 of 10k rows and any attempt of setting the number of rows to be pulled results with error.
Can you guys confirm if the CISCO AMP API is limited to pull maximum of 500 rows? I am struggling with this for couple of days now and I will appreciate any of your help on how to pull the all data.
06-07-2019 02:25 AM
Hello @listky,
took a look into the API documentation and found to following information.
Maybe TAC can help here, but i´m not sure. Sorry not having a better answer.
Greetings,
Thorsten
06-07-2019 05:01 AM
You need to set an offset if there are pagination results (more than returns in the first query). For example, &offset=500.
Hope that helps,
Matt
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide