March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hey everyone,
I need to program a schedule but i use dynamic data so i need to use Relative Paths, when i try to do that with the code under i got the error
Expression.Error: Se han pasado 3 argumentos a una función que espera entre 1 y 2.
Detalles:
Pattern=
Arguments=[List]
The param url contains something like this "730214/runs/3246632"
let
content = "{
""method"": ""post"",
""body"": {}
}",
Origen = Json.Document(Web.Contents( "https://test.com/test/",
[RelativePath = url & "/reports/cookie-privacy"],
[Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()],
Content=Text.ToBinary(content)])),
#"Convertido en tabla" = Record.ToTable(Origen)
in
#"Convertido en tabla"
Thanks for your help
Hi @yebenesPW I don't understand the need for "url" in the relativepath. What does url contain? It is possible that Power is generating the following web call?
https://test.com/test/https://test.com/test//reports/cookie-privacy
This would look better
let
content = "{
""method"": ""post"",
""body"": {}
}",
url = "https://test.com/test",
Origen = Json.Document(Web.Contents( url,
[
RelativePath = "/reports/cookie-privacy",
Headers=[#"content-type"="application/json", Authorization="Bearer " &#"GetToken"()],
Content=Text.ToBinary(content)
]
)
),
#"Convertido en tabla" = Record.ToTable(Origen)
in
#"Convertido en tabla"
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
21 | |
16 | |
13 | |
12 | |
9 |
User | Count |
---|---|
35 | |
31 | |
20 | |
19 | |
17 |