Forum Discussion

Helper I

3 years ago

Hubspot Private Apps - Powerquery pagination

Has anybody managed to paginate hubspots api with the new private apps setup? Managed to make a call easily enough like so; let Source = Json.Document(Web.Contents("https://api.hubapi.com/...

Administrator

3 years ago

This is the URL I sued to filter from the 1st January 2023

"https://api.hubapi.com/email/public/v1/events?&startTimestamp=1672531200000&limit=1000&properties=recipient&properties=type&properties=portalId&properties=appId&properties=appName&properties=emailCampaignId&property=subject&property=dropReason&property=dropMessage&property=duration"

the timestamp is in milliseconds, I use https://currentmillis.com to convert the date to milliseconds

Cheers

Will

Forum Discussion

Hubspot Private Apps - Powerquery pagination

Related content

Paginating API calls to Hubspot

PowerQuery transformation

Power BI Connection to HubSpot

Paginated Report

PowerQuery Rest API Pagination