Chad Lancour

@briansloane It hate to say it, but this is a major flaw in this tap. I know Hubspot is not making it easy for anyone to work with their api...

doh! I was just going to fire up the hubspot integration on Stitch Data Loader.... to specifically query deal property history via bigquery. Darn it. @caitlinmoorman Are you using Stitch...

@caitlinmoorman lol. Specifically date entering a specific stage is what we want. That's good to know. I'll fire up the stitch for now as date entered stages is the ask....

The core is that we want to be able to query the history of any property... so yeah.... &includePropertyVersions=True. Sort of frustrating over the last 2 years using stitch primarily...

@caitlinmoorman So, looking at the code... They are using the get_all_deals endpoint: https://developers.hubspot.com/docs/methods/deals/get-all-deals Read this thread as well: https://community.hubspot.com/t5/APIs-Integrations/Deals-Endpoint-Returning-414/td-p/320123 Stitch is now using the undocumented allPropertiesFetchMode=latest_version parameter per hubspot's recommendation.

@caitlinmoorman To get what you (we) need... the allPropertiesFetchMode needs to be set to 'all_versions'. I've confirmed this works via postman api call.

+1

@ataylorme Thx for the response Andrew. In fact, we are currently working with Scott Page on enterprise pricing. We will probably get into contract Dec/Jan. Until we are using Basic...