Hello!
I’m using the API version 3 to get the deals data from this document: Accounts Dashboard | HubSpot. The endpoint used is /crm/v3/objects/deals because we need the historic information from some properties.
My question is: How can we make an incremental process to ingest data using this endpoint ? The only pagination parameter that I have seen is “after”. But it’s not clear for me what is the best way to use it.
Is there a way to filter some date in this endpoint using timestamp or another way? For example, get only the deals data from 24hrs before… I’m questioning this because if we don`t have this parameter I will need to read all historic data every time I need to integrate historic deals information…
Hi, @AlineGuerreiro
Have you checked out the Search API? You can search by an object as well as use operators in a filter. For example, you can use the BETWEEN operator to search for all tasks that were last modified within a specific time range.
Best,
Jaycee
Hi, @Jaycee_Lewis !
Thanks for the hint, but I have another question.
We are developing the historical data in this structure of fields: ‘id’,‘value’,‘metric’,‘sourceId’,‘sourceType’,‘timestamp’,‘updatedByUserId’, using the crm/v3/objects/deals endpoint using propertiesWithHistory parameter. When we did the request for current data (in the same endpoint or in search endpoint, without use propertiesWithHistory parameter), we can’t find these fields ‘sourceId’,‘sourceType’,‘timestamp’,‘updatedByUserId’.
How can we get these information incrementally? Is it possible?