CiviCRM Community Forums (archive)

Is it currently possible to use criteria other than '=' for a get api?

On my (still in BETA) pledge api I tried

      require_once 'api/v2/Pledge.php';
        $pledgeparams = array('contact_id' => $params['contact_id'],
                            'version' => '3.0',
                            'pledge_status_id' = 2
     
       
        );
      $results = civicrm_pledge_get($pledgeparams);
All good

But I could find any evidence of how to get the pledges with status IN(2,5,6) or the equivalent for any existing api.

The code I have been working with here is based heavily on the contribute api so it's not much different to the existing apis


function &civicrm_pledge_get( &$params ) {
    _civicrm_initialize( );
    if ( ! is_array( $params ) ) {
        return civicrm_create_error( ts( 'Input parameters is not an array' ) );
    }

    $inputParams      = array( );
    $returnProperties = array( );
    $otherVars = array( 'sort', 'offset', 'rowCount' );
   
    $sort     = null;
    $offset   = 0;
    $rowCount = 25;
    foreach ( $params as $n => $v ) {
        if ( substr( $n, 0, 7 ) == 'return.' ) {
            $returnProperties[ substr( $n, 7 ) ] = $v;
        } elseif ( in_array( $n, $otherVars ) ) {
            $$n = $v;
        } else {
            $inputParams[$n] = $v;
        }
    }
   
    // add is_test to the clause if not present
    if ( ! array_key_exists( 'pledge_test', $inputParams ) ) {
        $inputParams['pledge_test'] = 0;
    }

    require_once 'CRM/Pledge/BAO/Query.php';
    require_once 'CRM/Contact/BAO/Query.php';
    if ( empty( $returnProperties ) ) {
        $returnProperties = CRM_Pledge_BAO_Query::defaultReturnProperties( CRM_Contact_BAO_Query::MODE_PLEDGE );
    }
   
    $newParams =& CRM_Contact_BAO_Query::convertFormValues( $inputParams );

    $query = new CRM_Contact_BAO_Query( $newParams, $returnProperties, null );
    list( $select, $from, $where ) = $query->query( );
   
    $sql = "$select $from $where"; 

    if ( ! empty( $sort ) ) {
        $sql .= " ORDER BY $sort ";
    }
    $sql .= " LIMIT $offset, $rowCount ";
    $dao =& CRM_Core_DAO::executeQuery( $sql );
   
    $pledge = array( );
    while ( $dao->fetch( ) ) {
        $pledge[$dao->pledge_id] = $query->store( $dao );
    }
    $dao->free( );
   
    return $pledge;
}

Ah - OK - will try an array - didn't think of that or find it in any examples

I know you can receive arrays through REST, but I am not sure if you can send them. In my project I tend to bring them down to a single entity. So rather than using a location_createwith possibly a number of arrays I have created a specific phone_create, email_create and address_create.
Erik