APIs & Integrations

VJagadale
Participant

How to get Contacts Delta Load (Incremental) data based on value of lastmodifieddate

Hello,


Instead of fetching all Contacts data using the below API endpoint

https://api.hubapi.com/contacts/v1/lists/all/contacts/all

Is it possible to get only Delta Load (Incremental - Created/Updated) data based on the value of the field lastmodifieddate by passing it as a query parameter?


In Documentation, there is below API call that returns created/updated contacts of the last 30 Days.

https://api.hubapi.com/contacts/v1/lists/recently_updated/contacts/recent


What I want to get is records that are created/updated after a specific custom date
So something like, 
https://api.hubapi.com/contacts/v1/?lastmodifieddate>=1651363200

0 Votes
3 Réponses
dennisedson
Équipe de développement de HubSpot
Équipe de développement de HubSpot

How to get Contacts Delta Load (Incremental) data based on value of lastmodifieddate

@VJagadale 

Might be worth exploring the Search the CRM API 

 

VJagadale
Participant

How to get Contacts Delta Load (Incremental) data based on value of lastmodifieddate

Hello @dennisedson Thanks for the reply. 
I am now able to use V3 endpoint to get Incremental Data, But with V3 endpoint I am not getting values from  "identity-profiles" array,  like LEAD_GUID, with V1 endpoint Incremental is not working but I am getting above property.

I checked the link https://developers.hubspot.com/docs/api/crm/search#specify-returned-properties but still couldn't find anything for "identity-profiles"


Currently what I am using for Incremental Load is as below, just need to know how I can include fields from "identity-profiles"



POST: https://api.hubapi.com/crm/v3/objects/contacts/search?&after=

Request BODY:

{
"filterGroups": [
{
"filters": [
{
"propertyName": "lastmodifieddate",
"operator": "GTE",
"value": "1651363200000"
}
]
}
],
"properties": ["company","createdate","email","firstname","lastname"],
"limit": 2,
"after": 0
}


 

0 Votes
Andrew18
Participant

How to get Contacts Delta Load (Incremental) data based on value of lastmodifieddate

I have been using the search for incremental load, however I also need to get associations for the objects I am retrieving.  The API appears to only be able to do this one by one (or use pseudo-properties to search for objects linked to a specific object).

Has anyone got a simple way to retrieve, for example, all tasks created since a particular date-time AND the deals they are associated to?

0 Votes