Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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://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.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.