CiviCRM Community Forums (archive)

I am trying to use the API to retrieve data from custom data sets I am using in a profile. The custom data has multiple rows for a contact. I don't know how to retrieve the row ids to add to the field name (e.g. custom_50_5) so they will be there when the user saves when editing.

Here is what I did:
require_once ('api/api.php');

/*
* retrieve the fields
*/
$params=array(
'version' => 3,     
'sequential' => 1,
'custom_group_id' =>$groupID
);
$result = civicrm_api ('CustomField','GET',$params);

/*
* store in array
*/
foreach($result['values'] as $k => $field){
$field_attributes[$field['id']] = $field;
}

/*
* prepare param for retrieving values
         */
$keys = array_keys($field_attributes);
$params =array(
'version' => 3,     
'sequential' => 1,
'entity_id' => $cid,
'custom_group_id' =>$groupID,
'entity_table' =>'',
);
foreach ($keys as $n => $id){
$params["return.custom_$id"] = '1';
}
$result = civicrm_api ('CustomValue','GET',$params);


This worked ok, but the result was without a row id for the custom values :
e.g.:
        (
           

• => Array

                (
                    [entity_id] => 2
                    [latest] => 75
                    [id] => 25
                    [1] => 75
                )

            [1] => Array
                (
                    [entity_id] => 2
                    [latest] => 50
                    [id] => 27
                    [1] => 50
                )

How could I do this in a way that I get the row id as well as the column id?
Thanks,
Jere

Thanks Erik.

I actually used the approach you suggested before trying the api.

With all the talk about the database one day changing and the benefits to using the api, I was trying to adapt to the api approach. Right now I have some urgency about completing this project, so I will have to wait a couple of weeks, but I would love to get more involved with civicrm. I will study the link you provided and propose code changes to add the row_id.

The id in my case (25 in this clip from debug output)
(e.g. for this return )
                (
                    [entity_id] => 2
                    [latest] => 75
                    [id] => 25
                    [1] => 75
                )
 is the id as found in civicrm_custom_fields. The row_id I need is the row in the new table with the name listed in civicrm_custom_group.table_name. The row id is the id of that table, the x field in page element names formatted like custom_25_x.  It may only be needed for multiple-record custom fields, but I am not sure. I am only struggling with multiple record fields now.

Duh. I reverted to that code and ran it again, and '1' is the row id. Thanks for your patience. I guess I was looking for it on the right side of the => or something.

Jere

I love the api approach. I am new to it, though, and there is a lot to absorb in a short time.