Table Query API

Table Query API

The Table Query API provides a high-performance REST interface for developers, partners, and system integrators who need tabular and incremental data access to Microsoft Dynamics 365 Business Central.
It enables direct and efficient data retrieval for integration, synchronization, and analytics scenarios.

With the Table Query API, data can be retrieved from any Business Central table using internal table IDs, filters, field selections, sorting, and paging parameters.
The API is optimized for large data volumes and enables incremental synchronization using the SystemModifiedAt field.

Key Features

• Access data from any Business Central table by internal table ID
• Use filters, sorting, skip/take, and field selection for maximum control
• Retrieve only modified records using the SystemModifiedAt field
• Metadata endpoint for table and field information
• Ideal for ETL, BI, and data synchronization scenarios

Typical Use Cases

• Integration with third-party systems such as ERP, CRM, or DMS platforms
• Building custom connectors or middleware solutions
• Extracting Business Central data into data warehouses or reporting tools
• Incremental synchronization of master data and documents

Benefits

• Fast and reliable access to large datasets
• Easy to implement for both cloud and on-premises systems
• Reduces the complexity of Business Central integrations
• Supports modern authentication and security standards

Provided by Co-Orga – empowering Business Central integrations with simplicity and performance.