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 the Content of the Web.Contents body in a type of script block. This places quotes around the entire block for values to be taken as writen, but does not allow for they use of variables or parameters inside. 

Example in the screenshot works perfect, but I need to be able to use parameters preferably that way values can be changed for the same call. 
works like a charmwould like to use variables or parameters for dynamic values

 

The last screenshot, I've tried variables of different types and even parameters, but they break the syntax. 

 

Any help is greatly appreciated. 

 

 

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.

     

4 Replies

  • AlB's avatar
    AlB
    Community Champion
    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.

     

    • papi0506's avatar
      papi0506
      Frequent Visitor
      4 years ago

      Hey AlB, 


      Thank you so much, your suggestion worked like a charm. I had been looking for the proper syntax to all concatening strings together. This was exactly what I was looking for. 

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