I'm attempting to query hubspot from a clay table to see if a contact already exists using email address as the identifier. We heavily use hubspot where under the email property you can have a primary email address and additional email addresses. When I use the hubspot lookup object function the only thing that is being queried is the primary email address. Does anyone know how to query the additional email address fields?
In salesforce I would do this with an SOQL query, but hubspot doesn't have that option it doesn't seem.