Getting Error [400] when trying to fetch deals by ownerID and contact emails

Developer Support APIs & Integrations
1 
import hubspot
from pprint import pprint
from hubspot.crm.deals import PublicObjectSearchRequest, ApiException

client = hubspot.Client.create(access_token="<KEY>")

public_object_search_request = PublicObjectSearchRequest(filter_groups=[{"filters":[{"value":"<OWNER_ID>","propertyName":"hubspot_owner_id","operator":"EQ"},{"values":["john_doe@test.com"],"propertyName":"associations.contact.email","operator":"IN"}]}], limit=10, after=0)
try:
 api_response = client.crm.deals.search_api.do_search(public_object_search_request=public_object_search_request)
 pprint(api_response)
except ApiException as e:
 print("Exception when calling search_api->do_search: %s\n" % e)
2

Hi @piyushgoyal ,

I’m not sure you can search through associated object properties, it seems that you can only search for the associated contact ID.

This works;

{
 "filterGroups": [
 {
 "filters": [
 {
 "propertyName": "hubspot_owner_id",
 "operator": "EQ",
 "value": "<OWNER_ID>"
 },
 {
 "propertyName": "associations.contact",
 "operator": "IN",
 "values": ["<CONTACT_ID>"]
 }
 ]
 }
 ],
 "properties": ["dealname"]
}

While trying to access `associations.contact.email` doesn’t.