In my workflow, I use a GET Web Request to read the contents of a CSV File in SharePoint.
In the CSV File, there are many values with special characters (ö ä ü, etc. ) that are typical in german speaking countries.
However, when using the GET Web Request, it is unable to read these characters and replaces them with a symbol.
e.g. "Durchführung" becomes "Durchf�hrung"
I have tried to afterwards fn-xmldecode that content, but it didn't work.
I also tried adding various headers to the GET request, but not sure if I did that right.
Anyways none of them worked.
Then I tried to save the original CSV file in different encoded formats (UTF-8, ANSI, ISO-8859-1) but that did not change anything either.
Any help would be appreciated!
Many thanks in advance
I found the solution to this problem.
The CSV or TXT file needs to be explicitly converted to UTF-8 format.
When using the Excel Save As CSV prompt it did not work.
I had to use Notepad++ and say "convert to UTF-8".
Then the web request read the characters correctly.