topic Re: How to get associations in the search API endpoints in APIs & Integrations

How to get associations in the search API endpoints

RajeshGembrill — Thu, 01 Dec 2022 13:15:39 GMT

We are trying to fetch the filter tasks data in that we additionally required contact association. It is very hard to fetch the associated object by using many API calls which is very costly. Please suggest the possibilities ASAP.
Thanks In Advance

Re: How to get associations in the search API endpoints

Jaycee_Lewis — Thu, 01 Dec 2022 20:23:24 GMT

Hi, @RajeshGembrill 👋 Have you already looked into using the pseudo-property associations? Here is the documentation — Search through associations.

Best,

Jaycee

Re: How to get associations in the search API endpoints

RajeshGembrill — Mon, 05 Dec 2022 13:20:11 GMT

Hi, @Jaycee_Lewis

Thanks for the reply.
The documentation which you shared says, to use associations for filters. But my requirement is to get association details in response data.

Thanks In Advance,
Rajesh Kumar.A

Re: How to get associations in the search API endpoints

COSmith — Mon, 27 Feb 2023 10:30:21 GMT

Hi @Jaycee_Lewis - can you please reopen this issue - this is not an acceptable solution.

The requirement is to return associations information in the response body, not to filter by them.

I am trying to return contact information for the `ticket` objects via the search api and cannot do so. This is a major defect in your API and makes having this endpoint completely useless. Please can you address this ASAP?

request_type = 'POST'
url = 'https://api.hubapi.com/crm/v3/objects/ticket/search'
header = {"authorization": "Bearer ", "content-type": "application/json"}
data = {
"properties": [
"hubspot_owner_id",
"hs_pipeline",
"category",
"hs_ticket_category",
"content",
"hs_submission_name",
"source_type",
"associations.contact.id"
],
"limit":100,
"filterGroups": [{"filters":[{"propertyName":"source_type","operator":"EQ","value":"CHAT"}]}]
}

Re: How to get associations in the search API endpoints

tclark228 — Tue, 21 Mar 2023 00:41:45 GMT

Hi @RajeshGembrill , @iCos did either of you ever find a way to do this?

Re: How to get associations in the search API endpoints

Anonymous — Fri, 24 Mar 2023 13:04:10 GMT

I'm facing the same problem. I need the companies associations to be returned in the response when searching through contacts. Is this possible on the search API?

Re: How to get associations in the search API endpoints

KTefft — Wed, 29 Mar 2023 16:46:41 GMT

The accepted solution needs to address the issue. Are there any plans to add this functionality?

Re: How to get associations in the search API endpoints

FSoto8 — Thu, 30 Mar 2023 13:27:34 GMT

please create an issue with this.

Re: How to get associations in the search API endpoints

FSoto8 — Thu, 30 Mar 2023 13:27:58 GMT

please create an issue post to hubspot fix this.

Re: How to get associations in the search API endpoints

FSoto8 — Thu, 30 Mar 2023 13:28:29 GMT

please create an issue to hubspot fix this.

Re: How to get associations in the search API endpoints

FSoto8 — Thu, 30 Mar 2023 13:29:12 GMT

reopen this, because hubspot api dont response correctly.

Re: How to get associations in the search API endpoints

gdforj — Mon, 03 Jul 2023 16:58:30 GMT

Hi,

In the current state, the search API does not yield the associations.

One has to make additional requests per each found object to get its associations.

This results in a much bigger number of requests, which can run into the API rate limitations very quickly.

In order for the API to be effective and useful, it needs to return the associations directly in the search response.

Could we get some visibility to when this issue will be resolved? This is quite important to integrate HubSpot reliably to other softwares.

Re: How to get associations in the search API endpoints

snehal268 — Mon, 14 Aug 2023 05:42:30 GMT

Hey @Jaycee_Lewis ,

Can we get the association records in repose data in Search API? Why Search API dose not support associations as parameter?

Regards,

Snehal

Re: How to get associations in the search API endpoints

snehal268 — Mon, 14 Aug 2023 05:43:21 GMT

Hey @Jaycee_Lewis

Can we get the association records in repose data in Search API? Why Search API dose does not support associations as parameters?

Re: How to get associations in the search API endpoints

ISlonim — Tue, 14 Nov 2023 17:53:07 GMT

Any news on this? running into the same issue, and this is impacting a lot of hubspot customers who already have an issue with the limited CPQ capabalities and are considering switching to a different platform -

@Jaycee_Lewis

Re: How to get associations in the search API endpoints

aravet — Wed, 22 Nov 2023 13:28:56 GMT

Hello,

Yes i'm running in the same issue. Would be really usefull to get that functionnaly ! Any news on that ? @Jaycee_Lewis

Thanks,
Antoine,

Re: How to get associations in the search API endpoints

CichociemnyKuba — Thu, 25 Apr 2024 15:36:47 GMT

Hi, any updates?

It's really harmful that we can't get associations for deals via SearchAPI...

EDIT: I've created an Idea to add this feature. Please upvote if you are interested https://community.hubspot.com/t5/HubSpot-Ideas/Retrieving-Associated-IDs-via-HubSpot-APIv3-SearchAPI/idi-p/966730

Re: How to get associations in the search API endpoints

FVogel5 — Tue, 11 Jun 2024 16:46:50 GMT

as gdforj said, im running into rate limitations if i have to query each response from the search api.
I'm honestly considering getting all deals and filter them myself (which makes the search endpoint useless) in order to get associations on the api response

is there a ticket i can upvote or anything of the sorts? is there any plan to fix this in the near future?

Re: How to get associations in the search API endpoints

IvanTriplewhale — Mon, 28 Oct 2024 09:10:32 GMT

Any news here ? Still no support for this in Node sdk 12.0.1