Overview
This node allows interaction with Microsoft Dynamics 365 Business Central via its Web Services API. Specifically, it supports querying data from Business Central by calling OData V4 endpoints for a specified service path. This is useful when you want to retrieve business data such as customers, orders, or other entities exposed through Business Central's web services.
Common scenarios include:
- Fetching customer or sales data for reporting or integration.
- Accessing custom Business Central services exposed via OData.
- Automating workflows that require up-to-date information from Business Central.
For example, you can specify a service name like workflowCustomers to retrieve customer records and use the output in subsequent workflow steps.
Properties
| Name | Meaning |
|---|---|
| Service Name | The service path used in the API URL to query Business Central data (e.g., workflowCustomers). This corresponds to the OData endpoint segment representing the desired entity or service. |
Output
The node outputs an array of items where each item contains a json property holding one record retrieved from the Business Central web service. The structure of each JSON object matches the fields returned by the queried OData service.
If the service returns multiple records, each record is output as a separate item in the array.
No binary data output is produced by this node.
Dependencies
- Requires an API authentication credential for Microsoft Dynamics 365 Business Central.
- The credential must provide tenant ID, environment name, and company ID to construct the API URL.
- The node uses the Business Central OData V4 API endpoint:
https://api.businesscentral.dynamics.com/v2.0/{tenantId}/{environmentName}/ODataV4/Company('{companyId}')/{serviceName}
Troubleshooting
Common issues:
- Incorrect or missing credential details (tenant ID, environment, company ID) will cause authentication or URL errors.
- Specifying an invalid or non-existent service name will result in API errors or empty results.
- Network connectivity problems may prevent successful API calls.
Error messages:
- If the API request fails, the node logs the error message and throws a detailed error indicating all endpoint attempts failed.
- HTTP status codes from the API response are included in the error description to help diagnose issues.
Resolution tips:
- Verify that the API credentials are correctly configured and have sufficient permissions.
- Confirm the service name matches an available OData service in your Business Central instance.
- Check network access and firewall settings to ensure connectivity to the Business Central API.