REST API - Paging
Hi all,
I am running up against the limit of 1,000 records when using the REST API (as well as the CSV export, btw). Is there a way to do "paging" in REST? That is, can I return 0-999 then 1000-1999, etc.
Thanks a lot,
Carl
Forum Discussion
Hi mrentropy
absolutely - if you are using rest v1 you can use page=X&page_size=100 (where X is the page you want to load and the page size is the amount of records per page). The REST V1 documentation pages will tell you which calls support this.
If you are using REST v2 you can use the OFFSET and LIMIT keywords : see the documentation here
Kind Regards,
- mrentropy, these threads might be of great help for you as well.
https://community.lithium.com/t5/Developers-Discussion/Implement-custom-pagination/m-p/106695#M3927
https://community.lithium.com/t5/Developers-Discussion/Freemarker-Pagination/m-p/57090#M1889 Thanks so much to you both for your answers! I'm a bit of a newbie, and I'm puzzled that it seems like not enough data is coming back. For example, if I have a page size of 1,000 results, page 1 has data, but page 2 looks like this:
Any further tips on what I could be missing? I am trying to create a backup of all our ideas.
<?xml version="1.0" encoding="utf-8" standalone="yes" ?><threads /></response>Cheers,
Carl
Hi Carl,
could you please share the call you are attempting and the parameters that you are passing?
Cheers,
Absolutely! Thanks again for the help. page=1 returns several results. page=2 returns nothing.
<our lithium url>/restapi/vc/search/messages?q=idea&restapi.response_style=view&collapse_discussion=false&restapi.format_detail=full_list_element&page_size=1000&page=1
- Actually, could I be running into the error you discussed in this post?
http://community.lithium.com/t5/Developers-Discussion/REST-call-API-v1-limited-number-of-results/m-p/183156/thread-id/7334
