Forum Discussion

papi0506's avatar
papi0506
Frequent Visitor
4 years ago
Solved

Power query using variables in script blocks for POST API calls

Still new to power bi and it truly is a powerful tool. I'm running into one road block with my power query. The only way I've been able to make a proper POST API call to retreive data is by putting t...
Need Help
  • AlB's avatar
    AlB
    4 years ago

    Hi papi0506 

    Try concatenating the string pieces rather than having everything in one string. Place the following M code in a blank query to see an example

    let
    #"tryagain" = "GetInThere",
    BodyContent_=  "{ ""password"" : " & #"tryagain" & " }"
in
    BodyContent_

     

    		 Please accept the solution when done and consider giving a thumbs up if posts are helpful. 

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

     

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Can you paste the query as text in this post so that experts can work on your query? 

papi0506's avatar
papi0506
Frequent Visitor
4 years ago

I'll keep that in mind for next time. AIB's suggestion worked perfectly and I can even use it with parameters now {yeaaaa}. Thank you very much tho.