sugarcrm icon indicating copy to clipboard operation
sugarcrm copied to clipboard

Get Activity, History for Contact

Open cypriss opened this issue 13 years ago • 2 comments

Is there a way to get the Activity and/or History for a Contact with a single API call?

Activities can include Tasks, Emails, Calls, and Meetings, and History can include Notes / Attachments + Archived Emails.

I want to make 1 or 2 calls to get this information instead of getting each thing individually. Is this possible?

cypriss avatar Apr 02 '12 20:04 cypriss

There should be, but let me tinker around a bit and see. This SEEMS similar in scope to retrieving email addresses for a given record, but I'm not sure.

FYI... Here's how we trick the REST API into giving us emails related to a record (we use a subquery). The example subquery is below:

SugarCRM.connection.get_entry_list(
  "Contacts",
  "contacts.id IN (SELECT bean_id FROM email_addr_bean_rel eabr JOIN email_addresses ea ON (eabr.email_address_id = ea.id) WHERE bean_module = 'Contacts' AND ea.email_address_caps LIKE '%SUGARCRM.COM' AND eabr.deleted=0)"
)

chicks avatar Apr 03 '12 02:04 chicks

Any update on this? I would like to retrieve all emails related to a module (the ones that show up when I click "view summary" from the history subpanel.

wutanghax0r avatar Apr 18 '13 17:04 wutanghax0r