How to get contacts by phone, address, website or email

[pminf]

I'm trying to get contacts which are related to a certain phone number, address, website or email id.

I've tried the following requests with no success:

Code: [Select]

$result = civicrm_api3('Contact', 'get', array(
    'sequential' => 1,
    'api.Phone.get' => array('id' => "90")
 ));


Code: [Select]

$result = civicrm_api3('Contact', 'get', array(
    'sequential' => 1,
    'phone_id' => 90
 ));


Code: [Select]

$result = civicrm_api3('Contact', 'get', array(
    'sequential' => 1,
    'phone' => 90
 ));

The parameters regarding phone seem to be ignored and the result contains 25 contacts, which don't necessary have the phone_id 90.

Any idea how to accomplish this?

[xavier]

Weird, I thought the api.contact.get filters on phone.

One way/workaround is to fetch the phone first, then contacts. When you fetch contacts, it's good practice to specify what fields you want (return="first_name,last_name,...")

Code: [Select]

$result = civicrm_api3('Phone', 'get', array(
    id' => "90",
    'sequential' => 1,
    'api.Contact.get' => array('return' => "stuff n more")
 ));

[pminf]

Thanks for the workaround. I will give it a try and report back

[Coleman Watts]

I believe the contact api filters on phone number, not phone id. If you want to fetch phones/addresses/emails by their id, then X is correct you need to use the phone/address/email apis.

[pminf]

Weird, I thought the api.contact.get filters on phone.

One way/workaround is to fetch the phone first, then contacts. When you fetch contacts, it's good practice to specify what fields you want (return="first_name,last_name,...")

Code: [Select]

$result = civicrm_api3('Phone', 'get', array(
    id' => "90",
    'sequential' => 1,
    'api.Contact.get' => array('return' => "stuff n more")
 ));

Same here: the result contains 25 "related" contacts, which don't necessary have the phone id 90

[johanv]

You might want to try

Code: [Select]

$result = civicrm_api3('Phone', 'get', array(
    id' => "90",
    'sequential' => 1,
    'api.Contact.get' => array('id' => "\$value.contact_id"),
 ));