Hi,
I search contacts with /crm/v3/objects/contacts/search
{
“limit”: 100,
“properties”: [“hubspot_owner_id”,“address”,“zip”,“city”,“country”,“website”,“ansprechpartner_id”,“salutation”,“email”,“fax”,“mobilephone”,“phone”,“firstname”,“lastname”,“c_entron_kundennummer”,“c_entron_export”],
“after”:0,
“filterGroups”:
[
{
“filters”:
[
{
“propertyName”: “email”,
“operator”: “IN”,
“values”: [“l.test@trialta.de”]
}
]
}
]
}
and get an
{
“total”: 0,
“results”: []
}
even if the contacht has two mails in field email.
Additional emails aren’t stored in the email field but in the hs_additional_emails field. You can just add another OR filter so it searches for both fields:
{
"limit": 100,
"properties": ["hubspot_owner_id","address","zip","city","country","website","ansprechpartner_id","salutation","email","fax","mobilephone","phone","firstname","lastname","c_entron_kundennummer","c_entron_export"],
"after":0,
"filterGroups":
[
{
"filters":
[
{
"propertyName": "email",
"operator": "IN",
"values": ["l.test@trialta.de"]
}
],
"filters":
[
{
"propertyName": "hs_additional_emails",
"operator": "IN",
"values": ["l.test@trialta.de"]
}
]
}
]
}
