Update Date_Modified Field Using APIs

Ashley Sanchez

Greetings,


We have found approximately 8,000 individual constituents without Date_Modified dates that we would like to have populated. We were able to determine that adding Constituent Codes does add/update the the Date_Modified date but only when the changes are made within the UI and not through the POST Constituent Code API. Are there any APIs that we may use that would result in the Constituent Date_Modified field to be updated? We have also tried updating fields such as Title_2 and Deceased but didn't see any changes to the Date_Modified field.


Thank you,

Ashley

Dineshkumar R

Due to the missing Date_Modified field value, these constituent ids are not returned from Constituent List API but are returned from the Constituent Single API. We are now encountering Call Quota limit error since we need are retrieving 8K records and had to rerun the process couple of times. Is there an easier way to update the empty Date_Modified field to resolve this issue?

Anthony Gallo

Hey Everyone,


We looked into this one and we agree that any update to the constituent record should update this value. We will address this one as a bug on our side as soon as we can get to it. In the meantime we should be able to write a SQL statement to get this updated while we resolve the issue. I would reach out to the support folks and they can send a ticket with the details our way.


Anthony

Anthony Gallo

Just to update here.

We looked into this a bit further and the date_modified field comes from a sync with lists. This is not an API field that returns the last date changed info from DB view, it is the value stored in the lists field. If that sync has not happened yet, that field will most certainly be blank.