topic Re: Not getting full results when running API's in Network Platform API

Not getting full results when running API's

mrheavydee95 — Tue, 22 Aug 2023 17:37:07 GMT

I'm having issues getting all the results when running API calls when I run them via the developer site and Postman. When I run "Get Organization Devices" its not displaying all devices (2100+). I tried the per-page param to 50 (max) and I'm still missing data. Any suggestions?

Re: Not getting full results when running API's

sungod — Tue, 22 Aug 2023 17:46:56 GMT

The call https://developer.cisco.com/meraki/api-v1/get-organization-devices/ has a default (and maximum) per-page limit of 1,000. If you set it to 50 you'll only get 50 per page.

If there are more devices than will fit onto the page, you need to make further calls (following the pagination handling rules) to get the remaining page(s) of data.

With 2,100 devices it'll be at least 3 pages of data.

If you use the Python library it can handle pagination for you, otherwise you'd need to arrange it yourself.

Python library: https://github.com/meraki/dashboard-api-python

Pagination: https://developer.cisco.com/meraki/api-v1/pagination/

Re: Not getting full results when running API's

mrheavydee95 — Tue, 22 Aug 2023 18:29:01 GMT

Thanks for the quick reply sungod.

I looked into the Pagination but the only 2 categories it shows for the startingafter parameter are "Timestamps" and "Interger IDs". The endpoint is showing that its looking for a string. Any idea what they're looking for?

Re: Not getting full results when running API's

sungod — Tue, 22 Aug 2023 18:53:53 GMT

The values needed to navigate subsequent pages are in the link headers returned by the call.

It's explained in the documentation page I linked, look at the 'Example' section.

I.e. you need to select/parse the link headers, or take the easy way out and just use the Python Library 😀

Re: Not getting full results when running API's

mrheavydee95 — Tue, 22 Aug 2023 20:32:08 GMT

I'm sure once it would be easier once I figure out Python Library (which I never used before). I'm getting SSL errors when trying to run it with Python.

Re: Not getting full results when running API's

Philip D'Ath — Tue, 22 Aug 2023 20:39:59 GMT

As a tip, I've found Google Bard good at writing Python scripts to use the Meraki API. I'm now at the point where if I need to create something, I start with Google Bard and take it from there. It's just a faster way to develop.

https://bard.google.com/

Re: Not getting full results when running API's

sungod — Wed, 23 Aug 2023 14:13:06 GMT

If you are running on Windows and getting SSL problems this thread might help...

https://community.meraki.com/t5/Developers-APIs/SSL-error-in-python/m-p/186146

I don't use it on Windows, but others do, so probably someone else can help you if the above thread doesn't resolve it.

Re: Not getting full results when running API's

mrheavydee95 — Mon, 28 Aug 2023 16:00:52 GMT

I appreciate everyone's response to this thread.

I tried the link you sent over sungod, I did the following and I'm still getting a cert error:

- exported the cert from the portal and saved it locally

- ran the verify command (verify="c:\temp\nameofcert.crt")

I even tried verify=False which still gave me the same SSL Cert error.