Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowGet certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started
Hello,
I am passing the below query and getting an error message in the response saying "Expression.Error: We cannot convert a value of type Record to type Text."
There are 3 mandatory parameters in the body, of which category id is an integer and the other two are string data types. Any suggestions would be appreciated to fix the error.
let
url = "https://api.xxxxxx/report",
headers = [#"Content-Type" = "application/x-www-form-urlencoded",
#"Accept" = "application/json",
#"Authorization"="Basic Token"
],
body = [categoryId = 1, employeeId = "radmin", reportName = "Activity"],
response = Json.Document(Web.Contents(url, [Headers = headers, Content = Text.ToBinary(body)]))
in response
Error Message:
Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=
categoryId=1
employeeId=radmin
reportName=Activity
Type=[Type
Thanks
body is a record, not a text.
Please follow the documentation. Use Json.FromValue. https://learn.microsoft.com/en-us/powerquery-m/web-contents#example-2
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
18 | |
10 | |
9 | |
9 | |
8 |
User | Count |
---|---|
16 | |
15 | |
13 | |
12 | |
11 |