Skip to content


Configure an OData Api query Data source

Modern OData APIs provide flexible filter and navigational properties allow external applications to create complex filters and join tables of related data easily. Performance and flexibility are the main reasons we recommend using the OData APIs. Below is an example for configuring an OData Api data source for Business Central, but the same steps will apply to any OData Api data source in SmartConnect.

Configuring a Business Central OData Api query Data source

  1. Go to SmartConnect > Data Sources > Bulk Sources > Query
  2. Click on Create Bulk Query > Select Dynamics 365 Business Central OData Api

3. Give the source a Description and select your Connection and Company.
4. Select Entity, for example, Sales Orders.
5. Now, click on the Select Fields for Sales orders button.

6. Select the required fields and click ok. For example, Name, City.

7. Clicking on Validate will show Validate Dynamics 365 Business Central OData Api was successful. Also, Save and Preview Button are enabled.

Adding Child Entity

Optionally, you can add a child entity to join the main service to a related service. For example, show sales lines associated with this order, or show additional customer information on the linked customer card.

  1. Add child services to the salesOrders entity by clicking on Plus Button (+) to select child service for Sales Orders, for example, SalesOrderLines.

2. Select the desired fields and click ok. For example, Item Id, description.

Filter a Service

1. Click on the Filter service button

2. Then from the Fields, drag and drop the field needed to filter. For example, Sell to City.
3. Select the Logical operator from the list and drag and drop. For example, the eq operator has a set value to ‘Gillette’.

4. Alternatively, select the Global variable for the set value for the filter.
5. Save and Preview are enabled.

Error Handling

When creating a query data source, you may see the following error.

Validation failure, Field selection is required for service ‘SalesOrders’ 


Select the required fields for the entity or child entity and click ok.


Another Problem after adding the filter service, you may see this error Failed to create data table: Could not find a property name ‘city’ on the type.


Go to the filter and add ‘’ around the set value.


Configuring Salesforce Integration User
Business Central Extension Publish Error
Re-registering a Change Data Source in Business Central on
Moving SmartConnect 21 to a new server
eConnect error 4628 - The Tracking Number (Tracking_Number) is empty


SSL Security error using OLEDB Connection
This implementation is not part of the Windows Platform FIPS validated cryptographic algorithms
Removed Part: /xl/vbaProject.bin part. (Visual Basic for Applications (VBA))
The server process could not be started because the configured identity is incorrect.
Using WINSCP and a task to upload or download files from an SFTP site



Business Central CRM D365 Business Central Dynamics 365 dynamics crm Dynamics GP Dynamics NAV Econnect Employee Spotlight eone eOne News error Error Message Events Excel Excel Report Builder Extender Flexicoder GP integration Map Microsoft dynamics crm Microsoft Dynamics GP Navigation List Builder Office Relationships Partner All Hands Call Popdock promotions release Salesforce SmartConnect SmartConnect Bootcamp SmartConnect Maps SmartConnect Office Hours SmartList SmartList Builder SmartPost SmartView SQL Tech Tuesday Templates training Zendesk

Integrate & Automate without Any Code.

SmartList Data has Never Been Faster.

The Easiest Way to Report on GP Data.