Hi all,
I'm struggling to understand what I have to write in order to do a proper POST request; informations seems to be scarce both on the web and in the officiel doccumentation, here's what i've found tho:
https://www.thebiccountant.com/2018/06/05/easy-post-requests-with-power-bi-and-power-query-using-jso...
https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/
I have two tables:
(1)
SalesForce API (2)
All I want to do is to change the STATUS value on (2) if the table(1) says so, based on the unique key present in both tables. It's intended to send multiple STATUS updates for multiple KEYS(users), not one at a time.
I understand the basic concept of using Text.ToBinary and/or Jason.FromValue depending on the case, but I don't understand where/how to put them in the m-code:
Where do my KEY and STATUS fit in that exemple ?
let
URL = "http://xxx/tstat",
headers = [#"Content-Type"="application/json"],
data = Json.FromValue([tmode = 2,t_cool = Setpoint,hold = 0]),
web = Web.Contents(URL, [ Content = data, Headers = headers, ManualStatusHandling = {404, 400}]),
result = Json.Document(web),
Sorry I'm having trouble getting what I want done even tho all the work is laid up for me. I don't know if it's against etiquette to do so but user Imke told someone on her blog on a related subject to ping her, so I'll try my luck as to most of what I'm finding on the topic comes from her and/or Chris Webb. @ImkeF
Cheers,
Martin.
