Hi,
Im trying to retrieve data using the SuiteCRM API (rest). I was able to query the data from other modules (ex. leads) but not from the product categories. Not sure if im using the correct module name. AOS_Product_Categories
Thanks
That is the correct name, there must be something else wrong with your code.
<?php
/**
| CRM CRED
*/
// specify the REST web service to interact with
$url = 'http://sugarinstance/service/v4_1/rest.php';
$username = 'user';
$password = 'pass;
//function to make cURL request
function call($method, $parameters, $url)
{
ob_start();
$curl_request = curl_init();
curl_setopt($curl_request, CURLOPT_URL, $url);
curl_setopt($curl_request, CURLOPT_POST, 1);
curl_setopt($curl_request, CURLOPT_HTTP_VERSION, CURL_HTTP_VERSION_1_0);
curl_setopt($curl_request, CURLOPT_HEADER, 1);
curl_setopt($curl_request, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($curl_request, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($curl_request, CURLOPT_FOLLOWLOCATION, 0);
$jsonEncodedData = json_encode($parameters);
$post = array(
"method" => $method,
"input_type" => "JSON",
"response_type" => "JSON",
"rest_data" => $jsonEncodedData
);
curl_setopt($curl_request, CURLOPT_POSTFIELDS, $post);
$result = curl_exec($curl_request);
curl_close($curl_request);
$result = explode("\r\n\r\n", $result, 2);
$response = json_decode($result[1]);
ob_end_flush();
return $response;
}
//login ------------------------------
$login_parameters = array(
"user_auth" => array(
"user_name" => $username,
"password" => md5($password),
"version" => "1"
),
"application_name" => "RestTest",
"name_value_list" => array(),
);
$login_result = call("login", $login_parameters, $url);
$session_id = $login_result->id;
$get_entry_list_parameters = array(
//session id
'session' => $session_id,
//The name of the module from which to retrieve records
'module_name' => 'AOS_Products',
//The SQL WHERE clause without the word "where".
'query' => "",
//The SQL ORDER BY clause without the phrase "order by".
'order_by' => "",
//The record offset from which to start.
'offset' => 0,
// //A list of fields to include in the results.
// 'select_fields' => array(
// 'id',
// 'name',
// 'title',
// ),
// //A list of link names and the fields to be returned for each link name.
// 'link_name_to_fields_array' => array(
// array(
// 'name' => 'email_addresses',
// 'value' => array(
// 'email_address',
// 'opt_out',
// 'primary_address'
// ),
// ),
// ),
//The maximum number of results to return.
'max_results' => 2,
//If deleted records should be included in results.
'deleted' => 0,
//If only records marked as favorites should be returned.
'favorites' => false,
);
$get_entries_result = call('get_entry_list', $get_entry_list_parameters, $url);
echo '
';
print_r($get_entries_result);
echo '';
//get session id
//$session_id = $login_result->id;
This is the code that I'm using. Can you check if there is something wrong with it?