Limit the API requests sent to the server.

データ型

string

デフォルト値

"25"

解説

Set this property to -1 or an empty string to remove the limit.

For the ReportDetails table, LIMIT will overwrite this value.

This connection property is best used when using LIMIT on ReportDetailsExpenseEntry and similar tables: SELECT * FROM [ReportDetailsExpenseEntry] LIMIT 10.

If ReportLimit is 25, then the driver will send a single request to the Reports endpoint to get 25 report IDs, which is the pagination of the Reports endpoint. After this request, the driver will send requests to the ReportDetails endpoint until 10 expense entries are found. It may happen that less than 10 expense entries are found, in which case you will need to increase the ReportLimit.

If ReportLimit is set too high, such as 1000, then there will be 40 requests (if there are more than 1000 reports). After these requests, then the driver will send requests to the ReportDetails endpoint until 10 expense entries are found.