Forum Discussion
gotmike
10 years agoFrequent Visitor
how to create a query that paginates?
I'm working with the Hubspot CRM API and when you query for a list of all deals, you only get 100 records at a time, and they want you to send subsequent queries with an "offset" to paginate the resu...
julianchen
Advocate I
8 years agoHi ImkeF,
I'm trying to link to a dictionary provided by Investopedia.com with a slicer of 26 English letters plus a "#" mark. Under each option there are hundreds of terms available with a hyperlink to blow by blow explanations correspondingly. In order to reiterate the multiple pages over the web data it seems to require two parameters for alphabet and page number respectively in M language. I put a pbix here for your reference. Hopefully you would like to guide me to complete it. Thanks.
Julian Chen
ImkeF
Community Champion
8 years agoHi julianchen,
please have a look at this file: https://1drv.ms/u/s!Av_aAl3fXRbehbJKWOtDP86f5R726A
Does the table "Parameter Table_Rows" contain what you're after?