Forum Discussion

adam_cogswell's avatar
adam_cogswell
Regular Visitor
9 years ago
Solved

JSON query based on another query

Hi,   New to PowerBI, and having what is probably a simple problem but can't seem to get it figured. I am trying to load JSON data and I've got one query working like a charm, transformed into a ta...
Need Help
  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    9 years ago

    Sorry I ommitted a "let".  See below:

     

    let function = (ID as text) => let
    Source = Json.Document(Web.Contents("https://api.provider.com/survey_results?survey_id=" & ID,
        [Headers=[Authorization="Bearer ACCESS_TOKEN", Allow="application/json", #"NGIN-API-VERSION"="0.1"]]))
in
    Source
in
    function
adam_cogswell's avatar
adam_cogswell
Regular Visitor
9 years ago

Sorry, I had re-arranged them trying to troubleshoot it. It doesn't work either way...

dkay84_PowerBI's avatar
dkay84_PowerBI
Microsoft Employee
9 years ago

To be clear, you are getting the error just trying to save the query/function, and not even at the point of invoking it, correct?

  • dkay84_PowerBI's avatar
    dkay84_PowerBI
    Microsoft Employee
    9 years ago

    Sorry I ommitted a "let".  See below:

     

    let function = (ID as text) => let
    Source = Json.Document(Web.Contents("https://api.provider.com/survey_results?survey_id=" & ID,
        [Headers=[Authorization="Bearer ACCESS_TOKEN", Allow="application/json", #"NGIN-API-VERSION"="0.1"]]))
in
    Source
in
    function
  • adam_cogswell's avatar
    adam_cogswell
    Regular Visitor
    9 years ago

    Correct. I click "Done" and it shows that error. It also appears in the Advanced Editor before I even click the button. 

  • adam_cogswell's avatar
    adam_cogswell
    Regular Visitor
    9 years ago

    No apologies necessary. That seems to have done the trick, the function is validating now. I just need to test the rest of that workflow. Thanks for all your help!