topic Re: Get associations with deals from crm objects deals search endpoint in APIs & Integrations

Get associations with deals from crm objects deals search endpoint

iaa — Sat, 22 Feb 2020 15:29:59 GMT

Hello,

I'm working on interation with Hubspot's API in order to extract our deals using the

"https://api.hubapi.com/crm/v3/objects/deals/search" endpoint.

Example query params:

properties: ['dealname', 'amount', 'closedate', 'pipeline', 'dealstage', 'hs_createdate', 'hs_lastmodifieddate',
  'createdate', 'hubspot_owner_id', 'dealname', 'dealstage', 'hs_is_closed', 'hs_closed_amount',
  'associations.company'],
filterGroups: [
  {
    filters: [
      {
        "propertyName": "closedate",
        "operator": "GTE",
        "value": start * 1000,
      },
      {
        "propertyName": "hs_is_closed",
        "operator": "EQ",
        "value": true,
      },
      {
        "propertyName": "associations.company",
        "operator": "HAS_PROPERTY",
      },
    ],
  }

It worked fine except to the fact that at this endpoint, it doesn't return association.

I tried to add "associations=deals".

I used this documentaion https://developers.hubspot.com/docs-beta/crm/deals and https://developers.hubspot.com/docs-beta/crm/search

Thank you,

Alex.

Re: Get associations with deals from crm objects deals search endpoint

WendyGoh — Mon, 24 Feb 2020 04:50:35 GMT

Hey @iaa,

When looking to retrieve associations between objects, you would need to use this endpoint - CRM API | Associations. Specifically the 'Read a batch of associations' endpoint - something like this:

POST URL - https://api.hubspot.com/crm/v3/associations/DEALS/CONTACTS/batch/read?hapikey={{hapiKey}}

POST Body -

{"inputs":[{"id":"{{dealId}}"}]}

Hope this helps and do let me know if you've any further questions on this!

Re: Get associations with deals from crm objects deals search endpoint

PowerMyAnalytic — Sun, 22 Nov 2020 16:52:53 GMT

Hi @WendyGoh

This solution is not straightforward.

When we use the crm/v3/objects/deals endpoint we can just add query parameter of &associations=contacts to get this info (Please see https://community.hubspot.com/t5/APIs-Integrations/Get-associations-with-deals-from-crm-objects-deals-endpoint/m-p/318958/highlight/true#M30600).

Please enable it with the crm/v3/objects/deals/search endpoint too.

It will be very helpful!

Re: Get associations with deals from crm objects deals search endpoint

PowerMyAnalytic — Mon, 08 Feb 2021 15:57:37 GMT

@WendyGoh jumping

Re: Get associations with deals from crm objects deals search endpoint

MFoxcroft — Tue, 27 Apr 2021 08:20:02 GMT

Hi,

What does "jumping" mean?

We are experiencing the sae challenge as listed on this post (https://community.hubspot.com/t5/APIs-Integrations/Get-associations-with-deals-from-crm-objects-deals-search/td-p/321104)

How do we bulk get associations?

Thanks

Re: Get associations with deals from crm objects deals search endpoint

PowerMyAnalytic — Wed, 01 Sep 2021 10:04:04 GMT

@WendyGoh Please reply to me.

I see that this issue is across all the Search endpoints - in the "get all" endpoint you can use query parameter of associations and in the search endpoint you can't. Why?

Re: Get associations with deals from crm objects deals search endpoint

siempeters — Mon, 04 Oct 2021 07:24:43 GMT

Exactly this!

Re: Get associations with deals from crm objects deals search endpoint

nikodev — Sat, 30 Oct 2021 12:44:16 GMT

Adding this functionality would be incredibly useful.

Re: Get associations with deals from crm objects deals search endpoint

KSoenandar — Fri, 28 Jan 2022 04:07:22 GMT

@WendyGoh - how is this still not available? If we use the /objects/deals endpoint it allows us to pull associations but it doesn't allow filtering, which means we need to do a ridiculously high number of API calls to sync with our warehouse. Conversely, if we use /objects/deals/search endpoint, we can filter but not pull associations and to pull the associations, you recommended us to use another endpoint that doesn't allow filtering. This defeats the purpose of having the search endpoint to begin with, don't you think?

Re: Get associations with deals from crm objects deals search endpoint

nikodev — Fri, 28 Jan 2022 14:28:45 GMT

Exposing the properties of the associated objects beyond the ID via the dedicated Associations API would allow for programmatic filtering of the response once it's received. Lots of paging though...although I don't recall whether or not the Associations API has pagination implemented.

Re: Get associations with deals from crm objects deals search endpoint

mmaddiona — Thu, 07 Jul 2022 06:40:06 GMT

Any news about this topic?

Re: Get associations with deals from crm objects deals search endpoint

JZwarthoed — Tue, 06 Sep 2022 09:43:53 GMT

The https://api.hubspot.com/crm/v3/associations/DEALS/CONTACTS/batch/read?hapikey={{hapiKey}} endpoint doesn't event exist in the documentation. They are all with a required objectId, while we are trying to get the associations of multiple objectIds.