topic Re: Access Office 365 Sharepoint when folder contains a dot in Connectivity & Data Prep

Access Office 365 Sharepoint when folder contains a dot

Edy_Tan — Fri, 04 Aug 2023 02:11:51 GMT

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

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

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

I have encountered the same behaviour in customer environment.

Any help is appreciated.

Re: Access Office 365 Sharepoint when folder contains a dot

woutermak — Fri, 11 Aug 2023 12:47:20 GMT

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

Re: Access Office 365 Sharepoint when folder contains a dot

NellyAcko — Fri, 11 Aug 2023 18:37:33 GMT

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*/

Re: Access Office 365 Sharepoint when folder contains a dot

Edy_Tan — Mon, 14 Aug 2023 08:56:33 GMT

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

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

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?

Re: Access Office 365 Sharepoint when folder contains a dot

marcus_sommer — Mon, 14 Aug 2023 10:51:57 GMT

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.