topic Re: Get Organization Devices using standard web API call in Network Platform API

Get Organization Devices using standard web API call

Nabi — Thu, 11 Apr 2024 10:18:58 GMT

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.

Re: Get Organization Devices using standard web API call

sungod — Thu, 11 Apr 2024 13:12:32 GMT

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/

Re: Get Organization Devices using standard web API call

Nabi — Thu, 11 Apr 2024 14:08:22 GMT

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.

Re: Get Organization Devices using standard web API call

Philip D'Ath — Thu, 11 Apr 2024 15:56:42 GMT

The first link @jscorb gave you includes examples.

Re: Get Organization Devices using standard web API call

Jamiegprice15 — Thu, 11 Apr 2024 15:58:53 GMT

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.