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.
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. Click on the User you want to have connected.
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.