topic Re: get recently modified contacts without certain properties in APIs & Integrations

get recently modified contacts without certain properties

Frapsi — Fri, 18 Sep 2020 13:43:32 GMT

I want to get recently modified contacts via Hubspot API.

But, what makes it a little bit difficult is that we are using the Salesforce-Sync and therefore one certain contact property will be updated very often as it stores the last sync time. So I am only interested in the modified contacts where one of the other properties was changed.

Is that somehow feasible?

I think I can only use the endpoint from version 1 (/contacts/v1/lists/recently_updated/contacts/recent) but I am not sure whether the optional parameters cover that functionality.

Re: get recently modified contacts without certain properties

dennisedson — Mon, 21 Sep 2020 18:33:02 GMT

Hey @Frapsi ,

Thanks for posting!

To sum up the need

You want to filter out the timestamp and get only contacts where another property has been modified. Are you concerned with any specific properties or all other properties?

@Hanta , @malcolm1, @adiehl do any of you all have thoughts on this?

Thanks!

Re: get recently modified contacts without certain properties

malcolm1 — Tue, 22 Sep 2020 02:36:42 GMT

You are looking for a query ability something like this, using birthday as an example here:

SELECT first_name,last_name FROM contacts WHERE birthday_last_modified_on > "2020/08/25"

Unfortunately we don't have this ability. Instead we have to locate recently changed records then start looping through the property list looking at the properties we are interested in. Assuming that we can easily find recently modified contacts, how are you going to know when a value has changed?

If the value was a default property then you should be able to look at the "versions" array for that property.

Do custom properties have versions? It's not obvious from the documents that they do. So for custom properties you would need to track changes yourself.

Re: get recently modified contacts without certain properties

Frapsi — Tue, 22 Sep 2020 05:47:07 GMT

Hi @dennisedson & @malcolm1 ,

thanks for your answers. You both understood my problem correctly 🙂

As @malcolm1 said, I can locate recently changed records with one of the given api endpoints and then start looping through the property list to find the ones that have been changed. But as contacts get synced with Salesforce and therefore one of the custom properties (salesforse_last_sync) will change (almost) every day, this endpoint is useless for me. It will return an immensely large number of contacts and take too much time to identify only contacts where another property has been modified.

@dennisedson : It would be nice to have the ability to request only changes for certain properties (default and custom properties), but it would already help me to exclude this one 😉

Thanks for your help

Re: get recently modified contacts without certain properties

malcolm1 — Tue, 22 Sep 2020 05:54:19 GMT

You mentioned the "S*F*" word in the orginal message.

I'm sorry for your pain.

I have to deal with an app based on "S*F*" every day and I can tell you that I think it is a "S*F*" platform.