Forum Discussion

MKE's avatar
MKE
Helper I
4 years ago
Solved

Passing a string variable in a POST request payload/body

Hello guys,   I have a variable "Id" that I am passing in a payload as shown below. "Id" is a string value like "LASST390000000000003". If I hardcode it, it works but once I pass it in as a variabl...
Need Help
Show and Tell
Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Use this for body

body = "{""seriesid"":[""&id&""], ""startyear"":""2010"", ""endyear"":""2012""}"
MKE's avatar
MKE
Helper I
4 years ago

Hi Vijay_A_Verma, thanks for your input. Unfortunatey that couldn't pass in the Id as expected. Howerver, I cracked it following my reference to this resource:

https://community.powerbi.com/t5/Power-Query/Passing-Variables-in-API-Post-Request-JSON-Body/m-p/529756

 

The solution is:

Id = Text.Combine({"[""",Locations[Location]{0},"""]"},""), ----- Crazy string concatenation here
body = "{""seriesid"":"&Id&",""startyear"":""2017"", ""endyear"":""2022""}", ----referencing it here