Dynamics Community Forum Thread Details

Connection Qlik sense to Dynamics 365

Dear,

I have tried to set up the connection from Qlik sense to Dynamics 365. I have read that we need to use the REST connector in Qlik Sense. I have created a connection in Postman to get the token that is used for the REST connector. So far this worked. Now I have to set the connection string to Business central but that I don't know how to do.

The connection string would look something like this:

LET vRequestAccessToken = 'Provider=QvRestConnector.exe;url=https://api.businesscentral.dynamics.com/v1.0/api/v1.0;timeout=30;method=POST;requestBody=grant_type%2refresh_token&client_id%2$(vClient_id)&client_secret%2$(vClient_secret)&refresh_token%2$(vRefresh_token);autoDetectResponseType=true;keyGenerationStrategy=0;useWindowsAuthentication=false;useCertificate=No;certificateStoreLocation=CurrentUser;certificateStoreName=My;queryHeaders=Content-Type%2application/x-www-form-urlencoded;PaginationType=None;XUserId=ZaFAFAD;XPassword=RCVAXKA;';

Can you help me to build up the connection string how this should look like?

Kind regards,

Robbe Coolsaet

Quick Links