Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
GregRyder
Contributor II
Contributor II

Error in Load Script

Hi 

I am getting the following error when running my load script.

The following error occurred:
Cannot open file: 'lib://OneDrive - qlik@lrbrands.co.za/Stock Masterfiles/*.xlsx' (Connector error: Failed on attempt 1 to GET. (400 A potentially dangerous Request.Path value was detected from the client (*).))

and the script looks like

FROM [lib://OneDrive - qlik@lrbrands.co.za/Stock Masterfiles/*.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Workings);

It used to work on my on Prem server, but now mowing into QlikCloud I am getting this error.

Thanks 

Greg

Labels (2)
1 Reply
GregRyder
Contributor II
Contributor II
Author

Update

If I specify one of the file names it works

FROM [lib://OneDrive - qlik@lrbrands.co.za/Stock Masterfiles/Academy Brushware Master File 01 May 2023 Jorge Upd - Import Ready.xlsx]
(ooxml, embedded labels, header is 1 lines, table is Workings);

But I want it to to run through all the .xlsx files in the folder