Qlik Cloud OAuth Excel Add-in

rolmontero — Wed, 13 Dec 2023 16:00:10 GMT

Hello everyone,

I am trying to use the newly added Excel add-in to start working with this sort of report. However, I am getting an error message when I try to connect to Qlik with Excel in Office365.

On the other hand, from the OAuth side, I have this configuration.

Does anyone know what am I missing?

Thanks a lot!

Re: Qlik Cloud OAuth Excel Add-in

Frank_S — Wed, 13 Dec 2023 17:14:14 GMT

Suggest creating another oAuth client and ensure you have set the attributes properly.

Start with a broad scope to begin with (use 'user default'. you can narrow the scope later)

(based on your image you do not have use default at all. this is a requirement)

Recheck all the steps shown below to ensure they are setup accurately.

Creating an OAuth client for the Qlik add-in for Microsoft Excel

An OAuth client configuration is required to install the Qlik add-in for Microsoft Excel. The add-in is used by report developers to prepare report templates which control output of tabular reports from the Qlik Sense app.

For OAuth to work in the add-in, the OAuth client needs to be configured with the exact configuration shown below.

Do the following:

In the Management Console in Qlik Cloud, go to OAuth.
Click Create new.
In the Client type dropdown menu, select Single-page app. More fields will appear.
Insert a Name. The Description is optional.
At minimum, select the checkbox to include the user_default scope. You can include other scopes in the configuration, but without user_default, installation will not work.

See Creating an OAuth client for a full description of each available scope.
In the Add redirect URLs field, insert the URL of your tenant, followed by the fixed string: /office-add-ins/oAuthLoginSuccess.html

The result should look like this: https://YourServer/office-add-ins/oAuthLoginSuccess.html
Click Add.
In the Add allowed origins field, insert your tenant URL and click Add.
Click Create.
The Copy your Client ID window appears. You can choose to copy the Client ID to clipboard, or click Done to close the window.

After you have created the OAuth client, obtain the link to the updated manifest XML file from the Management Console. Go to the Settings page, and navigate to Feature control > Excel add-in within the Management Console. Use this link to deploy and install the add-in.

For additional example setup, refer to this image below.

Re: Qlik Cloud OAuth Excel Add-in

Frank_S — Wed, 13 Dec 2023 18:10:42 GMT

New Article related to this issue can be found here

https://community.qlik.com/t5/Official-Support-Articles/Tabular-Reporting-OAUTH-Error-Status-400-resolution/ta-p/2152687

Re: Qlik Cloud OAuth Excel Add-in

rolmontero — Wed, 13 Dec 2023 18:15:08 GMT

Hi @Frank_S ,

Now, the tabular report is working!

Have a nice day!

Re: Qlik Cloud OAuth Excel Add-in

Frank_S — Wed, 13 Dec 2023 18:19:16 GMT

Hi @rolmontero

I am pleased to here it is now working for you!

Cheers!

topic Re: Qlik Cloud OAuth Excel Add-in in Integration, Extension & APIs

Qlik Cloud OAuth Excel Add-in

Re: Qlik Cloud OAuth Excel Add-in

Creating an OAuth client for the Qlik add-in for Microsoft Excel

Re: Qlik Cloud OAuth Excel Add-in

Re: Qlik Cloud OAuth Excel Add-in

Re: Qlik Cloud OAuth Excel Add-in