Sales endpoints
Customers, open and posted sales documents, archives, customer ledger entries, prices, and the CRM side of Business Central: contacts, campaigns, opportunities and interactions.
All URLs on this page are relative to the company URL, https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environment}/api/datawareness/endpoints/v1.0/companies({companyId})/. See Construction of the URL.
Master data
| Endpoint | Description | Business key | Source table | Tier |
|---|---|---|---|---|
campaigns | Marketing campaigns. | no | Campaign | Premium |
closeOpportunityCodes | Reason codes for closing opportunities. | code | Close Opportunity Code | Premium |
contactBusinessRelations | Contact to business relations mapping. | contactNo&&businessRelationCode | Contact Business Relation | Premium |
contacts | Contact master data. | no | Contact | Premium |
customerDimensions | Default dimensions assigned to customers. | customerNo&&dimensionCode | Default Dimension | Premium |
customerPostingGroups | Customer posting group definitions. | code | Customer Posting Group | Premium |
customerPriceGroups | Customer price group definitions. | code | Customer Price Group | Premium |
customers | Customer master data. | no | Customer | Free |
interactionGroups | Interaction group definitions. | code | Interaction Group | Premium |
interactionTemplates | Interaction template definitions. | code | Interaction Template | Premium |
priceListHeaders | Price list headers (BC 16+ price calculation). | code | Price List Header | Premium |
priceListLines | Price list lines: sales/purchase prices and discounts per item, resource, resource group or G/L account. | priceListCode&&lineNo | Price List Line | Premium |
profileQuestionnaireLines | Profile questionnaire lines (questions used for contact classification). | profileQuestionnaireCode&&lineNo | Profile Questionnaire Line | Premium |
salesCycles | Sales process (cycle) definitions. | code | Sales Cycle | Premium |
salesCycleStages | Stages within a sales cycle. | salesCycleCode&&stage | Sales Cycle Stage | Premium |
salespersonsPurchasers | Salesperson/purchaser master data. | code | Salesperson/Purchaser | Premium |
shipmentMethods | Shipment method definitions. | code | Shipment Method | Premium |
Transactional data
| Endpoint | Description | Business key | Source table | Tier |
|---|---|---|---|---|
contactProfileAnswers | Profile questionnaire answers selected per contact. | contactNo&&profileQuestionnaireCode&&lineNo | Contact Profile Answer | Premium |
customerLedgerEntries | Customer ledger entries. | entryNo | Cust. Ledger Entry | Premium |
interactionLogEntries | Interaction log entries (CRM activity history). | entryNo | Interaction Log Entry | Premium |
opportunities | Sales opportunities (leads). | no | Opportunity | Premium |
opportunityEntries | Stage history for sales opportunities. | entryNo | Opportunity Entry | Premium |
salesCommentLineArchives | Archived comments on sales documents. | documentType&&no&&docNoOccurrence&&versionNo&&documentLineNo&&lineNo | Sales Comment Line Archive | Premium |
salesCommentLines | Comments on sales documents. | documentType&&no&&documentLineNo&&lineNo | Sales Comment Line | Premium |
salesCreditMemoHeaders | Posted sales credit memo headers. | no | Sales Cr.Memo Header | Premium |
salesCreditMemoLines | Posted sales credit memo lines. | documentNo&&lineNo | Sales Cr.Memo Line | Premium |
salesHeaderArchives | Archived sales headers. | documentType&&no&&docNoOccurrence&&versionNo | Sales Header Archive | Premium |
salesHeaders | Sales headers (quotes, orders, invoices, credit memos, etc.). | documentType&&no | Sales Header | Premium |
salesInvoiceHeaders | Posted sales invoice headers. | no | Sales Invoice Header | Premium |
salesInvoiceLines | Posted sales invoice lines. | documentNo&&lineNo | Sales Invoice Line | Premium |
salesInvoices | Denormalized posted sales invoices combining header and line data. | documentNo&&lineNo | Sales Invoice Line | Free |
salesLineArchives | Archived sales lines. | documentType&&documentNo&&docNoOccurrence&&versionNo&&lineNo | Sales Line Archive | Premium |
salesLines | Sales lines. | documentType&&documentNo&&lineNo | Sales Line | Premium |
Example queries
Posted sales invoices for a quarter
GET .../salesInvoiceHeaders?$filter=postingDate ge 2026-01-01 and postingDate le 2026-03-31
&$select=no,sellToCustomerNo,postingDate,currencyCode,amount,amountIncludingVAT
Customers in one country
GET .../customers?$filter=countryRegionCode eq 'DK'
&$select=no,name,city,salespersonCode,balanceLCY
Open receivables
GET .../customerLedgerEntries?$filter=open eq true
&$select=entryNo,customerNo,documentNo,postingDate,dueDate,remainingAmtLCY
Opportunities created this year
GET .../opportunities?$filter=creationDate ge 2026-01-01
&$select=no,description,contactNo,salespersonCode,salesCycleCode,status
Tips
- Free tier:
customersandsalesInvoicesare available without a Premium subscription.salesInvoicescombines posted invoice header and line data in one row per line, ready for a simple sales report. - Headers and lines: join
salesInvoiceLines.documentNotosalesInvoiceHeaders.no, andsalesLinestosalesHeadersondocumentTypeanddocumentNo. - Fields: every endpoint's fields, with types, are listed by
properties— see Metadata discovery. The same list is on the endpoint's page under BI Endpoints in Business Central.