Skip to main content

Issue with Returning Records

The API isn't returning all records. How do I retrieve all of them?

Written by Lenka Haringerová

To retrieve all records from a given register, you need to add the parameter limit=0.

The default ABRA Flexi output without the limit parameter always returns only the first 20 records. To retrieve the complete list, you must use the parameter limit=0. We do not recommend using the limit parameter with a high number (e.g., limit=9999). This approach would only work until the number of records exceeds that value.

The results can optionally be paginated by correctly using the limit and start parameters.

If you want to find out how many records match your query, add the parameter add-row-count=true.

Also use the add-row-count parameter only in queries where it makes sense. For example, if you need to display address books page by page in ABRA Flexi, use this parameter only in the first query. This is because the parameter adds an extra query to the database (select count(*) from …). For some outputs, processing such a query may introduce unnecessary delays.

Example:

https://demo.flexibee.eu/c/demo/faktura-vydana.xml – výpis prvních 20 faktur https://demo.flexibee.eu/c/demo/faktura-vydana.xml?limit=0 – výpis všech faktur
Did this answer your question?