GET Web Request - Response Content with special characters?

  • 19 January 2018
  • 1 reply
  • 19 views

Badge +1

Hello everybody,

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"

212295_pastedImage_1.png

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


1 reply

Badge +1

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.

Reply