Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Greetings,
I had a REST URL working, but had a problem with the table. I did not keep a copy.
There is no syntax errors, but the new code is failing??
let
cfaURL = url,
cfatoken = token,
SourceURL = Json.Document(Web.Contents(cfaURL+cfatoken, [Headers [#"Authorization"=cfatoken]])),
toTable = Table.FromRecords({SourceURL})
in
SourceURL
The error is (Left = URL + Right = token)
Expression.Error: We cannot apply operator + to types Text and Text.
Details:
Operator=+
Solved! Go to Solution.
Hi @Anonymous
That error is from trying to join cfaURL and cfaToken using a +
To join text use &
e.g.
SourceURL = Json.Document(Web.Contents(cfaURL & cfatoken, [Headers = [#"Authorization"=cfatoken]])),
Note: Headers was also missing an = after it, which I've corrected in the code above.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi @Anonymous
That error is from trying to join cfaURL and cfaToken using a +
To join text use &
e.g.
SourceURL = Json.Document(Web.Contents(cfaURL & cfatoken, [Headers = [#"Authorization"=cfatoken]])),
Note: Headers was also missing an = after it, which I've corrected in the code above.
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!