Forum Discussion

gotmike's avatar
gotmike
Frequent Visitor
10 years ago

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...
Need Help
PerK's avatar
PerK
Frequent Visitor
7 years ago

Quick follow-up:

 

Got some of the headers through: 

 

let
    Källa = Value.Metadata(Web.Contents("https://[account].table.core.windows.net/[tablename]?st=2018-11-08T12%3A41%3A00Z&se=2018-12-10T12%3A41%3A00Z&sp=r&sv=2017-04-17&tn=history0debug&sig=[Shared Access Key]")) as record,
    #"Konverterad till tabell" = Record.ToTable(Källa)
in
   Källa

Which gives me:

 

 

Navigating to the "Headers" record only gives me "application/atom+xml;type=feed;charset=utf-8" but not the continuation tokens needed.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
7 years ago

Have no experience with that API, so no help on this one unfortunately.

  • PerK's avatar
    PerK
    Frequent Visitor
    7 years ago

    No worries.

     

    I got access to a secondary key and could access the Table Storage through the "normal" API instead, and, from what I can tell, now I get all the entities I query for, without pagination.

     

    Cheers!