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
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

I despair a little of my problem. I have worked my way back and forth in this thread, but haven´t found the right solution.

 

I want to import all data from my JIRA database with a REST API. I get connection to JIRA but my datas are limited to 1000 rows. Unfortunately I have 13300 and it´s getting more and more every day.

 

I have tried almost every solution in this thread, but nothing seems to work for me or I am already so confused I don´t see my mistakes.

 

This is my basic code with the limitation of 1000:

 

let
    Quelle = Json.Document(Web.Contents("https://XXXX.XXXXXX.com/rest/api/2/search?jql=project%20in%20(10001%2C10001%2C13560)&maxResults=2000&fields=aggregatetimeoriginalestimate,timeestimate,timespent,customfield_13100,customfield_13101"))
in
    Quelle

 

Does anybody has a solution for it or can give some hints?

 

Thanks alot for your help!!!!!!!

freiburgc