topic Re: Using Powershell how to paginate thru pages. in Network Platform API

Using Powershell how to paginate thru pages.

smeyer1 — Mon, 15 Jul 2024 15:57:41 GMT

I am trying to get network events for last 30 days, the /network/{networkid}/events has a perPage value of 3 to 1000. The documentation is unclear how to pageinate the calls. Does anyone have a working example of pulling several pages of events and placing into a spreadsheet.

Re: Using Powershell how to paginate thru pages.

riduque — Mon, 15 Jul 2024 22:53:47 GMT

You can include this parameter to reduce the amount of pages:

- perPage: Range is 3 - 1000. Default is 10.

The entire explanation about how Pagination works in Meraki APIs, including an example, is here: https://developer.cisco.com/meraki/api-v1/pagination/#pagination

Re: Using Powershell how to paginate thru pages.

smeyer1 — Mon, 15 Jul 2024 22:57:58 GMT

I have maxed out the permanent. WhatsApp need is how to get to the next 1000 entries

Re: Using Powershell how to paginate thru pages.

riduque — Mon, 15 Jul 2024 23:10:58 GMT

Have you tried using this parameter in your query?

perPage=1000&startingAfter=1001

Re: Using Powershell how to paginate thru pages.

Philip D'Ath — Tue, 16 Jul 2024 07:41:53 GMT

Did you spot this bit from the link @riduque supplied?

"When you send an API request to a paginated operation, the number of records that are actually queried in the database is equal to the value of perPage. Then, the HTTP response will contain a custom header named Link. The Link header is a comma-separated list of up to 4 links: first, prev, next, and last. These links represent subsequent requests that can be used to navigate the paginated records. These links will include appropriate values for the startingAfter or endingBefore parameters in order to achieve this navigation. The exact format of the Link header might look something like:"

Re: Using Powershell how to paginate thru pages.

Philip D'Ath — Tue, 16 Jul 2024 07:43:02 GMT

Going sideways - have you considered using the Meraki Python SDK for this? It does all the pagination automatically for you, so you can ignore the issue.

Re: Using Powershell how to paginate thru pages.

smeyer1 — Tue, 16 Jul 2024 12:11:02 GMT

There is no links returned in the response. This is why documentation is not very well.

Re: Using Powershell how to paginate thru pages.

smeyer1 — Tue, 16 Jul 2024 12:11:33 GMT

Unforturnately is has to be written in powershell.

Re: Using Powershell how to paginate thru pages.

smeyer1 — Tue, 16 Jul 2024 14:22:00 GMT

Get GetBlueToothclients and Get NetworkEvents, no change same data coming down each time.

Re: Using Powershell how to paginate thru pages.

JasperAspect — Tue, 23 Jul 2024 08:21:44 GMT

Just happend to have a similar issue. I came up with this function. Hope this helps

Function Get-Clients {

param (

[Parameter(mandatory=$true)]$MerakiApiKey,

[Parameter(mandatory=$true)]$networkId,

$perPage = "50"

)

$headers = @{

"X-Cisco-Meraki-API-Key" = $MerakiapiKey

"Content-Type" = "application/json"

"Accept" = "application/json"

}

$ClientBody = @{

perPage = $perPage

}

$clientsurl = "https://api.meraki.com/api/v1/networks/$networkId/clients"

$AllClientData = $null

do {

Write-Host "Requesting clients from $clientsurl"

$result = Invoke-WebRequest -Uri $clientsurl -Headers $Headers -Body $ClientBody

$AllClientData += $result.Content | ConvertFrom-Json

$clientsurl = $result.RelationLink.next

} until ($clientsurl -notlike "https://api.meraki.com/*")

return $AllClientData

}

Re: Using Powershell how to paginate thru pages.

smeyer1 — Tue, 23 Jul 2024 15:05:57 GMT

thanks, what i found out from your answer is that Invoke-RestMethod only returns a JSON object, and does not allow you access to the Headers in the response. Thanks.

Re: Using Powershell how to paginate thru pages.

uvega — Thu, 15 May 2025 21:29:11 GMT

This doesnt work, does the same thing as perPage=1000