Dynamics 365 Business Central
Connect to Microsoft Dynamics 365 Business Central ERP system.
Authentication
This connector uses OAuth 2.0 authentication.
info
Set up your connection in the Abstra Console before using it in your workflows.
How to use
Using the Smart Chat
Execute the action "CHOOSE_ONE_ACTION_BELOW" from my connector "YOUR_CONNECTOR_NAME" using the params "PARAMS_HERE".
Using the Web Editor
from abstra.connectors import run_connection_action
result = run_connection_action(
connection_name="your_connection_name",
action_name="your_action_name",
params={
"param1": "value1",
"param2": "value2"
})
Available Actions
This connector provides 90 actions:
| Action | Purpose | Parameters |
|---|---|---|
| get_companies | Returns a collection of Companies. | $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies | Create Company | data: { . id (string) . systemVersion (string) . name (string) . displayName (string) . businessProfileId (string) . systemCreatedAt (string) . systemCreatedBy (string) . systemModifiedAt (string) . systemModifiedBy (string) } (object) required |
| get_companies_by_id_ | Get Company by id | id (string) $select (string) $expand (string) |
| patch_companies_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) If-Match (string) required data: { . id (string) . systemVersion (string) . name (string) . displayName (string) . businessProfileId (string) . systemCreatedAt (string) . systemCreatedBy (string) . systemModifiedAt (string) . systemModifiedBy (string) } (object) required |
| delete_companies_by_id_ | Delete Company | id (string) If-Match (string) required |
| get_companies_by_company_id_customers | Returns a collection of Customers. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_customers | Create Customer | companyId (string) data: { . id (string) . number (string) . displayName (string) . type (string) . addressLine1 (string) . addressLine2 (string) . city (string) . state (string) . country (string) . postalCode (string) . phoneNumber (string) . email (string) . website (string) . taxLiable (boolean) . taxAreaId (string) . taxAreaDisplayName (string) . taxRegistrationNumber (string) . currencyId (string) . currencyCode (string) . paymentTermsId (string) . shipmentMethodId (string) . paymentMethodId (string) . blocked (string) . balance (number) . overdueAmount (number) . totalSalesExcludingTax (number) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_customers_by_id_ | Get Customer by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_customers_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . displayName (string) . type (string) . addressLine1 (string) . addressLine2 (string) . city (string) . state (string) . country (string) . postalCode (string) . phoneNumber (string) . email (string) . website (string) . taxLiable (boolean) . taxAreaId (string) . taxAreaDisplayName (string) . taxRegistrationNumber (string) . currencyId (string) . currencyCode (string) . paymentTermsId (string) . shipmentMethodId (string) . paymentMethodId (string) . blocked (string) . balance (number) . overdueAmount (number) . totalSalesExcludingTax (number) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_customers_by_id_ | Delete Customer | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_vendors | Returns a collection of Vendors. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_vendors | Create Vendor | companyId (string) data: { . id (string) . number (string) . displayName (string) . addressLine1 (string) . addressLine2 (string) . city (string) . state (string) . country (string) . postalCode (string) . phoneNumber (string) . email (string) . website (string) . taxRegistrationNumber (string) . currencyId (string) . currencyCode (string) . irs1099Code (string) . paymentTermsId (string) . paymentMethodId (string) . taxLiable (boolean) . blocked (string) . balance (number) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_vendors_by_id_ | Get Vendor by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_vendors_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . displayName (string) . addressLine1 (string) . addressLine2 (string) . city (string) . state (string) . country (string) . postalCode (string) . phoneNumber (string) . email (string) . website (string) . taxRegistrationNumber (string) . currencyId (string) . currencyCode (string) . irs1099Code (string) . paymentTermsId (string) . paymentMethodId (string) . taxLiable (boolean) . blocked (string) . balance (number) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_vendors_by_id_ | Delete Vendor | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_items | Returns a collection of Items. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_items | Create Item | companyId (string) data: { . id (string) . number (string) . displayName (string) . displayName2 (string) . type (string) . itemCategoryId (string) . itemCategoryCode (string) . blocked (boolean) . gtin (string) . inventory (number) . unitPrice (number) . priceIncludesTax (boolean) . unitCost (number) . taxGroupId (string) . taxGroupCode (string) . baseUnitOfMeasureId (string) . baseUnitOfMeasureCode (string) . generalProductPostingGroupId (string) . generalProductPostingGroupCode (string) . inventoryPostingGroupId (string) . inventoryPostingGroupCode (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_items_by_id_ | Get Item by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_items_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . displayName (string) . displayName2 (string) . type (string) . itemCategoryId (string) . itemCategoryCode (string) . blocked (boolean) . gtin (string) . inventory (number) . unitPrice (number) . priceIncludesTax (boolean) . unitCost (number) . taxGroupId (string) . taxGroupCode (string) . baseUnitOfMeasureId (string) . baseUnitOfMeasureCode (string) . generalProductPostingGroupId (string) . generalProductPostingGroupCode (string) . inventoryPostingGroupId (string) . inventoryPostingGroupCode (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_items_by_id_ | Delete Item | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_sales_orders | Returns a collection of Sales Orders. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_sales_orders | Create Sales Order | companyId (string) data: { . id (string) . number (string) . externalDocumentNumber (string) . orderDate (string) . customerId (string) . customerNumber (string) . customerName (string) . billToName (string) . billToCustomerId (string) . billToCustomerNumber (string) . shipToName (string) . shipToContact (string) . sellingPostalAddress . billingPostalAddress . shippingPostalAddress . currencyId (string) . currencyCode (string) . pricesIncludeTax (boolean) . paymentTermsId (string) . salesperson (string) . partialShipping (boolean) . requestedDeliveryDate (string) . discountAmount (number) . discountAppliedBeforeTax (boolean) . totalAmountExcludingTax (number) . totalTaxAmount (number) . totalAmountIncludingTax (number) . fullyShipped (boolean) . status (string) . lastModifiedDateTime (string) . phoneNumber (string) . email (string) } (object) required |
| get_companies_by_company_id_sales_orders_by_id_ | Get Sales Order by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_sales_orders_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . externalDocumentNumber (string) . orderDate (string) . customerId (string) . customerNumber (string) . customerName (string) . billToName (string) . billToCustomerId (string) . billToCustomerNumber (string) . shipToName (string) . shipToContact (string) . sellingPostalAddress . billingPostalAddress . shippingPostalAddress . currencyId (string) . currencyCode (string) . pricesIncludeTax (boolean) . paymentTermsId (string) . salesperson (string) . partialShipping (boolean) . requestedDeliveryDate (string) . discountAmount (number) . discountAppliedBeforeTax (boolean) . totalAmountExcludingTax (number) . totalTaxAmount (number) . totalAmountIncludingTax (number) . fullyShipped (boolean) . status (string) . lastModifiedDateTime (string) . phoneNumber (string) . email (string) } (object) required |
| delete_companies_by_company_id_sales_orders_by_id_ | Delete Sales Order | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_sales_invoices | Returns a collection of Sales Invoices. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_sales_invoices | Create Sales Invoice | companyId (string) data: { . id (string) . number (string) . externalDocumentNumber (string) . invoiceDate (string) . postingDate (string) . dueDate (string) . customerId (string) . customerNumber (string) . customerName (string) . currencyCode (string) . totalAmountExcludingTax (number) . totalTaxAmount (number) . totalAmountIncludingTax (number) . status (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_sales_invoices_by_id_ | Get Sales Invoice by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_sales_invoices_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . externalDocumentNumber (string) . invoiceDate (string) . postingDate (string) . dueDate (string) . customerId (string) . customerNumber (string) . customerName (string) . currencyCode (string) . totalAmountExcludingTax (number) . totalTaxAmount (number) . totalAmountIncludingTax (number) . status (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_sales_invoices_by_id_ | Delete Sales Invoice | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_sales_quotes | Returns a collection of Sales Quotes. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_sales_quotes | Create Sales Quote | companyId (string) data: { . id (string) . number (string) . documentDate (string) . customerId (string) . customerNumber (string) . customerName (string) . totalAmountIncludingTax (number) . status (string) . validUntilDate (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_sales_quotes_by_id_ | Get Sales Quote by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_sales_quotes_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . documentDate (string) . customerId (string) . customerNumber (string) . customerName (string) . totalAmountIncludingTax (number) . status (string) . validUntilDate (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_sales_quotes_by_id_ | Delete Sales Quote | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_purchase_orders | Returns a collection of Purchase Orders. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_purchase_orders | Create Purchase Order | companyId (string) data: { . id (string) . number (string) . orderDate (string) . vendorId (string) . vendorNumber (string) . vendorName (string) . currencyCode (string) . totalAmountIncludingTax (number) . status (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_purchase_orders_by_id_ | Get Purchase Order by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_purchase_orders_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . orderDate (string) . vendorId (string) . vendorNumber (string) . vendorName (string) . currencyCode (string) . totalAmountIncludingTax (number) . status (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_purchase_orders_by_id_ | Delete Purchase Order | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_purchase_invoices | Returns a collection of Purchase Invoices. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_purchase_invoices | Create Purchase Invoice | companyId (string) data: { . id (string) . number (string) . invoiceDate (string) . postingDate (string) . dueDate (string) . vendorId (string) . vendorNumber (string) . vendorName (string) . totalAmountIncludingTax (number) . status (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_purchase_invoices_by_id_ | Get Purchase Invoice by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_purchase_invoices_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . invoiceDate (string) . postingDate (string) . dueDate (string) . vendorId (string) . vendorNumber (string) . vendorName (string) . totalAmountIncludingTax (number) . status (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_purchase_invoices_by_id_ | Delete Purchase Invoice | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_accounts | Returns a collection of Accounts. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_accounts | Create Account | companyId (string) data: { . id (string) . number (string) . displayName (string) . category (string) . subCategory (string) . blocked (boolean) . accountType (string) . directPosting (boolean) . netChange (number) . consolidationTranslationMethod (string) . consolidationDebitAccount (string) . consolidationCreditAccount (string) . excludeFromConsolidation (boolean) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_accounts_by_id_ | Get Account by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_accounts_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . displayName (string) . category (string) . subCategory (string) . blocked (boolean) . accountType (string) . directPosting (boolean) . netChange (number) . consolidationTranslationMethod (string) . consolidationDebitAccount (string) . consolidationCreditAccount (string) . excludeFromConsolidation (boolean) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_accounts_by_id_ | Delete Account | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_journals | Returns a collection of Journals. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_journals | Create Journal | companyId (string) data: { . id (string) . code (string) . displayName (string) . templateDisplayName (string) . balancingAccountId (string) . balancingAccountNumber (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_journals_by_id_ | Get Journal by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_journals_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . code (string) . displayName (string) . templateDisplayName (string) . balancingAccountId (string) . balancingAccountNumber (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_journals_by_id_ | Delete Journal | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_payment_terms | Returns a collection of Payment Terms. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_payment_terms | Create Payment Term | companyId (string) data: { . id (string) . code (string) . displayName (string) . dueDateCalculation (string) . discountDateCalculation (string) . discountPercent (number) . calculateDiscountOnCreditMemos (boolean) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_payment_terms_by_id_ | Get Payment Term by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_payment_terms_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . code (string) . displayName (string) . dueDateCalculation (string) . discountDateCalculation (string) . discountPercent (number) . calculateDiscountOnCreditMemos (boolean) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_payment_terms_by_id_ | Delete Payment Term | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_currencies | Returns a collection of Currencies. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_currencies | Create Currency | companyId (string) data: { . id (string) . code (string) . displayName (string) . symbol (string) . amountDecimalPlaces (string) . amountRoundingPrecision (number) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_currencies_by_id_ | Get Currency by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_currencies_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . code (string) . displayName (string) . symbol (string) . amountDecimalPlaces (string) . amountRoundingPrecision (number) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_currencies_by_id_ | Delete Currency | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_tax_groups | Returns a collection of Tax Groups. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_tax_groups | Create Tax Group | companyId (string) data: { . id (string) . code (string) . displayName (string) . taxType (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_tax_groups_by_id_ | Get Tax Group by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_tax_groups_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . code (string) . displayName (string) . taxType (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_tax_groups_by_id_ | Delete Tax Group | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_item_categories | Returns a collection of Item Categories. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_item_categories | Create Item Category | companyId (string) data: { . id (string) . code (string) . displayName (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_item_categories_by_id_ | Get Item Category by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_item_categories_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . code (string) . displayName (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_item_categories_by_id_ | Delete Item Category | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_units_of_measure | Returns a collection of Units of Measure. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_units_of_measure | Create Unit of Measure | companyId (string) data: { . id (string) . code (string) . displayName (string) . internationalStandardCode (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_units_of_measure_by_id_ | Get Unit of Measure by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_units_of_measure_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . code (string) . displayName (string) . internationalStandardCode (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_units_of_measure_by_id_ | Delete Unit of Measure | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_employees | Returns a collection of Employees. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_employees | Create Employee | companyId (string) data: { . id (string) . number (string) . displayName (string) . givenName (string) . middleName (string) . surname (string) . jobTitle (string) . addressLine1 (string) . city (string) . country (string) . postalCode (string) . phoneNumber (string) . mobilePhone (string) . email (string) . personalEmail (string) . birthDate (string) . employmentDate (string) . terminationDate (string) . status (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_employees_by_id_ | Get Employee by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_employees_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . displayName (string) . givenName (string) . middleName (string) . surname (string) . jobTitle (string) . addressLine1 (string) . city (string) . country (string) . postalCode (string) . phoneNumber (string) . mobilePhone (string) . email (string) . personalEmail (string) . birthDate (string) . employmentDate (string) . terminationDate (string) . status (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_employees_by_id_ | Delete Employee | id (string) companyId (string) If-Match (string) required |
| get_companies_by_company_id_projects | Returns a collection of Projects. | companyId (string) $filter (string) $select (string) $expand (string) $orderby (string) $top (integer) $skip (integer) $count (boolean) |
| post_companies_by_company_id_projects | Create Project | companyId (string) data: { . id (string) . number (string) . displayName (string) . customerId (string) . customerNumber (string) . customerName (string) . status (string) . lastModifiedDateTime (string) } (object) required |
| get_companies_by_company_id_projects_by_id_ | Get Project by id | id (string) companyId (string) $select (string) $expand (string) |
| patch_companies_by_company_id_projects_by_id_ | Partial update. Requires If-Match header with the ETag. | id (string) companyId (string) If-Match (string) required data: { . id (string) . number (string) . displayName (string) . customerId (string) . customerNumber (string) . customerName (string) . status (string) . lastModifiedDateTime (string) } (object) required |
| delete_companies_by_company_id_projects_by_id_ | Delete Project | id (string) companyId (string) If-Match (string) required |