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.

     

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.