Dynamics 365 Business Central

Version 0.1.1


Checkout the Business Central API docs here for more information

Set up

To get set up with Dynamics 365 Business Central you will need to log in with your username and password. Then you will need to provide the following:

  • Tenant ID In the overview section of you app registration, you should see your “Directory (tenant) ID”
  • Environment Name The business central environment that you would like to pull data from


IncrementalSome reports only, seen below
Custom backfill
API reliability🟢Reliable

Reports detail

⬇️ Report🔑 Incremental key🔑 Primary key📄 Link to API endpoint
CompaniesnoneidGet companies
JournalsLAST_MODIFIED_DATE_TIMEidGet journals
Journal LinesLAST_MODIFIED_DATE_TIMEidGet journalLines
Sales OrdersLAST_MODIFIED_DATE_TIMEidGet salesOrders
Sales Order LinesnoneidGet salesOrderLines
Sales ShipmentsLAST_MODIFIED_DATE_TIMEidGet salesShipments
Sales Shipment LinesnoneidGet salesShipmentLines
Sales InvoicesLAST_MODIFIED_DATE_TIMEidGet salesInvoices
Purchase OrdersLAST_MODIFIED_DATE_TIMEidGet purchaseOrders
Purchase Order LinesnoneidGet purchaseOrderLines
Purchase InvoicesLAST_MODIFIED_DATE_TIMEidGet purchaseInvoices
Purchase Invoice LinesnoneidGet purchaseInvoiceLines
Sales Credit MemosLAST_MODIFIED_DATE_TIMEidGet salesCreditMemos
Sales Credit Memo LinesnoneidGet salesCreditMemoLines
Ledger EntriesLAST_MODIFIED_DATE_TIMEidGet generalLedgerEntries
AccountsLAST_MODIFIED_DATE_TIMEidGet accounts
Vendor PurchasesnoneidGet vendorPurchases
Vendor PaymentsLAST_MODIFIED_DATE_TIMEidGet vendorPayments
Vendor Payment JournalsLAST_MODIFIED_DATE_TIMEidGet vendorPaymentJournals
CustomersLAST_MODIFIED_DATE_TIMEidGet customers
Cash Flow StatementsnoneidGet cashFlowStatements
DimensionsLAST_MODIFIED_DATE_TIMEidGet Dimensions
Default DimensionsLAST_MODIFIED_DATE_TIMEidGet Default Dimensions
Dimension Set LinesLAST_MODIFIED_DATE_TIMEidGet Dimension Set Lines