Hello, We wanted to create a property on our deal. Then we would like to get every deal where the last_modified_date of that property is within a range. What would be the best solution for this use case? Basically: If deal.{property}.lastmodified is between 01/12/2022 and 02/12/2022 then return the deal
Okay, I see how that works now and it is a solid solution for our current problem. So in the end there is (at least currently) no available endpoint for the v3 endpoints to get the history of properties and we would have to fall back to the v1.
Wouldn't it be possible to use the Recently Modified Deals endpoint? You will get all deals that have been modified since a certain date. You could then filter out any deals that have been modified after the second date you want to use. If you only want deals that have the custom property modified between those dates, you could still use this endpoint and filter out all deals where the custom property hasn't been modified using the timestamp param.
What programming language are you using?
Learn more about HubSpot by following me on LinkedIn or YouTube
✅ Did my answer solve your issue? Help the community by marking it as the solution.
I don't think there is a very elegant way of doing this...I could be totally wrong so including @Teun to keep me honest.
The best way I can think is to create a webhook that subscribes to that custom property and add the record to a database that you would later filter through..
Could be totally wrong here, but that is where my head is going 🤣