Issue with NULL and duplicate fields in properties object from Hubspot ingestion

Slack Knowledge Base Q&A Connector Questions
, , , ,
1

Summary

The user is experiencing an issue where NULL and duplicate fields are being added to the properties object while ingesting data from Hubspot to Airbyte, causing the sync to be too large to process.


Question

Hi all, I am trying to understand why so many NULL or duplicate fields are being added to the properties object I am ingesting from Hubspot. These are not fields present for the object in Hubspot, yet are being ingested by Airbyte, therefore making the sync too large to process. Does anyone know why this is?


This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want to access the original thread.

Join the conversation on Slack

["null-fields", "duplicate-fields", "hubspot", "ingestion", "sync", "airbyte"]
2

I see in Hubspot’s API docs https://developers.hubspot.com/docs/api/crm/companies|here that you need to specify the name of the properties that you wish to return. Since the user doesn’t do that in the syncs, how is Airbyte pulling these properties to be returned in the GET request against the API?