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

[jonclifford]

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

[v-huizhn-msft · Accepted solution]

Hi @jonclifford,

Please refer to this similar thread, and there is detailed solution there.

http://community.powerbi.com/t5/Desktop/JSON-Joining-Records-in-Groups/td-p/327823

Best Regards,
Angelia