Store into Sharepoint not possible - "Cannot open file"

[petergassert]

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]

You have to do some checks in this case 

Like 

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]

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]

I don't believe that this is supported, see:
https://community.qlik.com/t5/Connectivity-Data-Prep/Store-files-in-Sharepoint/td-p/2515276

Steve

[petergassert · Accepted solution]

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