HubSpot Community - Data feed & Sync via API - HubSpot Community

[RMazzucchelli7]

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? 

[mohdisrarmwb]

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.

[evaldas]

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/...

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