Forum Discussion
Passing Variables in API Post Request JSON Body
Hi saikishore,
you don't use the parameter "locid" as text in your function at all. If your expression in step "body" is supposed to do this: It will not work. If locid is a single text string, you have to concatenate it like so:
"{""locationNames"":"& locid &",#(lf)""drivingDirectionsRequest"": {""numDays"":""NINETY"",},}"
Post PatronHello ImkeF, v-yuta-msft,
The title of this post extactly matches my question.
How can I pass key : value pairs from a table rather than 1 by 1?
Here is my example API call (works great):
let
url = "https://company.com/api/path",
headers = [
"apikey" = thisisnotreallymyapikey
"accept" = application/json,
"Content-Type" = application/json
],
content = "{
""key"": {
""nestedKey"": value1,
""nestedKey"": value2
},
""key"": """",
""key"": ""value3"",
""key"": ""value4"",
""key"": value5,
""key"": [
{""key1"": ""value6"", ""key2"": ""value7""}
]
}",
webdata = Web.Contents(url, [Headers=headers,Content = Text.ToBinary(content)]),
response = Json.Document(webdata)
in
response
I need to have a table of key:value pairs that my query can hit iteratively until complete.
Example:
- Query refers to a table
- Pulls all key:value pairs accordingly
- Sends POST call to API
- Saves data to a table
- Repeats
- Appends data to a table until all calls have been made.
I don't know how to go about this. Any advice you can give is much appreciated.
Thank you
Community ChampionJust to make sure to understand your request:
1) For me a recursive action means that it picks up something from a previous action in order to continue.
I cannot spot that in your example. So could it be that you mean "iteratively" instead?: Go through a table with parameters and pass one row of it into each API-call?
2) With some additional escape signs and indizes, your "content" can be parsed out as a nested Record like so:
Will this structure always be the same for every key-value-pair combination that has to be passed trough (there are 9 different "Key"-fields in there currently)?
- ericOnline
Hello ImkeF, thank you for the reply.
1. You are correct. I mistakenly used "recursive" rather than "iterative".
2. Yes. Would like to use a table similar to below. Each record is a separate API call. I added numbers to the key:values above to show where in the query each cell would go.
This is a little different than how you laid out the table (records vs. columns).
3. Yes, the structure will always be the same for each call.
- ImkeF
You transform your query into a function ("MyFunction") that takes the current row (record) as its only argument. Then you add a column where you call "MyFunction" and pass the current record as a parameter to it:
Table.AddColumn(<PreviousStepname>, "APICall", each MyFunction(_))
quickest syntax with value1 as example (there might be issues with escaping, that you just have to try out..):
(_ as record) => let url = "https://company.com/api/path", headers = [ "apikey" = thisisnotreallymyapikey "accept" = application/json, "Content-Type" = application/json ], content = "{ ""key"": { ""nestedKey"": "& _[value1] &", ""nestedKey"": value2 }, ""key"": """", ""key"": ""value3"", ""key"": ""value4"", ""key"": value5, ""key"": [ {""key1"": ""value6"", ""key2"": ""value7""} ] }", webdata = Web.Contents(url, [Headers=headers,Content = Text.ToBinary(content)]), response = Json.Document(webdata) in response- ericOnline
Hi ImkeF. Thank you for putting time and energy into this response. I was pulled off this Power BI project for a month or so, now I'm back and trying to reorient myself with this problem.
Will respond with results.