idea Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud in Suggest an Idea

Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

dgoehler — Wed, 20 Jan 2021 15:17:44 GMT

Microsoft is removing Web Service Access Keys (Basic Auth) for SaaS with Business Central 2022 release wave 1 (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/upgrade/deprecated-features-w1#web-service-access-keys-basic-auth-for-saas). From April 2022 the Rest Connector doesn't work with Business Central SaaS API (https://docs.microsoft.com/en-us/dynamics-nav/api-reference/v2.0/). OAuth-Support for the Rest Web Service like with your "Microsoft Dynamics CRM V2 Connector" is necessary to access the Business Central API (https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-develop-connect-apps).

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Thu, 11 Mar 2021 17:35:39 GMT

+1 required functionality, as per my note on this idea:

https://community.qlik.com/t5/Suggest-an-Idea/Microsoft-Dynamics-365-Business-Central-Connector-for-Qlik-Sense/idc-p/1790644#M5467

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Sat, 27 Mar 2021 18:01:51 GMT

Commenting on this for visibility.

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Thu, 15 Apr 2021 17:59:25 GMT

Any update on this one Qlik?

Not having Oauth authentication on the REST connector nor having a Business Central connector will make it difficult to use Qlik with BC after wave 2022.

I'm looking at alternative solutions (CData Sync + Azure SQL DB) to handle this requirement, which I don't want to when using Qlik Sense SaaS

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Tue, 27 Apr 2021 17:22:54 GMT

Any update to this or the linked (and similar) idea.

Perhaps @Michael_Tarallo could help out?

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Alastair_Ometis — Tue, 15 Jun 2021 10:19:05 GMT

this is what ive been looking for. absolutely must have this in my opinion.

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Sun, 27 Jun 2021 19:44:04 GMT

Microsoft have released a new BC Connector for Power BI which also has the new common API endpoints, as well as the 'legacy' Odata feeds. Wondering if anyone from Qlik will acknowledge this idea? @Jamie_Gregory

See here > https://powerbi.microsoft.com/en-us/blog/power-bi-june-2021-feature-summary/#post-16112-_Toc74044971

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Tue, 10 Aug 2021 15:57:09 GMT

As the idea to have a Business Central connector has been marked as "Not Planned", (see here > Microsoft Dynamics 365 Business Central Connector ... - Page 2 - Qlik Community - 1775186), which is very disappointing, will this idea be looked at?

Can you comment on this please @P-O_Davidson ?

We already can connect to Business Central via REST, but as Microsoft are depreciating the web service key access method, we need OAuth support on either the REST or ODATA connection.

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Tue, 21 Sep 2021 17:23:12 GMT

Can someone at Qlik please look into this idea?

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Alastair_Ometis — Wed, 22 Sep 2021 07:26:46 GMT

Likewise we have a heavy need for this and we are running out of lead time to get the leg work done.

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Jamie_Gregory — Wed, 22 Sep 2021 16:25:40 GMT

@P-O_Davidson @Meghann_MacDonald Can someone look into this?

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud - Status changed to: Open - Not Planned

P-O_Davidson — Fri, 15 Oct 2021 18:28:58 GMT

Hello,

I understand this could be of value, but since each source has individual specifics related to OAuth authentication it would require significant work to generically implement this. We currently don’t have any plan to address this on the roadmap. We will continue to re-evaluate our priorities to see if and when this can fit in.

Note that authentication via OAuth is possible in the REST connector for some sources, using name-value pairs in the available Query parameters and Query headers. See examples here.

Thanks,
P-O Davidson

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

to759_PM — Tue, 23 Nov 2021 14:35:01 GMT

@P-O_Davidson Thanks to point this out, but how about an example in Qlik docu for the specific problem @dgoehler had pointed out with Business Central?

I think this will help many customers / partners Microsoft 365 faced!

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

BoberGad — Sun, 30 Jan 2022 14:10:27 GMT

Hey All,

Trying to use REST API with Qlik sense web, I can't get the JSON response, using postman will bring the JSON.

Is it because of the OAuth limitation?

Many Thanks,

Gadi

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Thu, 10 Mar 2022 09:49:32 GMT

Hi, Qlik have known about this pending change for over a year, and there are various posts on community and ideation, yet, we are no further forward. What is the plan here?

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Tue, 03 May 2022 09:10:14 GMT

Hi, any update to this? v20 is now in production and causing problems with Qlik integration.

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

P-O_Davidson — Wed, 11 May 2022 15:05:14 GMT

Hi Everyone,

Please see this Knowledge Base article on how to use the REST Connector with OAuth against Microsoft Dynamics 365 Business Central.

We also have two related priorities on the roadmap, one for enhancing the REST Connector and one for adding a dedicated connector for MS Dynamics 365 Business Central. Both these are considered for future release, roughly within the next 6-12 months.

Thanks,
P-O

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud

Carl_Hunter — Wed, 11 May 2022 17:28:20 GMT

Thanks for the knowledge base article @P-O_Davidson - very in-depth. The issue we were having was resolved by adding the "accept-encoding" query header in the rest connector config! Thanks for clarifying 👍

Re: Add OAuth-Support for the Rest Web Service Connector in Qlik Sense Cloud - Status changed to: Closed - Already Available

Meghann_MacDonald — Tue, 28 Mar 2023 17:46:07 GMT

Hi all, I believe this is resolved based off of the comments, please let me know if that is wrong.

Meghann