topic Re: Store into Sharepoint not possible - "Cannot open file" in Connectivity & Data Prep

Store into Sharepoint not possible - "Cannot open file"

petergassert — Wed, 26 Mar 2025 14:26:29 GMT

Hi,

i am tryint to store an txt file to sharepoint following the Qlik instructions:
Office 365 Sharepoint | Qlik Connectors Help

Same sharepoint location is already used for loading files into qlik. (Reading and importing the data from the file is no problem.)

Storing the file at the same location causes the following error message:

Cannot open file: lib://Reporting_SP/Shared Documents/StoredQVD/test.txt' (Native Path: *** System error: ***)

user used for the qlik connection has full permission on the sharepoint.

Chanty4u — Wed, 26 Mar 2025 17:36:34 GMT

You have to do some checks in this case

1.Verify the File Path Format

STORE MyTable INTO 'lib://Reporting_SP/Shared Documents/StoredQVD/test.txt' (txt);

2 Try using the complete URL path instead of the relative path

3.Ensure "WRITE" Access on SharePoint

4.Enable "Allow Edits" on the SharePoint Library

petergassert — Fri, 28 Mar 2025 14:46:44 GMT

Hi Chanty4u,

thanks for your quick reply:

we tried the following store commands:

STORE [T1] INTO [lib://LHG_GRP_MT_DS_OD_LMP_Reporting_SP/Shared Documents/test.txt](txt);
STORE [T1] INTO [lib://LHG_GRP_MT_DS_OD_LMP_Reporting_SP/sites/Reporting-LMP/Shared Documents/test.txt](txt);
STORE [T1] INTO [https://XXX.sharepoint.com/sites/Reporting-LMP/Shared Documents/test.txt](txt);
STORE [T1] INTO [lib://XXX.sharepoint.com/sites/Reporting-LMP/Shared Documents/test.txt](txt);

None of these were successfull.

Can you please give us an example how the complete URL path should look like.

Thanks and best regards,
Peter

stevedark — Thu, 08 May 2025 13:07:04 GMT

Steve

petergassert — Thu, 08 May 2025 14:06:11 GMT

Solution found within the fine print. Sadly not working for Qlik Enterprise and Desktop. Seems to be working for SaaS.