Summary
Airbyte (self-hosted) is not capturing some changes in dealstage values between deals_properties_history and deals stream from Hubspot. Approximately 100 deals out of 3000+ have mismatched stages. User seeks advice on resolving this issue and recommendations on correctly utilizing Hubspot history tables.
Question
Hi there
We’re using Airbyte (self-hosted) to extract data from our Husbpot instance (private app connection method). The connection runs every two hours.
I am comparing the latest dealstage
available for any given deal in the deals_properties_history
stream against the dealstage
value in the deals
stream. There are approx. 100 deals (out or 3000+) for which the stages do not match. It seems that the deals_properties_history
does not catch some changes (see screenshot of our Hubspot Instance versus the extracted table for the same deal, filtered on dealstage
property).
My questions are:
• Have any of you experienced a similar issue? If yes, did you resolve it and how?
• We rely a lot on the hubspot history tables, what do you recommend to use them correctly ?
Any help will be greatly appreciated!
Thank in advance
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.