topic Office 365 sharepoint Authenticate Error in Connectivity & Data Prep

Office 365 sharepoint Authenticate Error

hanna_choi — Wed, 24 Apr 2024 05:28:52 GMT

Dear.

This issue happened at the Qlik Sense Nov 2023 version in my case.

Step 1: In Qlik Sense Hub, I'm creating Data connection.

Step 2: Click on Office 365 Sharepoint.

Step 3: Then I'm giving the our Share point URL.

Step 4: Below I tried to choose all the below options. Then i will click on Authenticate.

Error Message *******

Office 365 sharepoint Authenticate button is working well at the Sense Feb 2024 version.

What could be the problem?

Re: Office 365 sharepoint Authenticate Error

Bjorn_Wedbratt — Wed, 24 Apr 2024 19:27:03 GMT

Hi @hanna_choi ,

Most likely it's related to the following: https://help.qlik.com/en-US/connectors/Content/Connectors_Home/Setting-encryption-key.htm

To generate an encryption key you can use PowerShell or openssl, here's an example PS script:

# Generates a 32 character base 64 encoded string based on a random 24 byte encryption key function Get-Base64EncodedEncryptionKey { $bytes = new-object 'System.Byte[]' (24) (new-object System.Security.Cryptography.RNGCryptoServiceProvider).GetBytes($bytes) [System.Convert]::ToBase64String($bytes) } $key = Get-Base64EncodedEncryptionKey Write-Output "Get-Base64EncodedEncryptionKey: ""${key}"", Length: $($key.Length)"

Hope this helps!

Best, Björn

Re: Office 365 sharepoint Authenticate Error

hanna_choi — Thu, 25 Apr 2024 04:17:14 GMT

Hi Björn

Thank you for your reply.

I think this guide is focus to create EncryptionKey.

I understand Office 365 Sharepoint connector can create authenticate key by oneself in Qlik Sense Nov 2023 version.

I hope to solve that the button of authenticate key is not working.

There's no other way, right?

Thank you

hanna.choi