Back to integrations
Databricks and Microsoft Dynamics 365 Business Central API integration
Save yourself the work of writing custom integrations for Databricks and Microsoft Dynamics 365 Business Central API and use n8n instead. Build adaptable and scalable Data & Storage, workflows that work with your technology stack. All within a building experience you will love.
How to connect Databricks and Microsoft Dynamics 365 Business Central API
Create a new workflow and add the first step
In n8n, click the "Add workflow" button in the Workflows tab to create a new workflow. Add the starting point – a trigger on when your workflow should run: an app event, a schedule, a webhook call, another workflow, an AI chat, or a manual trigger. Sometimes, the HTTP Request node might already serve as your starting point.
Build your own Databricks and Microsoft Dynamics 365 Business Central API integration
Create custom Databricks and Microsoft Dynamics 365 Business Central API workflows by choosing triggers and actions. Nodes come with global operations and settings, as well as app-specific parameters that can be configured. You can also use the HTTP Request node to query data from any app or service with a REST API.
Databricks supported actions
Execute Query
Execute a SQL query and wait for results
Create Directory
Create a directory in volume
Delete Directory
Delete a directory in volume
Delete File
Delete a file from a volume
Download File
Download file content from a volume
Get File Metadata
Get file metadata from a volume
List Directory
List directory contents in volume
Upload File
Upload a file (up to 5 GiB) to Databricks volumes
Create Conversation Message
Create a new conversation message
Execute Message SQL Query
Execute a SQL query from a message attachment
Get Conversation Message
Get a conversation message by ID
Get Genie Space
Get details of a Genie space
Get Query Results
Get results of a SQL query execution
Start Conversation
Start a new conversation
Query Endpoint
Query a serving endpoint. The input format is automatically detected from the endpoint schema.
Create Catalog
Create a new catalog
Create Function
Create a new function
Create Table
Register a new table
Create Volume
Create a new volume
Delete Catalog
Delete a catalog
Delete Function
Delete a function
Delete Table
Delete a table
Delete Volume
Delete a volume
Get Catalog
Get catalog information
Get Function
Get function information
Get Table
Get table information
Get Volume
Get volume information
List Catalogs
List all catalogs
List Functions
List functions in schema
List Tables
List tables in schema
List Volumes
List volumes in schema
Update Catalog
Update catalog information
Create Index
Create a new vector search index
Get Index
Get details of a vector search index
List Indexes
List all vector search indexes
Query Index
Query a vector search index with text or vectors
Supported API Endpoints for Microsoft Dynamics 365 Business Central API
DELETE
Delete customer
Deletes a customer from Dynamics 365 Business Central.
/v2.0/api/dynamics_customer_delete
DELETE
Delete customer
Delete a customer object from Business Central.
/api/v2.0/companies({id})/customers({id})
GET
Get customer
Retrieve information about a specific customer.
/api/v2.0/customers/{id}
POST
Create customer
Create a new customer record.
/api/v2.0/customers
GET
Get customer
Retrieve the properties and relationships of a customer object for Business Central.
GET businesscentralPrefix/companies({id})/customers({id})
PATCH
Update customer
Update the properties of a customer object for Business Central.
PATCH businesscentralPrefix/companies({id})/customers({id})
PATCH
Update customer
Update a customer's details in the system.
/api/v2.0/companies({id})/customers({id})
POST
Create customer
Create a customer object in Business Central.
businesscentralPrefix/companies({id})/customers
GET
Get customer
Retrieve a specific customer record.
/v2.0/api/dynamics_customer_get
POST
Create customer
Create a new customer record.
/v2.0/api/dynamics_customer_create
PUT
Update customer
Update an existing customer record.
/v2.0/api/dynamics_customer_update
GET
Get customer
Retrieve details of a customer.
/dynamics_customer_get
DELETE
Delete customer
Remove a customer from the system.
/dynamics_customer_delete
POST
Create customer
Add a new customer to the system.
/dynamics_customer_create
PUT
Update customer
Modify an existing customer's information.
/dynamics_customer_update
DELETE
Delete customer
Deletes a specific customer.
dynamics_customer_delete
POST
Create customer
Creates a new customer.
dynamics_customer_create
PUT
Update customer
Updates an existing customer.
dynamics_customer_update
GET
Get customer
Retrieve customer details by ID.
/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_customer_get
DELETE
Delete customer
Remove a customer from the database by ID.
/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_customer_delete
POST
Create customer
Add a new customer to the database.
/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_customer_create
PUT
Update customer
Modify existing customer information.
/en-us/dynamics365/business-central/dev-itpro/api-reference/v2.0/api/dynamics_customer_update
PATCH
Update customer
Updates information for an existing customer.
/v2.0/api/dynamics_customer_update
To set up Microsoft Dynamics 365 Business Central API integration, add the HTTP Request node to your workflow canvas and authenticate it using a generic authentication method. The HTTP Request node makes custom API calls to Microsoft Dynamics 365 Business Central API to query the data you need using the API endpoint URLs you provide.
See the example hereThese API endpoints were generated using n8n
n8n AI workflow transforms web scraping into an intelligent, AI-powered knowledge extraction system that uses vector embeddings to semantically analyze, chunk, store, and retrieve the most relevant API documentation from web pages. Remember to check the Microsoft Dynamics 365 Business Central API official documentation to get a full list of all API endpoints and verify the scraped ones!
Databricks and Microsoft Dynamics 365 Business Central API integration details
Databricks
Related categories
FAQs
FAQ
Can Databricks connect with Microsoft Dynamics 365 Business Central API?
Can I use Databricks’s API with n8n?
Can I use Microsoft Dynamics 365 Business Central API’s API with n8n?
Is n8n secure for integrating Databricks and Microsoft Dynamics 365 Business Central API?
How to get started with Databricks and Microsoft Dynamics 365 Business Central API integration in n8n.io?
The world's most popular workflow automation platform for technical teams including
Why use n8n to integrate Databricks with Microsoft Dynamics 365 Business Central API
Build complex workflows, really fast
