Suggest an Idea

[dgoehler]

<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.

[dgoehler]

@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]

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]

@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_id, environment 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]

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]

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]

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.

[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