If you need to figure out how to access the necessary credentials, head here for a detailed walk through.
First, you must decide which flow you would like to add your Microsoft Dynamics Business Central source to.
Once you have decided on a flow, let's start by enabling the Microsoft Dynamics Business Central connector.
This is where you put in your credentials for your Microsoft Dynamics Business Central integration. If you do not know where to find those credentials, you can head here for a detailed walk through.
Once you have input your specific Microsoft Dynamics Business Central credentials go ahead and click Save.
And that's it! You have successfully linked to Microsoft Dynamics Business Central.
You now have added Microsoft Dynamics Business Central as a data source for your flow.
Next, you need to configure the mapping for your Microsoft Dynamics Business Central data. Click on the Microsoft Dynamics Business Central card to get started.
Now you can need to open the Field Map Editor. Do so by clicking the corresponding icon.
You can now select specific streams and/or tables that you want to pull from each Dynamics Business Central account. To edit the exact objects you want to pull, use the corresponding gear icon.
For any of the fields you do want to pull, go ahead and select them now. I am going to use the the select all option at the top of the column.
Once you are done mapping any of the fields you want, use the arrow button in the middle to move those objects over to the Chosen column.
Once you have finished picking which fields you want to pull, click the Confirm button in the bottom right corner.
You should repeat the previous process until you have selected all the fields you want to bring in. Once you are done with all your selections, click the Save button.
The first thing that you need to do to get your Microsoft Dynamics Business Central credentials is to login to your Microsoft Dynamics Business Central dashboard. If you do not have a Microsoft Dynamics Business Central account, you can create learn how to create one here.
Once in your Microsoft Dynamics Business Central dashboard. The first thing you will need is to grab your Environment ID for Microsoft Dynamics. You can do that by looking the URL of the page and grabbing the highlighted section above. The URL is constructed as
Next, you should click the Settings icon in the top right hand corner of the page.
From the resulting dropdown, select the Advanced settings option.
From the pop-up window, click on the Manual Setup option.
Then this page will appear. Make sure you head to the User permissions section and click on it.
You will now be on the Users page. Go ahead and click on the User you want to have hotglue connect to. For example, I will go ahead and connect the DAVID user so I will click on the DAVID User Name.
You now have your API Username as the first entry in the General section (in this case it would be DAVID). Now to get the Access Key, triple click on the access key to copy it. Paste this into hotglue and you are all set!
Updated 9 months ago