Forum Discussion
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
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
1 Reply
- v-huizhn-msft
Microsoft Employee
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