PowerQuery (Excel results) prob with Pagination in Deals API
I'm new to both the HS API and Microsoft Power Query which is part of Excel and more. It was easy to grab the deals using the API but the limit of 250 messes me up. I cannot figure out how to code; I think it's called M-code, in PQ to do the pagination. Any help or even better samples would be amazing. What follows is my existing code minus my API key. All of it was generated by my manipulation of the query results and not hand coded.
You can look into Sprinkle Data in order to grab details from Hubspot to Power BI or any other reporting tool. Alternatively you can use Sprinkle for reporting purpose as well without any extra cost. In short, Sprinkle is your one stop solution for data integration and reporting.