API PUT METHOD VIA POWER QUERY

[WillBatesHydro]

Hello All, 

Hope you are well, 

I was wondering if anybody can lend a hand here?

I have successfully used both GET and POST Hubspot APIs with a few tweaks in the M language via power query (Excel) 

So far I have used several GET calls to the HubSpot API to retrieve data then by using this data I have been able to create notes and send via the POST method. 

Firstly by creating the note via a POST API but at that point it has just created a note that isn't associated with anything (in the nether zone). What you then need to do is use a PUT call in by using the company/contacts id to associate. 

The following link works perfectly using Postman but can not for the life of me find a way to use a PUT call using Powerquery. Does anybody have any info on this?

https://api.hubapi.com/engagements/v1/engagements/{NOTE ID}/associations/company/{{Company ID}?hapikey=XXXX

Any help at all will be really appreciated 

Thanks in advance 

Will

[WillBatesHydro · Accepted solution]

Thanks Ibendlin! Yeah, really unfortunate Power query doesn't support these features, I wonder if they would be possible in a new release, or is there something fundamental preventing the possibility. Found a workaround anyway, for those that are faced with the same problem whilst dealing with the Hubspot API - Although it is not possible to make individual association calls via power query (as it requires PUT) you can however use POST to make batch associations, This method doesn't restrict you from making just one association too. So solves that problem 

Cheers

Will

[lbendlin]

Unfortunately Power Query only supports GET and POST (the latter if you specify a payload).  You cannot do PUT, PATCH, or DELETE requests.