how to retrieve all records from a table using REST API ?

Hi,

I have a table which holds 500+ records, i want to retrieve all of them with single request. But when i try from REST console, i see we can give maximum page size of 100 (which mean i can retrieve at most 100 records).

So please me know how can i achieve this.

Thanks,
Santhosh P

Hi!
You should implement pagging algorithm to load data from table.
Next page you can load from nextPage value

Hi Kate,

Thanks for the reply. But is there a way to retrieve all records at once instead of pagination ?

Regards,
Santhosh P

Santhosh,

You can do it with the Managed Cloud option, where we can remove that limitation for you.

Regards,
Mark

Hi Mark,

Can you explain in detail ? you mean through standalone cloud deployment ?

Regards,
Santhosh P

HI Mark,

Can you explain in detail ? you mean through standalone cloud deployment ?

We are planning for a launch of our app during mid September 2016. So we have few open question about extending some services (like increasing the calls/per second etc)before the launch, so is there way i can talk with any of the backendless team on this?

Thanks and Regards,
Santhosh P

Santhosh,

No, I mean the Managed Backendless deployment. It is a dedicated deployment of Backendless which we stage, run and monitor specifically for you application. Please send an email to sales@backendless.com to get the conversation going.

Regards,
Mark

Hi Mark,

Thanks for the response. One last question before i close this and continue conversation on the email provided, so the limit can be removed only through Managed Backedless ?

Regards,
Santhosh P

Yes. With Managed Backendless we can remove all limits except for API/sec and file storage.

Using the managed Backendless does not mean that my app is hosted, it’s still a standalone app with a kind of special settings controlled by Backendless ?! And is it possible to use both options alternative paging or ALL records ?