Contact our support team to enable the data source connection which will allow you import data from Microsoft Dynamics Business Central. You'll need your OAuth credentials to complete the configuration. 


Get Your OAuth Credentials


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.

19191919

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

businesscentral.dynamics.com/ENVIRONMENT-NAME

19191919

Next, you should click the Settings icon in the top right hand corner of the page.

19191919

From the resulting dropdown, select the Advanced settings option.

19191919

From the pop-up window, click on the Manual Setup option.

1919

Then this page will appear. Make sure you head to the User permissions section and click on it.

19191919

You will now be on the Users page. Click on the User you want to have connected. 

19191919

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. You'll need this to import your data to Gigasheet. Please contact our support team, and have this information handy to complete the configuration.