Json.FromValue encoding special characters

[Anonymous]

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.

[Anonymous]

here

seems to have treated and solved a problem similar to yours