topic Re: Sharepoint token expired due to inactivity in Connectivity & Data Prep

Sharepoint token expired due to inactivity

AronC — Thu, 30 Dec 2021 13:15:54 GMT

When I set up a connection to Sharepoint it is only valid for 90 days. The connection is used everyday to read Excel-tables. After 90 days I get the error "The refresh token has expired due to inactivity".

Anyone that has experienced this and has a solution to update the refresh token?

Thanks in advance.

Re: Sharepoint token expired due to inactivity

chrisbrain — Thu, 30 Dec 2021 13:40:21 GMT

Hi - Unfortunately I don't think there is a solution to this at present other than setting a reminder to reauthenticate before the 90 days is up.

Re: Sharepoint token expired due to inactivity

AronC — Mon, 28 Feb 2022 15:36:47 GMT

Thanks for your reply. Do you have any idea about limitations for other filesharing services, (Dropbox, Onedrive, Google drive)?

In google drive I have a connection today that is working fine without the need for updating the connector, but for Dropbox and Onedrive I have no idea what limits that might exist. We are looking to set up a fileshare that will work without any need for maintenance of the conectors.

Thanks in advance.

Re: Sharepoint token expired due to inactivity

Daniele_Purrone — Tue, 01 Mar 2022 15:10:28 GMT

@AronC
as far as I remember, Microsoft is the only one enforcing this time out at the moment, among the most common major players.

Re: Sharepoint token expired due to inactivity

AronC — Wed, 02 Mar 2022 09:36:38 GMT

Thank you @Daniele_Purrone.

So you mean it apply to all Microsoft fileshares? So I will have the same problem in Onedrive also then?

Re: Sharepoint token expired due to inactivity

Daniele_Purrone — Wed, 02 Mar 2022 13:54:11 GMT

Hi @AronC . Yes. If nothing has changed recently, OneDrive is also affected by this policy on Microsoft's side.

Re: Sharepoint token expired due to inactivity

paulcalvet — Wed, 10 Aug 2022 08:17:17 GMT

Hello Daniele,

I found this thread on microsoft community :

https://www.microsoftpartnercommunity.com/t5/Multi-Factor-Authentication-MFA/OAuth-Refresh-token-has-expired-after-90-days/m-p/9200

It seems there is a solution to regenerate a token silently after every connection.

Regards,

Re: Sharepoint token expired due to inactivity

AronC — Tue, 16 Aug 2022 08:52:05 GMT

@paulcalvet Is this something you have managed to implement in Qlik Sense connector?

Re: Sharepoint token expired due to inactivity

paulcalvet — Tue, 16 Aug 2022 12:07:51 GMT

No, I just found this documentation.

It seems strange that SharePoint doesn't offer a token that during moore than 90 days.

Currently, we regenerate token every 89 days for our sharepoint connection.

Re: Sharepoint token expired due to inactivity

AronC — Sun, 06 Nov 2022 20:54:42 GMT

@Daniele_Purrone Have your read the link? Would it be possible for Qlik to uppdate the setup of the data connection in order to make it work for more thena 90 days?

Re: Sharepoint token expired due to inactivity

Daniele_Purrone — Mon, 07 Nov 2022 08:25:00 GMT

Hi @AronC , please log an idea with the details on the ideation page. Thanks!

Re: Sharepoint token expired due to inactivity

AronC — Tue, 08 Nov 2022 10:52:47 GMT

@paulcalvet I wrote an suggestion that Qlik modifies the Sharepoint-connector. please like the ide if you want them to fix this issue.

Re: Sharepoint token expired due to inactivity

paulcalvet — Tue, 08 Nov 2022 16:46:34 GMT

Sure ! thanks

Re: Sharepoint token expired due to inactivity

psublue98 — Mon, 05 Dec 2022 16:27:57 GMT

FYI I believe this is now resolved according to the 11/29/22 post Automatic token refresh for connectors.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Introduction/saas-change-log.htm

Re: Sharepoint token expired due to inactivity

p_verkooijen — Tue, 07 Mar 2023 14:20:12 GMT

Any chance this is also updated for Qlik Sense Client Managed ? Can't find any reference to a refresh token https://help.qlik.com/en-US/connectors/Subsystems/Integrated_Web_Connectors_help/Content/Connectors_QWC_BuiltIn/Integrated%20connectors/Office-365-Sharepoint-Connector-integrated.htm

Re: Sharepoint token expired due to inactivity

molivier — Tue, 30 May 2023 09:05:18 GMT

According to this link, that update is not coming to CM

https://community.qlik.com/t5/Suggest-an-Idea/Automation-of-updating-authentication-token-in-Qlik-Office-365/idi-p/2014159

Re: Sharepoint token expired due to inactivity

molivier — Tue, 30 May 2023 09:06:12 GMT

Can you share that solution? or is this a manually process?

Or can you point out a microsoft website how to do this?

Re: Sharepoint token expired due to inactivity

AronC — Tue, 30 May 2023 19:13:32 GMT

This is fixed quite some time ago. The connector gets updated token automatically. You dont need to update the connection any more now as you had to do before.

Re: Sharepoint token expired due to inactivity

molivier — Tue, 30 May 2023 20:01:04 GMT

Yes for SaaS .. but not for Client Managed ... I logged a ticket @ Qlik Support and they confirmed