Source Hubspot: add new stream historical properties

[marcosmarxm]

Tell us about the problem you're trying to solve

From slack convo:

Hi Airbyte Folks, I had a quick question: Does your HubSpot integration pull in historical properties, historical events, and historical deal-stage change? For example if I am building an analytics app for HubSpot, I’d like to pull in a customer’s entire history of events and deal stage changes, up to the current date. And going forward I would want to update this history incrementally (as long as the API allows, otherwise it would be pulled from scratch each time). Thanks

There is some endpoints Airbyte doesn't ingest data from Hubspot
https://knowledge.hubspot.com/crm-setup/view-property-history

Describe the solution you’d like

A clear and concise description of what you want to see happen, or the change you would like to see

Describe the alternative you’ve considered or used

A clear and concise description of any alternative solutions or features you've considered or are using today.

Additional context

Add any other context or screenshots about the feature request here.

Are you willing to submit a PR?

Remove this with your answer :-)

[marcosmarxm]

Added in #7787

[thijs-blom]

I'm also interested in the feature described in the main post of this issue. As far as I can tell however, it is not added in #7787? The property_history stream defined there only covers contacts, pulled from the endpoint https://legacydocs.hubspot.com/docs/methods/contacts/get_contacts.

The current hs_date_entered_* and hs_date_exited_* properties in the (deal) properties also cannot be relied upon, and are meant for internal HubSpot purposes (see here for example).

History of properties in HubSpot is available for all objects in the CRM v3 HubSpot API, such as deals, tickets, companies, and contacts through the propertiesWithHistory parameter.

I am willing to create a PR for a (separate) stream to include the history of these properties.
Would it be possible to re-open this issue?