Unable to read special characters from file with tHttpRequest

[Anonymous]

Im reading a csv file hosted on SharePoint with tHttpRequest but I dont know how to read the accents and special caracters.

I'm getting an output like N�Demande ;Dur�e ;r�sultat

• I used headers section to add "Content-Type" : "Charset=ISO-8859-1"

• I tried also to use tjava component to read the input as ByteArrayOutputStream and used row1.ResponseContent.getBytes("ISO-8859-1")

but I'm still getting an output like N?Demande ;Dur?e ;r?sultat

I changed the Charset to "UTF-8" but it's giving me the same result

Do you have any idea please about how to get the right caracters with tHttpRequest ?

[Anonymous]

Hi,

    Could you please verify whether the original file is having the data in right manner with UTF-8?

    There is a possibility that the data is already changed in the source file itself.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

thank you @nthampi for your reply

The data in the original file was written in the right manner , the file is encoded in "ANSI"

If I  change the encoding of my file to UTF-8 I can get the data with the right special caracters.