Author Topic: api call to get 'date added' (Read 459 times)

pike67 · December 04, 2012, 04:31:28 am

Hi

could somewhere give a (link to an) example of an api call to get the date a contact was added, or even better, the date a contact was added to a group ?

I need to do this for > 100 records, so a list call (contact.get or groupcontact.get) would be ideal.

thanks,
*-pike

totten · December 04, 2012, 04:50:58 pm

I'm not sure about an API call for that. In the next big release (Civi 4.3), the 'contact' API might return a field called "created_date." In most Civi versions versions, the SQL for determining the creation of a contact would be something like:

Code: [Select]

select min(modified_date) from civicrm_log where entity_type = 'civicrm_contact' and entity_id = 123;

For the date that someone was added to a group, you might look at the SQL table "civicrm_subscription_history".

CiviCRM Community Forums (archive)

News:

Author Topic: api call to get 'date added' (Read 459 times)

pike67

api call to get 'date added'

totten

Re: api call to get 'date added'