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

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!