- From the main Navigation Menu, select Data Sources > Bulk Sources > Query.
- On the Query Data Sources page, click the “Create Bulk Query” button.
- On the New Query Data Source page, Select “Dynamics 365 Business Central Odata Api”.
- Description – Friendly description for the Dynamics 365 Business Central Odata Api query.
- Connection – Select an existing Connection to Dynamics 365 Business Central.
- Company – Select a Dynamics 365 Business Central Company.
- Select an entity. The entities available are from the Business Central standard api.
- Filter Service – Optionally, add Odata Filters to restrict the data being returned from Dynamics 365 Business Central.
- In the Linked Entities section, click the Select Fields button on the entity that was added to choose which fields to make available in the source.
- Add Child Service – Allows automatic linking of related child data to the parent entity.
- Select a child service.
- Select Fields button on the child service to choose which fields to make available in the source.
- Click Validate.
- Preview – View first 5 rows of data returned from the query.
- Click Save.