Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Microsoft Dynamics 365 Business Central Connector for Qlik Sense Cloud

dgoehler
Partner - Contributor III
Partner - Contributor III

Microsoft Dynamics 365 Business Central Connector for Qlik Sense Cloud

<It would be nice if there would be also a connector for Microsoft ERP System Dynamics 365 Business Central in Qlik Sense Cloud. This is API: https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v2.0/

For Dynamics 365 Business Central Cloud Azure Active Directory Authentication would be necessary. Basic Authentication is currently also possible but will be turned off in 2022 (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-...). For Dynamics 365 Business Central OnPrem Basic and Azure Active Directory Authentication are supported. Most Customers have only setup Basic Authentication.

48 Comments
dgoehler
Partner - Contributor III
Partner - Contributor III

@acarrera You can follow the step-by-step setup guide of Arend-Jan Kauffmann except section "Create the Azure Active Directory Account from code". You can then test your setup with Postman: https://www.kauffmann.nl/2021/07/27/service-to-service-authentication-in-business-central-18-3-how-t...

This step-by-step guide works, but if you still need help, I recommend contacting Microsoft support with the postman examples that don't work.

 

acarrera
Partner - Contributor II
Partner - Contributor II

Thank you @dgoehler for your insight and reply. Got the token from the POST call using Postman and Azure, but I'm still getting the same 401 error.

What did you (or any other users who've had success) put for the URL in the GET method after obtaining the token? Specifically referring to the <API resource> bit in the below URL as I assume the <environment name> is either Sandbox or Production:

https://api.businesscentral.dynamics.com/v2.0/<environment name>/api/v2.0/<API resource>

 

Thanks,

Alex

dgoehler
Partner - Contributor III
Partner - Contributor III

@acarrera You can see me setup at https://community.qlik.com/t5/Suggest-an-Idea/Microsoft-Dynamics-365-Business-Central-Connector-for-....

In your URL the tenant_id (Azure AD Tenent Id) is missing. Also you need to select a company first. You can query companies for that: https://api.businesscentral.dynamics.com/v2.0/{{tenant_id}}/{{environment}}/api/v2.0/companies

{
    "@odata.context": "https://api.businesscentral.dynamics.com/v2.0/00000000-0000-0000-0000-000000000000/Sandbox/api/v2.0/$metadata#companies",
    "value": [
        {
            "id": "cac850ca-11a8-eb11-bb60-000d3a257ac8",
            "systemVersion": "20.0.37253.38055",
            "name": "CRONUS DE",
            "displayName": "",
            "businessProfileId": "",
            "systemCreatedAt": "2021-04-28T11:06:36.457Z",
            "systemCreatedBy": "00000000-0000-0000-0000-000000000001",
            "systemModifiedAt": "2021-04-28T11:06:36.457Z",
            "systemModifiedBy": "00000000-0000-0000-0000-000000000001"
        }
    ]
}

If you want to get e.g. the items you need to fill tenant_idenvironment and company_id (id from companies)https://api.businesscentral.dynamics.com/v2.0/{{tenant_id}}/{{environment}}/api/v2.0/companies({{company_id}})/items

{
    "@odata.context": "https://api.businesscentral.dynamics.com/v2.0/00000000-0000-0000-0000-000000000000/Sandbox/api/v2.0/$metadata#companies(cac850ca-11a8-eb11-bb60-000d3a257ac8)/items",
    "value": [
        {
            "@odata.etag": "W/\"JzE5OzQ5MzI4MjA3OTM3NzU0MjE3NzExOzAwOyc=\"",
            "id": "363bda0c-12a8-eb11-bb60-000d3a257ac8",
            "number": "1896-S",
            "displayName": "ATHENS Schreibtisch",
            "type": "Inventory",
            "itemCategoryId": "e965d212-12a8-eb11-bb60-000d3a257ac8",
            "itemCategoryCode": "TISCH",
            "blocked": false,
            "gtin": "",
            "inventory": 4,
            "unitPrice": 1005.8,
            "priceIncludesTax": false,
            "unitCost": 784.6,
            "taxGroupId": "00000000-0000-0000-0000-000000000000",
            "taxGroupCode": "",
            "baseUnitOfMeasureId": "9a3bda0c-12a8-eb11-bb60-000d3a257ac8",
            "baseUnitOfMeasureCode": "STÜCK",
            "generalProductPostingGroupId": "5e3dda0c-12a8-eb11-bb60-000d3a257ac8",
            "generalProductPostingGroupCode": "HANDEL",
            "inventoryPostingGroupId": "8d3bda0c-12a8-eb11-bb60-000d3a257ac8",
            "inventoryPostingGroupCode": "WEITERVERK",
            "lastModifiedDateTime": "2021-11-09T21:49:24.59Z"
        }
		[..]
    ]
}

 

rva
Partner - Contributor III
Partner - Contributor III

Latest Update I have received from our Partner Manager:

 

Microsoft Dynamics 365 BC connector is still in the backlog, and it is more likely it will be pushed out to next year. The REST Connector can be used to access MS Dynamics BC, you can find some details in this article in the Community.

auditbee
Contributor
Contributor

Guys, can you help me.

I have no clue about API or oAut - do you have a description or Video how to connect Qlik Cloud with Microsoft BC (On-Premise or Cloud?)

traimd
Contributor
Contributor

It seems to me that this is an excellent idea regarding the synchronization of Qlik Sense Cloud with Microsoft Dynamics. Still, I can't say if this is possible because as soon as I created my business and started using Microsoft dynamics 365, I realized that I could not implement and synchronize this software with my business. Therefore, I hired a team of specialists who helped me do this and explained how everything worked. I know Microsoft dynamics 365 only a little, but this is enough to manage my entire business and do it with maximum impact.

P-O_Davidson
Employee
Employee
 
Status changed to: Closed - Archived
Meghann_MacDonald

Hi, this idea has been in "Not Planned" status for over a year and is still not in consideration. If you'd like to open a new request, please visit the Browse and Suggest page and click "Suggest features" and open a new request.

Meghann

Status changed to: Closed - Archived