Understanding the POST request syntax

[Kiwizqt]

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)

KEYS	STATUS
894878	CLOSED

SalesForce API (2)

KEYS	STATUS
894878	OPEN

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.

[v-kelly-msft]

Hi  @Kiwizqt ,

Check whether below blog help:

https://blog.crossjoin.co.uk/2014/04/19/web-services-and-post-requests-in-power-query/

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!