Supported Microsoft Dynamics 365 Business Central APIs – Celigo Help Center

When you configure an export, import, or another type of flow step using the form view designed for the Microsoft Dynamics 365 Business Central connector, the following API operations are supported:

API v1.0 version operations

The following operations are available when you select v1.0 as the API version.

API	Operation	Export	Import
Account	List all accounts	X
Account	Get account	X
Aged accounts payable	Get aged accounts payable	X
Aged accounts receivable	Get aged accounts receivable	X
Balance sheet	Get balance sheet	X
Cash flow statement	Get cash flow statement	X
Companies	Get companies	X
Company information	Update company information		X
	List all companyInformation	X
	Get company information	X
Countries/regions	Create countries/regions		X
	Update countries/regions		X
	Create or Update countries/regions		X
	Delete countries/regions		X
	List all countries/regions	X
	Get countries/regions	X
Currencies	Create currencies		X
	Update currencies		X
	Create or Update currencies		X
	Delete currencies		X
	List all currencies	X
	Get Currencies	X
Customer	Create customer		X
	Update customer		X
	Create or Update customer		X
	Delete customer		X
	List all customers	X
	Get Customer	X
Customer financial details	Get Customer financial details	X
Customer payment	Create customer payment		X
	Update customer payment		X
	Delete customer payment		X
	Get Customer payment	X
Customer payments journal	Create customer payments journal		X
	Update customer payments journal		X
	Delete customer payments journal		X
	Get Customer payments journal	X
Customer sales	Get Customer sales	X
Dimension	List all dimensions	X
Dimension	Get dimension	X
Dimension line	Create dimension lines		X
	Update dimension lines		X
	Delete dimension lines		X
	Get dimension line	X
Dimension value	List all dimensionValues	X
Dimension value	Get dimension value	X
Employee	Create employee		X
	Update employee		X
	Create or Update employee		X
	Delete employee		X
	List all employees	X
	Get employee	X
General ledger entries	List all generalLedgerEntries	X
General ledger entries	Get general ledger entries	X
Income statement	Get income statement	X
IRS 1099	Create IRS 1099		X
	Update IRS 1099		X
	Create or Update IRS 1099		X
	Delete IRS 1099		X
	List all IRS 1099	X
	Get IRS 1099	X
Item	Create item		X
	Update item		X
	Create or Update item		X
	Delete item		X
	List all items	X
	Get item	X
Item categories	Create item categories		X
	Update item categories		X
	Create or Update item categories		X
	Delete item categories		X
	List all item categories	X
	Get item categories	X
Journal	Create journal		X
	Update journal		X
	Create or Update journal		X
	Delete journal		X
	List all journals	X
	Get journal	X
Journal line	Create journal line		X
	Update journal line		X
	Create or Update journal line		X
	Delete journal line		X
	List all journal lines	X
	Get journal line	X
Payment methods	Create payment methods		X
	Update payment methods		X
	Create or Update payment methods		X
	Delete payment methods		X
	List all payment methods	X
	Get payment methods	X
Payment terms	Create payment terms		X
	Update payment terms		X
	Create or Update payment terms		X
	Delete payment terms		X
	List all payment terms	X
	Get payment terms	X
Purchase invoice	Create purchase invoice		X
	Update purchase invoice		X
	Create or Update purchase invoice		X
	Delete purchase invoice		X
	List all purchase invoices	X
	Get purchase invoice	X
Purchase invoice line	Create purchase invoice line		X
	Update purchase invoice line		X
	Create or Update purchase invoice line		X
	Delete purchase invoice line		X
	List all purchase invoice lines	X
	Get purchase invoice line	X
Retained earnings statement	Get retained earnings statement	X
Sales credit memo	Create sales credit memo		X
	Update sales credit memo		X
	Create or Update sales credit memo		X
	Delete sales credit memo		X
	List all sales credit memos	X
	Get sales credit memo	X
Sales credit memo line	Create sales credit memo line		X
	Update sales credit memo line		X
	Create or Update sales credit memo line		X
	Delete sales credit memo line		X
	List all sales credit memo line	X
	Get sales credit memo line	X
Sales invoice	Create sales invoice		X
	Update sales invoice		X
	Create or Update sales invoice		X
	Delete sales invoice		X
	List all sales invoices	X
	Get sales invoice	X
Sales invoice line	Create sales invoice line		X
	Update sales invoice line		X
	Create or Update sales invoice line		X
	Delete sales invoice line		X
	List all sales invoice line	X
	Get sales invoice line	X
Sales order	Create sales order		X
	Update sales order		X
	Create or Update sales order		X
	Delete sales order		X
	List all sales orders	X
	Get sales order	X
Sales order line	Create sales order line		X
	Update sales order line		X
	Create or Update sales order line		X
	Delete sales order line		X
	List all sales order line	X
	Get sales order line	X
Sales quote	Create sales quote		X
	Update sales quote		X
	Create or Update sales order		X
	Delete sales quote		X
	List all sales quotes	X
	Get sales quote	X
Sales quote line	Create sales quote line		X
	Update sales quote line		X
	Create or Update sales order line		X
	Delete sales quote line		X
	List all sales quote line	X
	Get sales quote line	X
Shipment methods	Create shipment methods		X
	Update shipment methods		X
	Create or Update shipment methods		X
	Delete shipment methods		X
	List all shipment methods	X
	Get shipment methods	X
Subscription	Create subscriptions		X
	Update subscriptions		X
	Create or Update subscriptions		X
	Delete subscriptions		X
	Get subscriptions	X
Tax area	Create taxarea		X
	Update tax area		X
	Create or Update tax area		X
	Delete tax area		X
	List all tax areas	X
	Get tax area	X
Tax groups	Create tax groups		X
	Update tax groups		X
	Create or Update tax groups		X
	Delete tax groups		X
	List all tax groups	X
	Get tax groups	X
Time Registration Entry	Create time Registration Entry		X
	Update time Registration Entry		X
	Create or Update time Registration Entry		X
	Delete time Registration Entry		X
	Get time registration entries	X
Trail balance	List all trail balances	X
Trail balance	Get trail balance	X
Units of measure	Create units of measure		X
	Update units of measure		X
	Create or Update units of measure		X
	Delete units of measure		X
	List all units of measures	X
	Get units of measure	X
Vendor	Create vendor		X
	Update vendor		X
	Create or Update vendor		X
	Delete vendor		X
	List all vendors	X
	Get vendor	X
Vendor purchases	List all vendor purchases	X
Vendor purchases	Get vendor purchases	X

API v2.0 version operations

The following operations are available when you select v2.0 as the API version.

API	Operation	Export	Import
Account	Get all accounts	X
Account	Get account	X
Balance sheet	Get balance sheet	X
Bank account	Create bank accounts		X
	Updates bank accounts		X
	Create or update bank accounts		X
	Delete bank account		X
	Get bank account	X
	Get a bank account	X
Cash flow statement	Get all cash flow statement	X
Cash flow statement	Get a cash flow statement	X
Companies	Get companies	X
Companies	Get a company	X
Company Information	Get all companyInformation	X
Company Information	Get company information	X
Contact	Create contacts		X
	Updates contacts		X
	Create or update contacts		X
	Delete contacts		X
	Get all contacts	X
	Get a contact	X
Contact information	Get contactInformation	X
Countries regions	Create countries regions		X
	Updates countries/regions		X
	Create or update countries/regions		X
	Delete countries/regions		X
Countries/regions	Get all countries regions	X
Countries/regions	Get a country region	X
Currencies	Create currencies		X
	Updates currencies		X
	Create or update currencies		X
	Delete currencies		X
	Get all currencies	X
	Get a currency	X
Customer	Create customers		X
	Updates customers		X
	Create or update customers		X
	Delete customers		X
	Get all customers	X
	Get a customer	X
Customer Financial Details	Get customer financial details	X
Customer payment	Create customerPayments		X
	Update customerPayments		X
	Create or update customerPayments		X
	Delete customerPayments		X
	Get customerPayments	X
Customer payments journal	Create customerPaymentsJournals		X
	Update customerPaymentsJournals		X
	Create or update customerPaymentsJournals		X
	Delete customerPaymentsJournals		X
	Get customerPaymentsJournals	X
Customer sales	Get Customer sales	X
Employee	Create employees		X
	Update employees		X
	Create or update employees		X
	Delete employees		X
	Get all employees	X
	Get a employee	X
General ledger entries	List all generalLedgerEntries	X
General ledger entries	Get generalLedgerEntries	X
General product posting group	Get generalProductPostingGroups	X
Income statement	Get Income statement	X
Inventory posting group	Get inventoryPostingGroups	X
Item	Create item		X
	Update item		X
	Create or update item		X
	Delete item		X
	Get all items	X
	Get an item	X
Item categories	Create itemCategories		X
	Update itemCategories		X
	Create or update itemCategories		X
	Delete itemCategories		X
	List all itemCategories	X
	Get itemCategories	X
Item ledger entry	List all itemLedgerEntries	X
Item ledger entry	Get itemLedgerEntries	X
Journal	Create journals		X
	Update journals		X
	Create or update journals		X
	Delete journals		X
	List all journals	X
	Get journals	X
Journal line	Create journalLines		X
	Update journalLines		X
	Create or update journalLines		X
	Delete journalLines		X
	List all journalLines	X
	Get journalLines	X
Location	Create locations		X
	Update locations		X
	Create or update locations		X
	Delete locations		X
	List all locations	X
	Get locations	X
Opportunity	Create opportunities		X
	Update opportunities		X
	Create or update opportunities		X
	Delete opportunities		X
	List all opportunities	X
	Get opportunities	X
Payment methods	Create paymentMethods		X
	Update paymentMethods		X
	Create or update paymentMethods		X
	Delete paymentMethods		X
	List all paymentMethods	X
	Get paymentMethods	X
Payment terms	Create paymentTerms		X
	Update paymentTerms		X
	Create or update paymentTerms		X
	Delete paymentTerms		X
	List all paymentTerms	X
	Get paymentTerms	X
Project	Create projects		X
	Update projects		X
	Create or update projects		X
	Delete projects		X
	List all projects	X
	Get projects	X
Purchase invoice	Create purchaseInvoices		X
	Update purchaseInvoices		X
	Create or update purchaseInvoices		X
	Delete purchaseInvoices		X
	List all purchaseInvoices	X
	Get purchaseInvoices	X
Purchase invoice line	Create purchaseInvoiceLines		X
	Update purchaseInvoiceLines		X
	Create or update purchaseInvoiceLines		X
	Delete purchaseInvoiceLines		X
	List all purchaseInvoiceLines	X
	Get purchaseInvoiceLines	X
Purchase Order	Create purchse order		X
	Updates a purchase order		X
	Create or Update		X
	Delete purchase order		X
	List all purchase orders	X
	Get a purchase order	X
Purchase Order Lines	Create purchase order lines		X
	Updates the purchase order line		X
	Create or Update		X
	Delete purchase orderline		X
	List all purchase order lines	X
	Get a purchase order lines	X
Purchase receipt line	Get purchaseReceiptLines	X
Purchase Receipts	List all Purchase Receipts	X
Purchase Receipts	Get a purchase receipt	X
Retained earnings statement	Get retainedEarningsStatement	X
Sales credit memo	Create salesCreditMemos		X
	Update salesCreditMemos		X
	Create or update salesCreditMemos		X
	Delete salesCreditMemos		X
	List all salesCreditMemos	X
	Get salesCreditMemos	X
Sales credit memo line	List all salesCreditMemoLines	X
	Get salesCreditMemoLines	X
	Create salesCreditMemoLines		X
	Update salesCreditMemoLines		X
	Create or update salesCreditMemoLines		X
	Delete salesCreditMemoLines		X
Sales invoice	Create salesInvoices		X
	Update salesInvoices		X
	Create or update salesInvoices		X
	Delete salesInvoices		X
	List all salesInvoices	X
	Get salesInvoices	X
Sales invoice line	Create salesInvoiceLines		X
	Update salesInvoices		X
	Create or update salesInvoiceLines		X
	Delete salesInvoiceLines		X
	List all salesInvoiceLines	X
	Get salesInvoicelines	X
Sales order	Create sales order		X
	Update sales order		X
	Create or update sales order		X
	Delete sales order		X
	Get all sales order	X
	Get a sales order	X
Sales order line	Create salesOrderLines		X
	Update salesOrderLines		X
	Create or update salesInvoiceLines		X
	Delete salesOrderLines		X
	List all salesOrderLines	X
	Get salesOrderLines	X
Sales quote	Create salesQuotes		X
	Update salesQuotes		X
	Create or update salesQuotes		X
	Delete salesQuotes		X
	List all salesQuotes	X
	Get salesQuotes	X
Sales quote line	Create salesQuoteLines		X
	Update salesQuoteLines		X
	Create or update salesQuoteLines		X
	Delete salesQuoteLines		X
	List all salesQuoteLines	X
	Get salesQuoteLines	X
Sales shipment	List all salesShipments	X
Sales shipment	Get salesShipments	X
Sales shipment line	List all salesShipmentLines	X
Sales shipment line	Get salesShipmentLines	X
Shipment methods	Create shipmentMethods		X
	Update shipmentMethods		X
	Create or update shipmentMethods		X
	Delete shipmentMethods		X
	List all shipmentMethods	X
	Get shipmentMethods	X
Tax area	Create taxAreas		X
	Update taxAreas		X
	Create or update taxAreas		X
	Delete taxAreas		X
	List all taxAreas	X
	Get taxAreas	X
Time registration entry	Create timeRegistrationEntries		X
	Update timeRegistrationEntries		X
	Create or update timeRegistrationEntries		X
	Delete timeRegistrationEntries		X
	List all timeRegistrationEntries	X
	Get timeRegistrationEntries	X
Trial balance	Get trialBalance	X
Vendor	Create vendors		X
	Update vendors		X
	Create or update vendors		X
	Delete vendors		X
	List all vendors	X
	Get vendors	X
Vendor payment	Create vendorPayments		X
	Update vendorPayments		X
	Create or update vendorPayments		X
	Delete vendorPayments		X
	List all vendorPayments	X
	Get vendorPayments	X
Vendor payment journal	Create vendorPaymentJournals		X
	Update vendorPaymentJournals		X
	Create or update vendorPaymentJournals		X
	Delete vendorPaymentJournals		X
	List all vendorPaymentJournals	X
	Get vendorPaymentJournals	X
Vendor purchase	List all vendorPurchases	X
Vendor purchase	Get vendorPurchases	X

Related articles