The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
I am connecting to api using username and password. but I am getting the authentication issue which is "Web.Contents with the Content option is only supported when connecting anonymously." My issue screenshot are mentioned below.
My code are:
---------------------------------------------------
let
url = "https://xxxxxxxxxxxxx.io/api/v1/order_view",
body = "{""order_id"":""11931""}",
Source = Json.Document(Web.Contents(url,[Content=Text.ToBinary(body),Headers=[#"Content-Type"="application/json"]])),
#"Converted to Table" = Record.ToTable(Source),
Value = #"Converted to Table"{3}[Value]
in
Value
Hi @RohitClouds
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
Thank you for your reply othy_bi. I am calling an API and we have api credentials for that I am not able to call anonymously.
Do you have any other ideas?
Change your source row as below and try again
Source = Json.Document(Web.Contents(url,[ Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body) ])),
Did it work ? 👍 A kudos would be appreciated 📢 Mark it as a solution to help spreading knowledge
User | Count |
---|---|
56 | |
54 | |
53 | |
47 | |
30 |
User | Count |
---|---|
173 | |
89 | |
70 | |
46 | |
45 |