Forum Discussion

WillBatesHydro's avatar
WillBatesHydro
Helper I
4 years ago
Solved

API PUT METHOD VIA POWER QUERY

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

General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • WillBatesHydro's avatar
    WillBatesHydro
    4 years ago

    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

2 Replies

  • WillBatesHydro's avatar
    WillBatesHydro
    Helper I
    4 years ago

    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's avatar
    lbendlin
    Super User
    4 years ago

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