CiviCRM Community Forums (archive)

I am not able to find how to pull website/url value for a contact.  I have several urls associated with each contact (ie. facebook, youtube, etc).

How do I get these?  I assumed it would be be: return.website, but that doesn't work.

Is there a list of variable names somewhere?

website values are stored in a table called civicrm_website

I've tried with location, but can't get anything to work.

Any other ideas?  I assume it is through another API.

Is there a list of variables and APIs somewhere?

Starting writing this before Erik posted but I think it still applies if you are stuck with v2


I think the website BAO changed recently & got ahead of the api on this - we will need a website api soon-ish.

I expect however, that it will be implemented against v3 which will be in release 3.4 but if you're not using that you might need to just do an SQL query for now or implement your own

This is a function I use in v2 for get - you really only need to swap out option group  for the right entity & you have it working. This example doesn't take an array because of the instance I was using it in

function civicrm_helpers_get_optiongroup($optiongroup){
try {
 $params['name'] = $optiongroup ;
  _civicrm_initialize( true );
       require_once 'api/v2/utils.php';
    civicrm_verify_mandatory($params);
    require_once 'CRM/Core/BAO/OptionGroup.php';
    $optionGroupBAO = new CRM_Core_BAO_OptionGroup();
    $fields = array_keys($optionGroupBAO->fields());

    foreach ( $fields as $name) {
        if (array_key_exists($name, $params)) {
            $optionGroupBAO->$name = $params[$name];
        }
    }
   
    if ( $optionGroupBAO->find() ) {
      $results = array();
      while ( $optionGroupBAO->fetch() ) {
        _civicrm_object_to_array( $optionGroupBAO, $result );
        $results[$optionGroupBAO->id] = $result;
      }
      return civicrm_create_success($results,$params,$optionGroupBAO);
    } else {
      return civicrm_create_success(array(),$params,$optionGroupBAO);
    }

  } catch (PEAR_Exception $e) {
    return civicrm_create_error( $e->getMessage() );
  } catch (Exception $e) {
    return civicrm_create_error( $e->getMessage() );
  }
  }

Hi,

Really, writting the API you miss is a couple of lines more and should be more future proof than going the SQL way (hopefully . Contributors welcome...

Otherwise, general sql trick: one single select ... with contact_id in implode (',', $arrayofid) is much faster than one select per id. Probably doesn't make a big difference when you got a handful, but I'm on a quest to diminish the number of sql requests generated

I will try with the API first and see if I can get it to work.  Since I am an API newbie, it might take me a little while.  The SQL is appealing, mainly because I have tons of experience with that, but I prefer keeping things consistent, as it will be easier to upgrade when the time comes.