Associations API's - why so poor?

Jan_Z · 3 weeks ago

We've been trying to automate a few things with Hubspot, and running into super basic limitations around associations.

Given that it's a CRM, I'd expect that being able to query and navigate relationships would be baseline functionality.

List API's expand associations, but have zero filtering, so useless for anything other than data copy. Search can filter, and can even filter on associations, but (seemingly) cannot actually list associations.

There are batch API's, but associations are only available for individual requests. There is no associations search API to even ask "what is this thing attached to".

It seems like the only way around this is to literally dump the HS data with list API's, and do all the processing outside of HS. That seems... a bit crazy. Are we missing something obvious here?

Jaycee_Lewis · 3 weeks ago

Hi, @Jan_Z 👋 Thank you for your feedback. You've touched on some limitations of our APIs. While powerful, they do have some limitations, especially when it comes to associations. .

Addressing your concerns:

Associations Filtering: You’re correct that the current Associations API doesn’t fully support complex querying or listing of associations
Workarounds: Unfortunately, as you’ve pointed out, the typical workaround is to use the List APIs to export data and handle processing externally

We really appreciate the effort you've put into exploring these options. For product feedback, adding your suggestion to the Ideas Community and getting some upvotes will be very helpful in getting your suggestion in front of the Product team. If you add a link back to your Idea post, I'll be sure to give it an upvote.

Best,

Jaycee