Forum Discussion

kat_ma_88's avatar
kat_ma_88
Regular Visitor
6 years ago
Solved

Json.FromValue encoding issues with posting a record

Hello Community,

 

i hope someone can help with an encoding issue. I have to post a record which contains special characters "°". If i'll post the Json.FromValue record to an enpoint i'll get the utf8 equivalent and not the special character ({"unit":"\u00b0 C"}). Same with the following statement:

Text.FromBinary(Json.FromValue([unit="° C"])) -> {"unit":"\u00b0 C"} BUT it should be {"unit":"° C"}

 

Any ideas? Both functions Text.FromBinary and Json.FromValue have utf8 as default.

  • Hi kat_ma_88 

    As tesed, it seems Power query can't recognize the "°C" in that format.

    You could try this workaround.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support

    Hi kat_ma_88 

    As tesed, it seems Power query can't recognize the "°C" in that format.

    You could try this workaround.

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.