We are syncing the HS database with an offline database via the API. We are using the recently updated api. Which works ok - except:
1.) I cannot filter for just new customers. I need to get all customers with a recent createdate or lastmodifieddate.
2.) The problem with that is that the lastmodifieddate - as far as I can tell - updates under many circumstances. The most common one seems to be upon the receipt of an email. So in a given day there may be 80,000 to 100,000 total “updates” that I have to sort through to get any new customers.
3) We also with to identify anybody that’s modified their contact data - such as name or address,e tc. Is there a way to filter for customer-generated modifications as opposed to analytic stuff? Even if the email sent/delivered could be separated from this field.
I am trying as best as I can to not have to pull down tens of thousands of records…
I have seen some suggestions on doing this by creating a list. But I’d rather be able to use the customer object and API only if possible.
I guess any best practice recommendations here would help.