CiviCRM Community Forums (archive)

I've created a custom api function : civicrm_api3_lookup_event( )

It takes two params:

$eventid   = CRM_Utils_Array::value( 'eid', $_GET, $eventid );
$membershipid   = CRM_Utils_Array::value( 'mid', $_GET, $membershipid );

and after a

  $dao = CRM_Core_DAO::executeQuery( $query );
I do one of these :
while ( $dao->fetch( ) ) {
           // echo $contactList = "$dao->count\n";
            $lookupValues[$eventid]['count']    = $dao->count;
        }

to feed :

return civicrm_api3_create_success($lookupValues);
This works, but the response I get is formatted differently than the API examples, or getContactList (which I used as a model).  I get the following as a response to my function:

<?xml version="1.0"?>
      <ResultSet xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
      <Result>
</Result>
<Result>
</Result>
<Result>
</Result>
<Result>
</Result>
<Result>
    <3>
        <count>3</count>
    </3>
</Result>
</ResultSet>
I'm currently racking my brain trying to figure out where I am hitting the XML fork in the road, or how to properly build the result array...I would really appreciate any pointers!

Thank You!

And thank the great spaghetti monster for debuggers!

I ended up manually creating a $lookupvalues array and passing it to the create_success function until it looked right.

$dao = CRM_Core_DAO::executeQuery( $query );


        while ( $dao->fetch( ) ) {

            $lookupValues[$eventid]  = $dao->count;
        }

   
    return civicrm_api3_create_success($lookupValues,$params, 'Lookup','event',$dao);
Output: Its a simple count of how many people from a given membership_id have registered for a given event_id.

{"is_error":0,"version":3,"count":1,"id":3,"values":{"3":"3"}}

Its a leeeeeedol bit redundant right now, but this query will grow.