Illegal characters in path when using Directory.GetFiles on WebDav

Help Studio
, ,
1

Hello UiPath-Forum Colleagues,
i want to get the files from a subfolder on webdav.
To do that i am using the command Directory.GetFiles(subfolder).
The target folder is stored in the variable subfolder as string.

image
image985×133 8.42 KB

UiPath throws an error message: Illegal characters in path.
image
When executing the command on the immediate command line it works, when i use the content of the variable in the Directory.GetFiles command.
image
Note, the folder is on a webdav server, which is mounted as drive Y.
Does anybody have an idea why the Directory.GetFiles command does not work?
Best regards,
Jo

2

Hi,

Remove Extra Spaces: subfolder.Trim()
Check for Special characters: Webdev not except some special characters
subfolder = subfolder.Trim().Replace(“<”, “”).Replace(“>”, “”).Replace(“:”, “”).Replace(“*”, “”).Replace(“?”, “”).Replace(“|”, “”).Replace(“”“”, “”).Replace(“/”, “”)
subfolder = Uri.EscapeUriString(subfolder)
FilesArray = Directory.GetFiles(subfolder)

I hope it helps you

3

Hi,

Is there possibility to contains something wrong character in the path? Can you share the xaml file? It’s no problem if just the activity exists.

Regards,

4

Hi Rigandu,
i tried the uri.escapeUriString function, but it does not work either

image
image774×25 1.83 KB

Why does the function find the folder with “Y:\data\out\VomMandanten\DCB\KSI-Export\20230508_093628_463886”, but not if i use the variable with the string as content?
Best regards, Jo

5

Hi,

It seems your path string ends with 0x00 (special character). So can you try to remove it OR use Trim(chr(0)) as the following?

"your path string".Trim(chr(0))

image

Regards,

2 Likes
6

Hello Yoichi,
thank you for the idea. Unfortunately removing the %00 does not work either.

image
image727×72 3.28 KB

Best regards,
Jo

7

HI,

Can you share your xaml file? It’s no problem even if unnecessary activities are removed.

Regards,

8

Hello Yoichi,
this is the xaml file.

The thing is, the directory.getfiles function works when i geht files from windoes directories.
But i am working on webdav. maybe webdav requires another function.
What i do not understand is, that if i use the String itself it works, but when i use the variable that holds the string, it does not work.
Best regards,
Jo

9

HI,

To isolate cause, can you insert the following expression in Writeline activity then share the content when error occurs?

String.Join(",",tempSubfolder.Select(Function(c) AscW(c).ToString))

image
image769×705 23.6 KB

Regards,

10

Hello Yoichi,
your hint with the last character %00 is worthwile looking at.

image
image724×105 3.14 KB

If i remove the last character, it seems to work. Still got to put it into the Robots workflow and see if it works.

Best regards, Jo

11

Got it, thank you very much!

1 Like
12

I removed the workflow file, just as information.

13

trim(chr(0)) does not work though, i check if subfolder.EndsWith(Nothing) and then remove it with Directory.GetFiles(Left(subfolder, Len(subfolder) - 1))

1 Like
14

Great to hear the problem is solved.

FYI, as the following expression shows what character exists then we can know which character should be removed.

String.Join(",",tempSubfolder.Select(Function(c) AscW(c).ToString))

Regards,

15

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.