Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Edy_Tan
Employee
Employee

Access Office 365 Sharepoint when folder contains a dot

I am trying to access a file from Office 365 sharepoint, when the folder do not have a dot the file can be previewed.  

Screenshot 2023-08-04 at 9.37.50 AM.png

However, if the folder have a dot, for e.g., 1.test, the same file cannot be previewed

Image 4-8-23 at 9.32 AM.jpeg

And when I do a load, I am able to load from the path which contains 1.test

Screenshot 2023-08-04 at 10.02.41 AM.png

I have encountered the same behaviour in customer environment.

Any help is appreciated.

Labels (1)
4 Replies
woutermak
Partner - Creator III
Partner - Creator III

I have the same problem. No solution till so far.

NellyAcko
Contributor III
Contributor III

Have you tried using a variable string for the lib connection and replacing the dot with Chr(34) it may just do the same but worth a try. Or maybe try to use a wild card on the sub folder if that's possible E.G. /1*/

Edy_Tan
Employee
Employee
Author

The issue occur when we use the UI to find a file and previewing it, for e.g., 

Edy_Tan_0-1692003198049.png

I have navigated to the sub sub folder and found the file that I want

Edy_Tan_1-1692003281552.png

click on the select button will normally show the preview of the data, but in this case its showing blank

How do variable string, replacing the dot, use wild card works in this situation?

 

marcus_sommer

If the load worked but not the preview it hints for an incomplete configuration or a bug within the parser for the preview. I could imagine that's a rather small issue within the processing. I think you should forward it to the R&D team.