CiviCRM Community Forums (archive)

I've been looking for hours but can't find out how to use the API to get the last modified date of a contact. The answer must be fairly straightforward as this is a pretty standard thing to output.

How would I get this data?

It seems a rather common need, but so far no easy API to access it.

Most of developers are going to be in a code sprint this week. If you plan to work on implementing the API for it, jumping on IRC would be the right moment to do it (US west coast TZ)

X+

Not sure if you are not open to sql injection (your code looks like it), and you seem to do one query per row and return all the modifications date, not only the last one (bad performance)

The easiest is probably to get the list of all the contact ids and do a single query (sort of doing a proper join in the main query).


so for api/v3/Contact.php civicrm_api3_contact_get
if the param return contains modified_date, fetch the contacts, create an array with the ids, run this query

select entity_id,max(modified_date) from civicrm_log where entity_table = 'civicrm_contact' and entity_id in (1,2,3,4,5) group by entity_id
and add the modified_date in each of the contact arrays before returning it.

X+