Forum Discussion
Request POST with Json Body
Hi sonet141 ,
thererfore I'd recommend to use the function Json.FromValue instead:
Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant
This means that you have to create the (nested) JSON-structure natively in Power Query and transform that using the function. This will convert booleans correctly, meaning keep them as a proper boolean in JSON.
Hi,
So, I changed my request to make it Case sensitive as you mentionned, and here the answer that I got:
Expression.Error: We cannot convert the value false to type Text.
Details:
Value=FALSE
Type=[Type]
It seems that one of my binary value can't be changed as string.
Is there anything that I'm missing ?
Thanks a lot ! 🙂
Hi sonet141 ,
thererfore I'd recommend to use the function Json.FromValue instead:
Easy POST requests with Power BI and Power Query using Json.FromValue – The BIccountant
This means that you have to create the (nested) JSON-structure natively in Power Query and transform that using the function. This will convert booleans correctly, meaning keep them as a proper boolean in JSON.