When calling the Payhawk API to retrieve or filter data, the system may return only 999 results instead of the full dataset. This occurs because Payhawk’s API applies a pagination limit of 1,000 records per page.
Cause
The API enforces this limit by default to ensure stable performance and prevent large queries from slowing down processing. If a user or client attempts to load more data (for example, all suppliers above a certain threshold such as EUR 4,000), the API will only return the first 1,000 entries.
Solution
To retrieve all records beyond the initial 1,000‑record limit, you need to use pagination parameters:
$takedefines how many records the API should return per page.$skipdefines the starting point (offset) for the next set of records in the dataset.
For example, if you want to receive 100 records per page, use the following parameters with your GET request:
First page:
$take=100&$skip=0Second page:
$take=100&$skip=100
Repeat this pattern, increasing $skip by the same value as $take for each subsequent page (for example, $skip=200, $skip=300, and so on).