none
Power Query Rest JSON API Token RRS feed

  • Question

  • I can't get this REST API to query a token for some reason any ideas? Would really appreciate the help.

    The password is URI Encoded and I think this might be an issue. It's working in Javascript and not working with power query and would like to connect the <g class="gr_ gr_202 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="202" id="202">APi</g> directly to <g class="gr_ gr_215 gr-alert gr_spell gr_inline_cards gr_run_anim ContextualSpelling ins-del multiReplace" data-gr-id="215" id="215">powerbi</g>. appreciate any help someone can give me.

    let
        ONLoginInfo =
    [""grant_type=password&username=password&username=username12&password=passwordencoded""],
        URL= "https://private-anon-3e281d3420-progresso.apiary-mock.com/Token",
        Options=[Headers=[#"content-Type"="application/x-www-form-urlencoded"],Content
    = Text.ToBinary(ONLoginInfo)],
        Source = Json.Document(Web.Contents(URL,Options))
    in
        Source

    Monday, February 4, 2019 8:29 PM

Answers