Forum Discussion
kat_ma_88
6 years agoRegular Visitor
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
MaggieCommunity 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-msftCommunity 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
MaggieCommunity 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.