Get-MgBookingsBusiness/Graph API Pagination Limits = 1000

Question

Has anyone had success pulling all Bookings Businesses of their tenant over 1000?&nbsp; I cannot for the life of me figure out how to get past 1000 results because there are.&nbsp;# Make sure you're connected
# Connect-MgGraph -Scopes "Bookings.Read.All"

$uri = "https://graph.microsoft.com/v1.0/solutions/bookingBusinesses"
$allBusinesses = @()

Write-Host "🔄 Starting paged retrieval..."

do {
    # Send GET request
    $response = Invoke-MgGraphRequest -Method GET -Uri $uri

# Extract raw JSON
    $json = $response | ConvertTo-Json -Depth 10
    $parsed = $json | ConvertFrom-Json

# Add current page of businesses
    $allBusinesses += $parsed.value

Write-Host "  Retrieved $($parsed.value.Count) businesses..."

# Next page URL if available
    $uri = $parsed.'@odata.nextLink'
}
while ($null -ne $uri)

Write-Host "✅ Total retrieved: $($allBusinesses.Count)"

# Export to CSV properly
$desktopPath = [Environment]::GetFolderPath("Desktop")
$exportPath = Join-Path $desktopPath "all_bookings_full.csv"

# Choose specific fields to export (optional - improves readability)
$allBusinesses |
    Select-Object id, displayName, email, phone, address |
    Export-Csv -Path $exportPath -NoTypeInformation -Encoding UTF8

Write-Host "✅ Exported clean data to: $exportPath"&nbsp;

lainrobertson · Answer

Hi AP_TC_ECASD​,&nbsp;I don't use this endpoint but I'm surprised you're getting 1,000 to begin with, as the documentation for this endpoint (both the v1 and beta) states a hard limit of 500 applies:&nbsp;List bookingBusinesses - Microsoft Graph beta | Microsoft LearnNote: Results are limited to 500 mailboxes. Pagination of the results is not currently supported.&nbsp;Cheers,Lain

bart_pasmans · Answer

Hi AP_TC_ECASD​,You could also try the PowerShell Graph SDK if you want to:https://learn.microsoft.com/en-us/powershell/microsoftgraph/get-started?view=graph-powershell-1.0This will handle pagination for you automatically if I'm not mistaken. If you run into retries, time-outs etc. this abstraction will also take care of it for you.&nbsp;&nbsp;You can use:&nbsp;$allBusinesses = Get-MgBookingBusiness -AllTo get the bookings. See:&nbsp;https://learn.microsoft.com/en-us/powershell/module/microsoft.graph.bookings/get-mgbookingbusiness?view=graph-powershell-1.0&nbsp;My gut feeling says you might be running into either Rate limiting somehow, or something with the token doing the API call.&nbsp;Kind regards,Bart&nbsp;&nbsp;

Forum Discussion

Get-MgBookingsBusiness/Graph API Pagination Limits = 1000

2 Replies

Resources