Possible to get more than 1000 records in return?

[Tom Stude]

It seems that the max number of rows returned is set to 1000 even though I ask for ex. 5000. Is it possible to override that for queries that returns a small set of columns?

[Marius Bancila]

No, you cannot get more than 1000 at a time. This is a limit we set for performance reasons. Maybe it could be higher but currently it is set to 1000.

If you need to fetch more records, you should use pagination: https://docs.business.visma.net/docs/features/pagination.