Pagination between Xano and Parabola

Abrar

I have a Xano table with 70k records that I need to pull into a Google sheet via Parabola. I've setup pagination on Xano to pull the records with Parabola via an API request, however when I setup Parabola with the following settings I only seem to get the first page of data for each page I fetch.

Where am I going wrong?


[Screenshot 2022-01-27 at 18.53.58.png]

Michael Udinski

Hey  when using paging on the Query All Records function, the result is static based on the pagination settings you use. If you wish to have dynamic paging of a single API response you need to utilize external paging which allows for pagination override from a front-end or other tool:

https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/external-query-manipulation/external-paging

Abrar

Thanks I've set this up but it's still not working and I'm getting duplicates again. It looks like Parabola can't customised to add the 'external' input JSON syntax when paginating, so the individual input requests are coming in as:

{
page: 
2
}

I've tried the workaround here:
https://docs.xano.com/working-with-data/functions/database-requests/query-all-records/external-query-manipulation/external-sorting#alternate-to-json-input

But it's still returning the first page, even in debug mode. 
Can you suggest any workarounds for this?

Michael Udinski

Just want to update that this was resolved through support... the JSON structure included an extra object.