Microsoft Dynamics Business Central’s OData feature offers exceptional flexibility for customizing data management. It allows developers to connect to web services, enabling integration with applications such as SmartConnect for seamless data uploads. To further explore these capabilities, please refer to the Business Central web service documentation and the terms and conditions, which specify also which pages/services can and cannot be published here.
If you’d rather watch a video explaining this, click here.
In this article, I will demonstrate:
- How to find the page number.
- How to publish the page within the web service.
- How to utilize it within SmartConnect.
- Example: Uploading Dimension Codes Master (Setup) Into BC Via SmartConnect
How to find the page number for a specific window
refer to the official Microsoft documentation on the Dimension Values page and note down <ID> that is used for the page.
Click on “Inspect pages and data”.
Navigate to the data page where you intend to upload the data >> Choose any one of the records.
For Example: here is an example of dimensions and values for one specific dimension, namely DEPARTMENT.
Navigate to the right-hand side and open the “Page Inspection” window. Here, you will find the page number where the data is stored.
How to publish the service (page) within the web service
Go To Search >> Web Services
Click on New and select Object Type as “Page.”
Enter Object ID: 537 and press Tab.
Assign a name, such as DimensionValues, ensuring the name is unique in the entire list and has no space in it
Click on Publish, mark the entry, and move the cursor out of the lines to confirm the OData V4 URL.
How to utilize service within SmartConnect
Click the Refresh button in the Services box
Click on the ellipsis (…) – dots and Locate the DisplayName corresponding to the name assigned to the page >> select it
It should appear as shown below: >> Select Mark >> Choose Ignore Update Conflicts.
For Example: Define a mapping
Click the Refresh button in the Services box
Click on the Select Service List and Locate the DisplayName corresponding to the name assigned to the page >> Select it
It should appear as shown below >> Select Mark >> Choose Ignore Update Conflicts.
For Example: Define a mapping
Have a question? Please reach out to us at support@eonesolutions.com
