Knowledge Base

Creating a Dynamics 365 Business Central Bulk Data Source

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com

Creating a Dynamics 365 Business Central Bulk Data Source

  • SmartConnect.com
  1. From the main Navigation Menu, select Data Sources > Bulk Sources > Query.

  1. On the Query Data Sources page, click the “Create Bulk Query” button.
  2. On the New Query Data Source page, Select “Dynamics 365 Business Central Odata Query”.
  3. Description – Friendly description for the Dynamics 365 Business Central query.
  4. Connection – Select an existing Connection to Dynamics 365 Business Central.
  5. Click Validate.
  6. Company – Select a Dynamics 365 Business Central Company.
  7. Click Add Service
  8. Select the Web Service to return data from.
  • Note: The services in this list will match the published page and query services that exist within the Dynamics 365 Business Central environment. Additional web services can be published as outlined in this Microsoft Article.
  1. Filter – Optionally, add Odata Filters to restrict the data being returned from Dynamics 365 Business Central.
  2. Click Update.

  1. Edit Query – Option is available after 2 or more services are added.
  • Add Tables – Drag and drop data sources into the query builder window.
  • Join Tables – Drag a field from one table to another to create a join.
  • Select Fields – Check the box next to the fields to include in the data source.
  • Filter Data – Apply filters in the grid at the bottom of the window
  • Next – Click Next to save the query and return to the data source.

  1. Preview – View first 5 rows of data returned from the query.
  2. Click Save.
Support

Email an Expert

Start a Ticket
Support

Chat with Us

Support

Submit a Ticket

Support

Call Us

Product
Connections
  • Microsoft Dynamics 365
Templates
Engage
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?

clear