Integration Package Errors

  • 42Views
  • Last Post 2 weeks ago
0
votes
Cameron Bennett posted this 4 weeks ago

Hello -  I have an integration package between a CSV file on an FTP site and Hubspot.  The key field is Email Address and I continue to get errors on my runs.  Of the 7000 or so records about 800 of them continue to error.  In looking at the report the email addresses are actually valid.  And when I look the record up in Hubspot it exists.  Why am I getting errors?  Is there more detail that can be shared on what exactly the error is?

 

Thank you!

Cam

Order By: Standard | Newest | Votes
0
votes
Simon Bubnov posted this 3 weeks ago

Your account be***@gmail.com has only one package and it wasn't run for 4 months.
Tell us the package number. When you open your package, the number of the package will be available in the package URL.

0
votes
Cameron Bennett posted this 3 weeks ago

I apologize.  This package is actually under a different account.  alex.martin@cbiz.com.  https://app.skyvia.com/#/packages/54906 

0
votes
Pavel Triapsha posted this 3 weeks ago

Hello Cam,

Answering your question:

> Why am I getting errors?  Is there more detail that can be shared on what exactly the error is?

When the error appears there can be the following: 

1. If it is a record-level error(records fail for some reason: unique constraint violation, lookup fails etc.), as in your case, the information about failed records with error message texts is added to an error log. This per-record error log can be downloaded by clicking the corresponding package run in the Run History and then clicking the number of failed rows for a table.

For more information, please refer to https://skyvia.com/resources/docs/index.html?error_processing.htm

2. If it is a package-level error (package execution fails: connection issue, source error etc.), there will be no log file, and no successful record count or error record count. Instead, the error text is displayed, which explains why the package run failed. So, in this case, you can find the corresponding run in Run History and see the error text

 

Regards,

Pavel

 

0
votes
Cameron Bennett posted this 3 weeks ago

Hi Pavel -

The errors I am getting are at the record level.  When I download the results they are hard to read but as I understand it the email address was determined to be invalid.  However, when I look at the email addresses they are perfectly formatted.  Is there a way to get more detail on this?  Or figure out why they would be failing?

Thanks!

Cam

0
votes
Pavel Triapsha posted this 3 weeks ago

Hi Cam,

This issue occurs on the HubSpot side and doesn't relate to Skyvia. 

HubSpot automatically validates email addresses formats as they are entered in your HubSpot 'Contacts'. In case of an error, it submits that address could be a fake or outdated.

You may also check up any kind of misspelling in the field, like preceding space. 

Refer to the articles below for the additional details: 

https://developers.hubspot.com/docs/faq/how-does-hubspot-validate-email-addresses

 

https://knowledge.hubspot.com/articles/KCS_Article/Forms/How-can-I-prevent-people-from-submitting-a-form-using-certain-email-domains

Regards,

Pavel

0
votes
Cameron Bennett posted this 3 weeks ago

Thanks Pavel.  That's helpful...however please look at the email addresses in this failure report. https://netorgft2738475-my.sharepoint.com/:xg/personal/cam_hivegroup_nyc/EXUl9RKJxkhFvRZ0ECWYZUIBqh5hIMNJlJjGTuNAHGVEJg?e=qehdIu 

 

They all seem to be valid.  Is there one row that is breaking the rest?  The failure report from Skyvia seems to repeat the same row numbers for every record.

 

0
votes
Cameron Bennett posted this 3 weeks ago

That was an old error report.  This is the most recent one where I cannot find the errors in the data - https://netorgft2738475-my.sharepoint.com/:xg/personal/cam_hivegroup_nyc/EXUl9RKJxkhFvRZ0ECWYZUIBqh5hIMNJlJjGTuNAHGVEJg?e=Fi9xlX 

0
votes
Pavel Triapsha posted this 3 weeks ago

Cam,

Thank you for the reply.

Could you please resend the URL as an active link. Looks like It evaluated some symbols in the URL address like 'emoji smile', so I can not open it.

Just simply select the URL and click 'Insert/edit link' in the panel above the text input field. And past URL text to the Url field in the opened window.

Regards,

 

Pavel

0
votes
0
votes
Pavel Triapsha posted this 3 weeks ago

Cam, 

I still cannot access your page. Getting error "Sorry, something went wrong. An unexpected error has occurred."

Looks like I have no access due to some Sharepoint restrictions.

If possible, make a screenshot or attach a CSV file with the error.

Regards,

Pavel

0
votes
Cameron Bennett posted this 3 weeks ago

Here is a screenshot of the errors.. The email addresses are all perfectly formatted. And I dont understand why they are all getting identified as the same Row.

0
votes
Pavel Triapsha posted this 2 weeks ago

Hi,

 

Thank you for the provided details.

Skyvia works with Hubspot via API. When email looks valid and the new contact can be properly created with it in Hubspot GUI. The same contact created via API request will throw an exception on the email.

One of the reasons could be the following: Any addresses that are recognized as bounced from HubSpot servers as the result of the previous email send from other HubSpot users will automatically be marked as such.

 

The primary key for a contact in the HubSpot system is an email address. So the API automatically de-duplicates on the email address to assure data cleanliness inside of HubSpot. Nevertheless, it's possible to create contacts without an email address by leaving out the email property. This is true for creating a single account, but Skyvia uses Batch API (and creates a batch of accounts at a time). It means that in our case, each record must include an email address. 

 

As I mentioned before, this is a well known Hubspot feature.

Please refer to the Hubspot forum for the workaround or make a request to the Hubspot support:

https://community.hubspot.com/t5/Dashboards-Reporting/Invalid-email-address/td-p/7517

 

Best regards,

Pavel

Close