Table API

Introduction

The table API contains endpoints with a 1-to-1 mapping towards Empire tables. This API only contains readonly services (only GET methods), and can be used to extract data from Dynamics Empire in a fast and reliable way. To access this API you need to have a valid (licensed) Business Central account. Authentication is possible through OAuth (Online) or basic authentication (Both ompremis and Online) using web api-keys.

Table API's contains a publisher, a groupname and a version number in the URL:

• publisher is static: zig
• groupname is: tablesFinance, tablesGeneral, tablesHousing or tablesRealEstate
• version is static: v2.0

Base URL for using this API:

Onpremis: https://server:7048/Instance/api/< publisher >/< groupname >/< version >/companies('CompanyName')/EndPoint e.g.:

• https://MyServer:7048/Instance/api/zig/tablesFinance/v2.0/companies('My Company')/custLedgerEntries

DEOnline: https://deonline.api.bc.dynamics.com/v2.0/Environment/< publisher >/< groupname >/< version >/companies('CompanyName')/EndPoint e.g.:

• https://deonline.api.bc.dynamics.com/v2.0/Environment/zig/tablesGeneral/v2.0/companies('My Company')/customers

All endpoints of this API are grouped in logical domains. Below you find a list of the groupnames, and the API pages it contains.

Groups