Table API
The web site provides Table API to the ERP.net table model using the OData (Open Data Protocol) standard. Table API allows for data consumption in a RESTful manner and offers external applications the opportunity to interact with the table model.
The primary purpose of the Table API is to allow external BI (Business Intelligence) tools to quickly pull raw data for further analysis.
Table API is secured using OAuth 2.0, which provides an industry-standard for authorization.
Rate limits
Table API is subject to rate limiting, which means that the number of requests you can make within a given time period is limited. The rate limit policy for this API includes multiple constraints, such as the maximum number of requests per minute, maximum number of concurrent requests, and so on. If you exceed any of these constraints, your requests may be rejected with an error response.
For more information, see the separate topic Rate limits.
Applicable rate limits
Below are the rate limiting options supported by Table API:
- GlobalConcurrentRequests - Caps total concurrent API requests across all sessions.
License availability
A request is served inside a session, and a session needs a concurrent-use license. When the instance has none available, the request is answered with 503 - Service Unavailable and a Retry-After header stating how long to wait before repeating it. The response body names the reason, so the caller can tell it apart from a failed operation.
For more information, see the separate topic Sessions and licenses.