Cdr query
This function allows receiving all data about phone calls using SQL querying, and receiving the answers in JSON or XML. • This function requires knowledge with SQL language of My SQL server
/api/?service=cdr_query
Usage and SDK Samples
curl -H "Authorization: Bearer < TOKEN_FROM_SYSTEM >" -X get "https://[MASKYOO_URL]/api/?service=cdr_query&sql=&format="
using System.Net;
using System.Collections.Specialized;
namespace Examples.System.Net
{
public class WebRequestPostExample
{
public static void Main ()
{
string url_query_string="https://[MASKYOO_URL]/api/?";
using (var client = new WebClient())
{
var values = new NameValueCollection();
values["service"] = "cdr_query";
values["sql"] = "SELECT id, start_call, end_call, call_duration, cdr_ani, cdr_ddi, onetouch, user_phone, user_name, cdr_uniqueid, call_status FROM webserviceview limit 2 ";
values["format"] = "json";
client.Headers.Add("Authorization","Bearer < TOKEN_FROM_SYSTEM >");
var response = client.UploadValues(url_query_string, values);
var responseString = Encoding.Default.GetString(response);
Console.WriteLine (responseString);
}
}
}
}
<?php
$base_url="https://[MASKYOO_URL]/api/";
$data = array(
"service" => "cdr_query",
"sql" => "SELECT id, start_call, end_call, call_duration, cdr_ani, cdr_ddi, onetouch, user_phone, user_name, cdr_uniqueid, call_status FROM webserviceview limit 2 ",
"format" => "json"
);
echo post_data($base_url, $data);
function post_data($url, $data){
$fields = '';
foreach($data as $key => $value) {
$fields .= $key . '=' . $value . '&';
}
rtrim($fields, '&');
$post = curl_init();
curl_setopt($post, CURLOPT_URL, $url);
curl_setopt($post, CURLOPT_POST, count($data));
curl_setopt($post, CURLOPT_POSTFIELDS, $fields);
curl_setopt($post, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($post, CURLOPT_HTTPHEADER, array("Authorization: Bearer < TOKEN_FROM_SYSTEM >"));
$result = curl_exec($post);
curl_close($post);
return $result;
}
?>
Parameters
Query parameters
| Name | Description |
|---|---|
| sql* | |
| format |