Save data problem in email_addr_bean_rel

[arpita rana]

I want to insert record in email_addr_bean_rel table and i used REST API through cURL.

Still i traced out code i knew, For saving record in this table need to pass parameter but how to pass parameter. that is my question:-
i passed out in following way with set_entry method.

$saNameValueList = array(array('name'=>'email_address', value'=>'test@gmail.com'),
array('name'=>'primary_address', 'value'=>1),
array('name'=>'reply_to_address', 'value'=>0),
array('name'=>'invalid_email', 'value'=>0),
array('name'=>'opt_out', 'value'=>1),
);
$set_entry_params_acc = array('session' => $session_id, 'module_name'=>'EmailAddresses',
'name_value_list'=>$saNameValueList);
$asParams = array('method' => 'set_entry','input_type' => 'JSON','response_type' => 'JSON',
'rest_data' => json_encode($set_entry_params_acc));

So,Please correct my code wherever i wrong.
I need your help ASAP.
Thanks in advance.

[sts]

Here is an example for creating a lead using the 'set_entry' method. This works with my 6.2 installation. I removed some lines (I had several more 'name_value_list' entries) to make it shorter. I hope this helps you:

     // create a new leads record and grab the leads ID
    $param_entry_list=array(
        'session'=>$session_id,
        'module_name'=>'Leads',
        'name_value_list'=> array(
            array("name" => 'account_name',"value" => urlencode($account_name)),
            array("name" => 'primary_address_street',"value" => urlencode($primary_address_street)),
            array("name" => 'primary_address_postalcode',"value" => urlencode($primary_address_postalcode)),
            array("name" => 'primary_address_city',"value" => urlencode($primary_address_city)),
            array("name" => 'email1',"value" => urlencode($email1)),
            array("name" => 'description',"value" => urlencode($description))
        )
    );
 
    $json = json_encode($param_entry_list);
    $postArgs = 'method=set_entry&input_type=JSON&response_type=JSON&rest_data=' . $json;
    curl_setopt($curl, CURLOPT_POSTFIELDS, $postArgs);
    $response = curl_exec($curl);
    $result = json_decode($response);
    if (!$result->id) {
        DEBUG("Fatal Error", "Lead Generation Failed");
                die();
    }
    $lead_id = $result->id; 
  

[arpita rana]

Here is an example for creating a lead using the 'set_entry' method. This works with my 6.2 installation. I removed some lines (I had several more 'name_value_list' entries) to make it shorter. I hope this helps you:

     // create a new leads record and grab the leads ID
    $param_entry_list=array(
        'session'=>$session_id,
        'module_name'=>'Leads',
        'name_value_list'=> array(
            array("name" => 'account_name',"value" => urlencode($account_name)),
            array("name" => 'primary_address_street',"value" => urlencode($primary_address_street)),
            array("name" => 'primary_address_postalcode',"value" => urlencode($primary_address_postalcode)),
            array("name" => 'primary_address_city',"value" => urlencode($primary_address_city)),
            array("name" => 'email1',"value" => urlencode($email1)),
            array("name" => 'description',"value" => urlencode($description))
        )
    );
 
    $json = json_encode($param_entry_list);
    $postArgs = 'method=set_entry&input_type=JSON&response_type=JSON&rest_data=' . $json;
    curl_setopt($curl, CURLOPT_POSTFIELDS, $postArgs);
    $response = curl_exec($curl);
    $result = json_decode($response);
    if (!$result->id) {
        DEBUG("Fatal Error", "Lead Generation Failed");
                die();
    }
    $lead_id = $result->id; 
  

Thanks for your reply .

Yes this way we are inserting record but our code insert only in email_address table but we have to insert also in email_addr_bean_rel table ..

SO how we can insert data in this table because this table ( email_addr_bean_rel) module is not available and this table relation is with email_address table.

So please help me asap

[arpita rana]

Thanks for your reply .

Yes this way we are inserting record but our code insert only in email_address table but we have to insert also in email_addr_bean_rel table ..

SO how we can insert data in this table because this table ( email_addr_bean_rel) module is not available and this table relation is with email_address table.

So please help me asap

Thank you so much for help.

Now its working by passing 'email1' parameter in Users module .

please ignore my previous reply.

Thanks,

[garciasanchezdaniel]

hello, you can try to insert manually in the table using a code like this:

 global $db;
$query = "INSERT INTO yourtable (variable1,variable2,...) VALUES (value1,value2,...)";
$r = $db->query($query);