Hi All,
We have sync an integration between firepath and HubSpot (a private app). But the system is failing to consume the data feed. We identified that there is a contact with an erroneous email address [email 1] which HubSpot identified as an invalid email format.
The correct email is [email 2]
But This caused the entire data feed to fail.
Is this a normal behavior? as it means that very minor data quality issues on single data point are collapsing the entire data feed?
Do you have any recommendations?
Hi @RMazzucchelli7,
Assuming your are using the Batch endpoint for Contacts, then, yes, it is a known issue - see a couple of community threads about this below:
https://community.hubspot.com/t5/APIs-Integrations/Companies-and-contacts-batch-create-update-issue/m-p/983722
https://community.hubspot.com/t5/APIs-Integrations/Partial-Commit-of-Contacts-Batch/m-p/689070
A few possible solutions would be:
- use the CRM Imports API - though this would require using a file
- instead of the batch endpoint, use the basic endpoint for each record and keep looping
- have a step to ensure data quality before trying to send to HubSpot
Not ideal, but that is the current situation.
Hope this helps
Hi @RMazzucchelli7,
As per my recommendation, you should skip the email property data in case of an email validation error. HubSpot also allows creating a record without an email. If you still want to store the invalid email, you can use a separate input field to capture it. For this, please use the basic (single-record) API instead of the batch API, as it will be easier to handle email validation logic.