Power Query error

[Anonymous]

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=+

[PhilipTreacy · Accepted 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.