Get Organization Devices using standard web API call

[Nabi]

Hi all,

I hope you're doing well.

I'm currently working on a project where I need to retrieve data for all our devices using the standard web API call and integrate it into PowerBI for reporting purposes. However, I've encountered an issue where the API limits the response to only 1000 devices, whereas we have more than that in our network.

I've explored the documentation and found that I might need to utilize parameters such as "startingAfter" and "endingBefore" to overcome this limitation, but I'm unfamiliar with how to implement them effectively.

I would greatly appreciate your support and guidance in finding a solution to this issue.

Thank you for your assistance.

[sungod]

You need to use the pagination features, see...

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

A simple way is to use the Meraki Python library as it can handle this for you, as well as rate limiting, which is another topic...

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

https://developer.cisco.com/meraki/api-v1/rate-limit/

[Nabi]

Hi @jscorb,

Thanks for your response and the resources you provided.

Currently, I'm using Meraki Python code to retrieve data, which works well. However, I'm unable to schedule automatic refreshes in PowerBI due to the process's nature. This is why I'm exploring the standard web API call.

While I've reviewed the documentation on pagination, I'm still seeking additional resources, guidance or demo. If you have any suggestions, I'd appreciate it.

[Philip D'Ath]

The first link @jscorb gave you includes examples.

[Jamiegprice15]

This code does an inventory collection of all APs for your org.
Merakicode/MerakiInventory.py at main · jadexing/Merakicode (github.com)

I have some code that also gives serial numbers in my collection, too.