Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Json.FromValue encoding special characters

Hi - I am using the following formula to create some JSON:

 

Text.FromBinary(Json.FromValue(
[domain=[company.domain],
companyName=[company.company],
speakerName=[speaker.title],
speakerTitle=[speaker.roles.job_title],
speakerCompany=[speaker.roles.company_name],
speakerImageURL=[speaker.thumbnail],
speakerURL=[speaker.permalink],
sessions={[sessions]}]))

 

But special characters get encoded e.g. Damsgård is contained in the column data but gets encoded to Damsg\u00e5rd in the JSON. I've tried using UTF8 encoding value etc.

 

How can I stop this or change these back to the actual characters? Note I don't know how many cases of this there are in the data so an individual find & replace is not ideal.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    here

     

    seems to have treated and solved a problem similar to yours