Source Hubspot - Unable to get data history

[gab]

• Source name: Hubspot
• Destination name/version: Postgres db
  We have a working connection with Hubspot and our db to get the properties data. However we are not getting the other part of the data called PropertiesWithHistory.

Is there something I can do to get this to upload too or should I make my custom connector to get this data?

Steps to see the property:

1. The Hubspot documention on Airbyte website. HubSpot | Airbyte Documentation

2. Selecting “Companies” will lead you to the Hubspot documentation https://developers.hubspot.com/docs/api/crm/companies

3. Select the endpoints tab and scroll down to find the PropertiesWithHistory.
   

   

From my understanding of the documentation we can pull that data from Hubspot and I have tried it in postman. But I dont see it when im trying to use Airbyte to pull the data. I only get the properties option.

[sajarin]

Hey @gab,

Thanks for the question and welcome to the community! It seems like the hubspot connector doesn’t fetch the propertiesWithHistory value from the API based on the schema that the connector uses for the Companies stream: https://github.com/airbytehq/airbyte/blob/master/airbyte-integrations/connectors/source-hubspot/source_hubspot/schemas/companies.json

Your best bet might be to modify the schema file and build a new version of the connector and see if you can fetch the data you need. If you’re willing to go a step further, we’d love to update our connector with your proposed changes so that other folks have access to the attribute in the future too. Let me know if this helps!

[gab]

Thank you very much for the reply and I will start working on the new connector