BinaryToText - special characters deformed

BinaryToText - special characters deformed

  

Hello,

I want to use a json binary document. I used BinaryToText action and then JSON deserialize. The problem is: special characteres (like ã, ó, ê, etc.) come deformed. 

How can I fix this problem?

Thanks 

You need to choose the appropriate encoding to do the conversion.

Ricardo Silva wrote:

You need to choose the appropriate encoding to do the conversion.

Ricardo, I tried "unicode", "utf-8", "utf-16" and "ascii" and nothing :/


Can you share the document you are trying to import?

Ricardo Silva wrote:

Can you share the document you are trying to import?

http://centraldedados.pt/distritos.json

I can´t attach the document but the json is in that link. 

Thank you in advance


I solved a similar problem with a javascript hack on the client side.

https://www.w3schools.com/jsref/jsref_decodeuri.asp

It may help you as a quick and dirty solution.

JS:

decodeURIComponent(escape('GESTIÃ?N')) // returns: GESTIÓN

Hi,

Seems fine from my end

I don't have to indicate anything on the encoding and the special characters you've mentioned went thru the deserialization process.

Hi Mónica,

My guess is this may be related to what you mean by "json binary document"? And how did you obtain it in the first place?

Finally, after going through BinaryDataToText, do you have readable and correct JSON content?

I'm also seemingly not having any trouble with this:

https://ardoric.outsystemscloud.com/Distritos/Home.aspx

Maybe the problem is somewhat related to what Jorge said: the way the file was originally saved.

Can you share a small espace with the problem?