Dynamics 365 Business Central

Dynamics 365 Business Central is an ERP solution that provides extensive financial management tools for accurate expense and inventory tracking and budget management.

Data integration: Skyvia supports importing data to and from Dynamics 365 Business Central, exporting Dynamics 365 Business Central data to CSV files, replicating Dynamics 365 Business Central data to relational databases, and synchronizing Dynamics 365 Business Central data with other cloud apps and relational databases.

Backup: Skyvia Backup does not support Dynamics 365 Business Central.

Query: Skyvia Query supports Dynamics 365 Business Central.

Establishing Connection

Skyvia supports connection to Dynamics 365 Business Central Online and On-Premises. To create a connection to Dynamics 365 Business Central, choose the authentication type and provide credentials accordingly. Optionally, select the API to use.

You can use Dynamics 365 Business Central Standard API v2.0, custom API, or WebService API (OData V4 Web Services). By default, standard API 2.0 is used.

Getting Credentials

Web Server Access Key

To locate the Web Server Access Key, perform the following actions:

  1. Go to your Dynamics 365 Business Central instance web client.

  2. Click Search, type Users and select the Users page.

    User search in Dynamics 365 Business Central

  3. Choose the needed user and click its user name.

    User list in Dynamics 365 Business Central

  4. Copy the existing Web Server Access Key or generate a new one.

    Dynamics 365 Business Central user card

Server URL

To find your server URL, do the following:

  1. Open the Business Central Administration Shell on your server.
  2. The PublicOdataBaseURL value is your Server URL.

Dynamics 365 Business Central OData base URL

Creating Connection (OAuth)

To connect to Dynamics 365 Business Central using OAuth authentication, perform the following steps:

Dynamics 365 Business Central OAuth connection

  1. Click Sign In with Microsoft

    Signing in to Dynamics 365 Business Central

  2. Enter your email and password.

  3. Allow Skyvia to access your data.

    Granting permissions to Skyvia

  4. Select Environment from the drop-down list.

  5. Select Company.

  6. Optionally, select API Type.

  7. Only for the Custom API Type: specify API Publisher, API Group, and API Version.

    Custom API settings for Dynamics 365 Business Central OAuth connection

If your organization requires admin approval for third-party apps, your Microsoft administrator must grant access to Skyvia manually. Contact your Microsoft administrator to complete the connection.

Creating Connection (Basic)

Make sure the API access is enabled on your Dynamics 365 Business Central server. To connect to Dynamics 365 Business Central using Basic authentication, perform the following steps:

Dynamics 365 Business Central Basic authentication connection

  1. Specify your Dynamics 365 Business Central server URL.
  2. Enter the User.
  3. Enter the Web Server Access Key.
  4. Select Company from the drop-down list.
  5. Optionally, select API Type.
  6. Only for the Custom API Type: specify API Publisher, API Group, and API Version.

Custom API settings for Dynamics 365 Business Central Basic authentication connection

Additional Connection Parameters

Metadata Cache

You can specify the period after which Metadata Cache expires.

API Type

The API to use for the connection. Different API provide access to different objects. The avaiilable values are:

  • Standard - Standard API v2.0 - built-in Dynamics 365 Business Central REST API, that provide access to the standard Dynamics 365 Business Central objects.
  • Custom - user-defined REST API, created on the Dynamics 365 Business Central side using AL. Supports user-defined fields, complex, structured DTO, and data validation defined in AL.
  • Web Service - OData V4 Web Services, published manually via the Web Services page in Dynamics 365 Business Central. Allows you to publish any standard or custom page and any query without writing code.

API Publisher

Available only for Custom API Type. The organization, company, or vendor that owns the API.

API Group

Available only for Custom API Type. Logical category of the API.

API Version

Available only for Custom API Type. The version of the API.

Connector Specifics

Object Peculiarities

Objects with Binary Data

Our Dynamics 365 Business Central connector contains objects with binary fields. Such objects are related to other objects. Their names consist of the parent object name and the object type. There are four types of such objects: Attachment, PdfDocument, Picture, DimensionSetLine.

For example, there are ContactPicture, PurchaseInvoiceAttachment, and SalesCreditMemoPdfDocument objects. In this case, the Contact*, PurchaseInvoice* and SalesCreditMemo* parts correspond to the parent object names. And the *Picture, *Attachment, and *PdfDocument parts define the object types.

The DocumentAttachment object is an exception. It is a separate object.

Read-only objects

The following Dynamics 365 Business Central objects are read-only:

Account, AccountingPeriod, AgedAccountsPayable, AgedAccountsReceivable, Apicategoryroutes, BalanceSheet, CashFlowStatement, Company, ContactInformation, CurrencyExchangeRate, CustomerFinancialDetail, CustomerSale, Dimension, DimensionValue, EntityMetadata, Externalbusinesseventdefinitions, GeneralLedgerEntry, GeneralLedgerSetup, GeneralProductPostingGroup, IncomeStatement, InventoryPostingGroup, ItemLedgerEntry, PurchaseCreditMemoPdfDocument, PurchaseInvoicePdfDocument, PurchaseReceipt, PurchaseReceiptLine, RetainedEarningsStatement, SalesCreditMemoPdfDocument, SalesInvoicePdfDocument, SalesQuotePdfDocument, SalesShipment, SalesShipmentLine, TrialBalance, VendorPurchase.

Incremental Replication and Synchronization

Skyvia supports Replication with Incremental Updates for objects with either the CreatedAt or UpdatedAt field. Skyvia supports Synchronization for objects with either the CreatedAt or UpdatedAt fields and supports INSERT and UPDATE operations.

DML Operations Support

Skyvia supports the following DML operations for Dynamics 365 Business Central objects.

Operation Object
INSERT, UPDATE, DELETE BankAccount, Contact, CountryRegion, Currency, Customer, CustomerPayment, CustomerPaymentDimensionSetLine, CustomerPaymentJournal, CustomerReturnReason, DefaultDimension, DocumentAttachment, Employee, Externaleventsubscriptions, FixedAsset, FixedAssetLocation, GeneralLedgerEntryAttachment, GeneralLedgerEntryDimensionSetLine, Item, ItemCategory, ItemVariant, Journal, JournalLine, JournalLineAttachment, JournalLineDimensionSetLine, Location, Opportunity, PaymentMethod, PaymentTerm, Project, PurchaseCreditMemo, PurchaseCreditMemoAttachment, PurchaseCreditMemoDimensionSetLine, PurchaseCreditMemoLine, PurchaseCreditMemoLineDimensionSetLine, PurchaseInvoice, PurchaseInvoiceAttachment, PurchaseInvoiceDimensionSetLine, PurchaseInvoiceLine, PurchaseInvoiceLineDimensionSetLine, PurchaseOrder, PurchaseOrderAttachment, PurchaseOrderDimensionSetLine, PurchaseOrderLine, PurchaseOrderLineDimensionSetLine, PurchaseReceiptDimensionSetLine, PurchaseReceiptLineDimensionSetLine, SalesCreditMemo, SalesCreditMemoAttachment, SalesCreditMemoDimensionSetLine, SalesCreditMemoLine, SalesCreditMemoLineDimensionSetLine, SalesInvoice, SalesInvoiceAttachment, SalesInvoiceDimensionSetLine, SalesInvoiceLine, SalesInvoiceLineDimensionSetLine, SalesOrder, SalesOrderAttachment, SalesOrderDimensionSetLine, SalesOrderLine, SalesOrderLineDimensionSetLine, SalesQuote, SalesQuoteAttachment, SalesQuoteDimensionSetLine, SalesQuoteLine, SalesQuoteLineDimensionSetLine, SalesShipmentDimensionSetLine, SalesShipmentLineDimensionSetLine, ShipmentMethod, TaxArea, TaxGroup, TimeRegistrationEntry, TimeRegistrationEntryDimensionSetLine, UnitOfMeasure, Vendor, VendorPayment, VendorPaymentDimensionSetLine, VendorPaymentJournal
UPDATE, DELETE ItemPicture, CustomerPicture, ContactPicture, VendorPicture, EmployeePicture
UPDATE CompanyInformation, ApplyVendorEntry

Supported Actions

Skyvia supports all the common actions for

On This Page