Microsoft Dynamics 365 Business Central
Use Dataddo's Microsoft Dynamics 365 Business Central connector to explore any data available via the official API of Microsoft Dynamics 365 Business Central. Access hundreds of metrics and attributes, from basic to advanced. Build and blend custom datasets directly in Dataddo, then send them anywhere.
Data Category
Contacts (10)
Contacts (21)
Country/Region (5)
Currencies (7)
Currency Exchange Rates (7)
Customers (24)
Dimension Set Lines (11)
Dimension Values (5)
Dimensions (4)
General Ledger Entry (11)
General Ledger Setup (17)
General Product Posting Groups (6)
Inventory Posting Groups (3)
Item Categories (5)
Items (21)
Items Variants (5)
Opportunities (18)
Payment Terms (8)
Sales Invoices (51)
Sales Orders (50)
Sales Quotes (49)
Shipment Methods (4)
Tax Groups (5)
Need fields you don't see?
Let us know and we'll add them to the connector. Just send a request here..
Available Attributes (347)
| Attribute |
|---|
id ID |
number Number |
displayName Display Name |
category Category |
subCategory Sub Category |
blocked Blocked |
accountType Account Type |
directPosting Direct Posting |
netChange Net Change |
lastModifiedDateTime Last Modified Date Time |
id ID |
number Number |
type Type |
displayName sensitive Display Name |
companyNumber Company Number |
companyName Company Name |
businessRelation Business Relation |
addressLine1 sensitive Address Line 1 |
addressLine2 sensitive Address Line 2 |
city City |
state State |
country Country |
postalCode sensitive Postal Code |
phoneNumber sensitive Phone Number |
mobilePhoneNumber sensitive Mobile Phone Number |
email sensitive |
website Website |
searchName Search Name |
privacyBlocked Privacy Blocked |
lastInteractionDate Last Interaction Date |
lastModifiedDateTime Last Modified Date Time |
id ID |
code Code |
displayName Display Name |
addressFormat Address Format |
lastModifiedDateTime Last Modified Date Time |
id ID |
code Code |
displayName Display Name |
symbol Symbol |
amountDecimalPlaces Amount Decimal Places |
amountRoundingPrecision Amount Rounding Precision |
lastModifiedDateTime Last Modified Date Time |
id ID |
currencyCode Currency Code |
startingDate Starting Date |
exchangeRateAmount Exchange Rate Amount |
relationalCurrencyCode Relational Currency Code |
relationalExchangeRateAmount Relational Exchange Rate Amount |
lastModifiedDateTime Last Modified Date Time |
id ID |
number Number |
displayName sensitive Display Name |
type Type |
addressLine1 sensitive Address Line 1 |
addressLine2 sensitive Address Line 2 |
city City |
state State |
country Country |
postalCode sensitive Postal Code |
phoneNumber sensitive Phone Number |
email sensitive |
website Website |
taxLiable Tax Liable |
taxAreaId Tax Area ID |
taxAreaDisplayName Tax Area Display Name |
taxRegistrationNumber Tax Registration Number |
currencyId Currency ID |
currencyCode Currency Code |
paymentTermsId Payment Terms ID |
shipmentMethodId Shipment Method ID |
paymentMethodId Payment Method ID |
blocked Blocked |
lastModifiedDateTime Last Modified Date Time |
ledgerEntryId ID |
fieldId ID |
fieldCode code |
fieldConsolidationCode Consolidation Code |
fieldParentId Parent ID |
fieldParentType Parent Type |
fieldDisplayName Display Name |
valueId Value Id |
valueCode Value Code |
valueConsolidationCode Value Consolidation Code |
valueDisplayName Value Display Name |
id ID |
code Code |
dimensionId Dimension ID |
displayName Display Name |
lastModifiedDateTime Last Modified Date Time |
id ID |
code Code |
displayName Display Name |
lastModifiedDateTime Last Modified Date Time |
id ID |
entryNumber Entry Number |
postingDate Posting Date |
documentNumber Document Number |
documentType Document Type |
accountId Account ID |
accountNumber Account Number |
description Description |
debitAmount Debit Amount |
creditAmount Credit Amount |
lastModifiedDateTime Last Modified Date Time |
etag etag |
additionalReportingCurrency additionalReportingCurrency |
allowPostingFrom allowPostingFrom |
allowPostingTo allowPostingTo |
allowQueryFromConsolidation allowQueryFromConsolidation |
id id |
lastModifiedDateTime lastModifiedDateTime |
localCurrencyCode localCurrencyCode |
localCurrencySymbol localCurrencySymbol |
shortcutDimension1Code shortcutDimension1Code |
shortcutDimension2Code shortcutDimension2Code |
shortcutDimension3Code shortcutDimension3Code |
shortcutDimension4Code shortcutDimension4Code |
shortcutDimension5Code shortcutDimension5Code |
shortcutDimension6Code shortcutDimension6Code |
shortcutDimension7Code shortcutDimension7Code |
shortcutDimension8Code shortcutDimension8Code |
id ID |
code Code |
description Description |
defaultVATProductPostingGroup Default VAT Product Posting Group |
autoInsertDefault Auto Insert Default |
lastModifiedDateTime Last Modified Date Time |
id ID |
code Code |
description Description |
id ID |
code Code |
displayName Display Name |
symbol Symbol |
lastModifiedDateTime Last Modified Date Time |
id ID |
number Number |
displayName Display Name |
type Type |
itemCategoryId Item Category ID |
itemCategoryCode Item Category Code |
blocked Blocked |
gtin GTIN |
inventory Inventory |
unitPrice Unit Price |
priceIncludesTax Price Includes Tax |
unitCost Unit Cost |
taxGroupId Tax Group ID |
taxGroupCode Tax Group Code |
baseUnitOfMeasureId Base Unit of Measure ID |
baseUnitOfMeasureCode Base Unit of Measure Code |
generalProductPostingGroupId General Product Posting Group ID |
generalProductPostingGroupCode General Product Posting Group Code |
inventoryPostingGroupId Inventory Posting Group ID |
inventoryPostingGroupCode Inventory Posting Group Code |
lastModifiedDateTime Last Modified Date Time |
id ID |
itemId Item ID |
itemNumber Item Number |
code Code |
description Description |
id ID |
number Number |
contactNumber Contact Number |
contactName sensitive Contact Name |
contactCompanyName Contact Company Name |
salespersonCode Salesperson Code |
description Description |
status Status |
closed Closed |
creationDate Creation Date |
dateClosed Date Closed |
calculatedCurrentValue Calculated Current Value |
chancesOfSuccessPrc Chances of Success (%) |
completedPrc Completed (%) |
estimatedClosingDate Estimated Closing Date |
estimatedValue Estimated Value |
systemCreatedAt System Created At |
lastModifiedDateTime Last Modified DateTime |
id ID |
code Code |
displayName Display Name |
dueDateCalculation Due Date Calculation |
discountDateCalculation Discount Date Calculation |
discountPercent DiscountPercent |
calculateDiscountOnCreditMemos Calculate Discount On Credit Memos |
lastModifiedDateTime Last Modified Date Time |
id ID |
number Number |
externalDocumentNumber External Document Number |
invoiceDate Invoice Date |
postingDate Posting Date |
dueDate Due Date |
customerPurchaseOrderReference Customer Purchase Order Reference |
customerId Customer ID |
customerNumber Customer Number |
customerName sensitive Customer Name |
billToName sensitive Bill To Name |
billToCustomerId Bill To Customer ID |
billToCustomerNumber Bill To Customer Number |
shipToName sensitive Ship To Name |
shipToContact sensitive Ship To Contact |
sellToAddressLine1 sensitive Sell To Address Line 1 |
sellToAddressLine2 sensitive Sell To Address Line 2 |
sellToCity Sell To City |
sellToCountry Sell To Country |
sellToState Sell To State |
sellToPostCode sensitive Sell To Post Code |
billToAddressLine1 sensitive Bill To Address Line 1 |
billToAddressLine2 sensitive Bill To Address Line 2 |
billToCity Bill To City |
billToCountry Bill To Country |
billToState Bill To State |
billToPostCode sensitive Bill To Post Code |
shipToAddressLine1 sensitive Ship To Address Line 1 |
shipToAddressLine2 sensitive Ship To Address Line 2 |
shipToCity Ship To City |
shipToCountry Ship To Country |
shipToState Ship To State |
shipToPostCode sensitive Ship To Post Code |
currencyId Currency ID |
currencyCode Currency Code |
orderId Order ID |
orderNumber Order Number |
paymentTermsId Payment Terms ID |
shipmentMethodId Shipment Method ID |
salesperson sensitive Salesperson |
pricesIncludeTax Prices Include Tax |
remainingAmount Remaining Amount |
discountAmount Discount Amount |
discountAppliedBeforeTax Discount Applied Before Tax |
totalAmountExcludingTax Total Amount Excluding Tax |
totalTaxAmount Total Tax Amount |
totalAmountIncludingTax Total Amount Including Tax |
status Status |
lastModifiedDateTime Last Modified DateTime |
phoneNumber sensitive Phone Number |
email sensitive |
id ID |
number Number |
externalDocumentNumber External Document Number |
orderDate Order Date |
postingDate Posting Date |
customerId Customer ID |
customerNumber Customer Number |
customerName sensitive Customer Name |
billToName sensitive Bill To Name |
billToCustomerId Bill To Customer ID |
billToCustomerNumber Bill To Customer Number |
shipToName sensitive Ship To Name |
shipToContact sensitive Ship To Contact |
sellToAddressLine1 sensitive Sell To Address Line 1 |
sellToAddressLine2 sensitive Sell To Address Line 2 |
sellToCity Sell To City |
sellToCountry Sell To Country |
sellToState Sell To State |
sellToPostCode sensitive Sell To Post Code |
billToAddressLine1 sensitive Bill To Address Line 1 |
billToAddressLine2 sensitive Bill To Address Line 2 |
billToCity Bill To City |
billToCountry Bill To Country |
billToState BillToState |
billToPostCode sensitive Bill To Post Code |
shipToAddressLine1 sensitive Ship To Address Line 1 |
shipToAddressLine2 sensitive Ship To Address Line 2 |
shipToCity Ship To City |
shipToCountry Ship To Country |
shipToState Ship To State |
shipToPostCode sensitive Ship To Post Code |
shortcutDimension1Code Shortcut Dimension 1 Code |
shortcutDimension2Code Shortcut Dimension 2 Code |
currencyId Currency ID |
currencyCode Currency Code |
paymentTermsId Payment Terms ID |
shipmentMethodId Shipment Method ID |
salesperson sensitive Salesperson |
partialShipping Partial Shipping |
requestedDeliveryDate Requested Delivery Date |
discountAmount Discount Amount |
discountAppliedBeforeTax Discount Applied Before Tax |
totalAmountExcludingTax Total Amount Excluding Tax |
totalTaxAmount Total Tax Amount |
totalAmountIncludingTax Total Amount Including Tax |
fullyShipped Fully Shipped |
status Status |
lastModifiedDateTime Last Modified DateTime |
phoneNumber sensitive Phone Number |
email sensitive |
id ID |
number Number |
externalDocumentNumber External Document Number |
documentDate Document Date |
postingDate Posting Date |
dueDate Due Date |
customerId Customer ID |
customerNumber Customer Number |
customerName sensitive Customer Name |
billToName sensitive Bill To Name |
billToCustomerId Bill To Customer ID |
billToCustomerNumber Bill To Customer Number |
shipToName sensitive Ship To Name |
shipToContact sensitive Ship To Contact |
sellToAddressLine1 sensitive Sell To Address Line 1 |
sellToAddressLine2 sensitive Sell To Address Line 2 |
sellToCity Sell To City |
sellToCountry Sell To Country |
sellToState Sell To State |
sellToPostCode sensitive Sell To Post Code |
billToAddressLine1 sensitive Bill To Address Line 1 |
billToAddressLine2 sensitive Bill To Address Line 2 |
billToCity Bill To City |
billToCountry Bill To Country |
billToState BillToState |
billToPostCode sensitive Bill To Post Code |
shipToAddressLine1 sensitive Ship To Address Line 1 |
shipToAddressLine2 sensitive Ship To Address Line 2 |
shipToCity Ship To City |
shipToCountry Ship To Country |
shipToState Ship To State |
shipToPostCode sensitive Ship To Post Code |
currencyId Currency ID |
currencyCode Currency Code |
paymentTermsId Payment Terms ID |
shipmentMethodId Shipment Method ID |
shipmentMethod Shipment Method |
salesperson sensitive Salesperson |
discountAmount Discount Amount |
totalAmountExcludingTax Total Amount Excluding Tax |
totalTaxAmount Total Tax Amount |
totalAmountIncludingTax Total Amount Including Tax |
status Status |
sentDate Sent Date |
validUntilDate Valid Until Date |
acceptedDate Accepted Date |
lastModifiedDateTime Last Modified DateTime |
phoneNumber sensitive Phone Number |
email sensitive |
id ID |
code Code |
displayName Display Name |
lastModifiedDateTime Last Modified Date Time |
id ID |
code Code |
displayName Display Name |
taxType taxType |
lastModifiedDateTime Last Modified Date Time |
Pricing
Compare Dataddo's flow-based pricing tiers side by side and start your 14-day free trial.
View pricing
Most teams use multiple tools and “spaghetti code” for ingestion, depending on the type of sources and loading patterns. Dataddo brings this under one control plane and one predictable pricing structure. 400+ connectors included.
Run Dataddo in both cloud and hybrid on-prem configurations. The control plane stays in the cloud; your data never leaves your perimeter. Supports segmented and private networks, and legacy systems including DB2, Informix, and Sybase.
Dataddo is built API-first. Use the UI when you want it; bypass it entirely when you don’t and orchestrate your pipelines programmatically.
Dataddo takes operational responsibility for your ingestion layer. We manage connector maintenance, handle API changes from source systems, monitor pipelines proactively, and execute backfills and recovery. Your engineering team doesn’t have to.
Dataddo gives you complete observability across your ingestion layer: pipeline logs, run histories, data lineage, and audit trails. Know what moved, when it moved, what changed, and why. Built for environments where explainability and accountability are not optional.
Enterprise AI depends on a governed, secure data layer. Dataddo consolidates SaaS, database, and file data into a unified managed pipeline, delivering to vector databases, feature stores, and data lakes, with native sensitive data hashing.
65,000+
social media accounts
unified across
all brands and markets
3
FTEs saved
on pipeline
maintenance
70%
less
engineering work,
more time analyzing data
Amalia Bornstein
Global Social Content and Marketing Data Analyst
Uber Eats
“The data team at Uber Eats appreciates Dataddo's user-friendly interface that is designed for operation by non-technical team members in an order to minimalize the need for excessive training to support efficient project delivery.”
Andrew Hart
Chief Operations Officer
Sat 7
“Working with Dataddo has greatly simplified our reporting and given us access to trend data and insights that we were previously unable to generate.”
Vahan Petrosayan
Director of IT & Infrastructure
Search Engine Journal
“With Dataddo, all of my questions get answered faster …[and it's] fun to play with data now.”
Michael Guntenaar
CTO
ID&T Group
“Dataddo opens up gates and takes away the hurdles of working with data.”
Laurent Partouche
CPO
FoodChéri & Seazon
“We chose Dataddo for its user-friendliness, automatic transformations, clear pricing policy, and the quality of the human relationship that was established from our first exchanges.”
Natheer Maloon
Technology Solutions Manager
Boldr
“Dataddo support proved immensely valuable throughout the implementation phase. 9.5 out of 10.”
Zdeněk Hejnak
Data Development Team Leader
Livesport
“We save about 70% of the time it would otherwise take to ingest all our data, or 3-4 full-time equivalents, and spend this much more time on data analytics and activation. We only have one full-time data engineer, who does more than just collect data, while our BI team consists of 11 members.”
Greg Senior
Business Operations Manager
Farm Focus
“Appreciate all the help and support for us. A refreshing level of service from a tech company! Thank you!”
