Forum Discussion

jonclifford's avatar
jonclifford
New Member
8 years ago
Solved

JSON API has Page Load Limits - How can I get all records in one call

Hey guys, I am trying to pull records through json from the api from monday.com.  What is happening is they used to bring all of the results back in one go, but recently I noticed that my results kept being limited to about 15 records.  I contacted the support and the 15 is the default amount that is pulled back.  I can enter in a result set of up to 25 and can page the results.  The challenge is I don't know the total amount that needs to be pulled and I don't want to keep joining tables.  How can I set it up in power bi, to pull the all of the results (until there is non left) and add them into one table?

 

Thanks.  I appreciate it.

 

Jon