You can use the pagination value to navigate thru the pages (which each page contains 250 records).
Here is an example how to read the account call log using the RingCentral JS SDK
async function read_account_calllog(){
var queryParams = {
dateFrom: "2023-11-01T16:42:12.577Z",
dateTo: "2023-11-05T16:42:12.577Z",
view: "Detailed",
perPage: 250
}
try {
var resp = await platform.get('/restapi/v1.0/account/~/call-log', queryParams)
var jsonObj = await resp.json()
for (var record of jsonObj.records){
// parse record and save it to your db
console.log(JSON.stringify(record))
console.log("======= ^^^^^ ========")
}
// Check if there are next pages
var navigationObj = jsonObj.navigation
if (navigationObj.hasOwnProperty("nextPage")){
read_calllog_nextpage(navigationObj.nextPage.uri)
}else{
console.log("no next page. Done")
}
}catch(e){
console.log(e.message)
}
}
async function read_calllog_nextpage(url){
try {
var resp = await platform.get(url)
var jsonObj = await resp.json()
for (var record of jsonObj.records){
// parse record and save it to your db
console.log(JSON.stringify(record))
console.log("======= ^^^^^ ========")
}
// Check if there are next pages
var navigationObj = jsonObj.navigation
if (navigationObj.hasOwnProperty("nextPage")){
read_calllog_nextpage(navigationObj.nextPage.uri)
}else{
console.log("no more next page. Done")
}
} catch (e){
console.log(e.message)
}
}You can combine the 2 functions into one and handle the queryParams accordingly.
Do you have c# example for this code. special on this part.
var resp = await platform.get(url) var jsonObj = await resp.json() for (var record of jsonObj.records){ // parse record and save it to your db console.log(JSON.stringify(record)) console.log("======= ^^^^^ ========") }
Thanks, Yihan
Do you have c# example for this code. special on this part.
var resp = await platform.get(url) var jsonObj = await resp.json() for (var record of jsonObj.records){ // parse record and save it to your db console.log(JSON.stringify(record)) console.log("======= ^^^^^ ========") }
Thanks, Yihan
Here you are
static private async Task read_user_calllog()
{
try
{
var queryParams = new ReadUserCallLogParameters();
queryParams.dateFrom = "2024-01-01T00:00:00.000Z";
queryParams.dateTo = "2024-01-31T23:59:59.009Z";
queryParams.view = "Detailed";
var resp = await restClient.Restapi().Account().Extension().CallLog().List(queryParams);
foreach (CallLogRecord record in resp.records)
{
Console.WriteLine(JsonConvert.SerializeObject(record, Formatting.Indented));
}
}
catch (Exception ex)
{
Console.WriteLine("Cannot read user call log data. " + ex.Message);
}
}
Thank you, PhongVu!
I have questions for paging through all records after init API call, how do I use c# call the API with navigationObj.nextPage.uri
// Check if there are next pages var navigationObj = jsonObj.navigation if (navigationObj.hasOwnProperty("nextPage")){ read_calllog_nextpage(navigationObj.nextPage.uri) }else{ console.log("no next page. Done") }How do I make API call by navigationObj.nextPage.uri?
C# code for this part?
var resp = await platform.get(url)
var jsonObj = await resp.json()
for (
var record of jsonObj.records){ // parse record and save it to your db console.log(JSON.stringify(record)) console.log("======= ^^^^^ ========")
}
Thank you, Yihan
Thank you, PhongVu!
I have questions for paging through all records after init API call, how do I use c# call the API with navigationObj.nextPage.uri
How do I make API call by navigationObj.nextPage.uri?
C# code for this part?
You can implement like this
static private async Task read_account_calllog(string page)
{
CallLogResponse resp = null;
if (page == "")
{
var parameters = new ReadCompanyCallLogParameters();
parameters.dateFrom = "2023-11-17T00:00:00.999Z";
parameters.view = "Detailed";
parameters.perPage = 250;
resp = await restClient.Restapi().Account().CallLog().List(parameters);
}
else
{
resp = await restClient.Get<CallLogResponse>(page);
}
// parse and do something with the response
if (resp.navigation.nextPage != null)
{
Console.WriteLine("Read the next page");
// Mind the API rate limit 10 requests per minute => cause some delay if there are more than 10 pages to read
await read_account_calllog(resp.navigation.nextPage.uri);
}
else
{
Console.WriteLine("No more page");
}
}
Thanks for help, PhongVu!!
I got runtime error when I make next page call by pass navigation.nextPage.uri
System.NullReferenceException: 'Object reference not set to an instance of an object.'
rcCallLogResponse = await rc.Get<CallLogResponse>(nextURL);
AnyIdea?
Here is my code.
CallLogResponse rcCallLogResponse = null;
RestClient rc = new RestClient(
Environment.GetEnvironmentVariable("RC_CLIENT_ID"),
Environment.GetEnvironmentVariable("RC_CLIENT_SECRET"),
Environment.GetEnvironmentVariable("RC_SERVER_URL")
);
if(nextURL == "")
{
// OPTIONAL QUERY PARAMETERS
ReadCompanyCallLogParameters readCompanyCallLogParameters = new ReadCompanyCallLogParameters
{
//page = nextIndex,
perPage = 500,
view = "Detailed",
type = voiceOnly,
dateFrom = fromDateTime
};
rc.Authorize(Environment.GetEnvironmentVariable("RC_JWT")).Wait();
rcCallLogResponse = await rc.Restapi().Account(accountId).CallLog().List(readCompanyCallLogParameters);
}
else
{
rcCallLogResponse = await rc.Get<CallLogResponse>(nextURL);
}
Do I need to get new Token for next page data call?
rc.Authorize(Environment.GetEnvironmentVariable("RC_JWT")).Wait();
Thanks, Yihan
I don’t see your entire function so I don’t really know how to actually implemented and call the function.
Follow this getting started sample code and add the extra code to read next page accordingly. Remember that the getting started sample code shows how to read a user call log. The code I shared above shows how to read account call log. Modify them accordingly as what you want to read. No need to set the .Account(accountId)…
https://developers.ringcentral.com/guide/voice/call-log/quick-start#c#
Thank you so much for your help! I added token refresh event for next page API call. It is working.
Here is my function:
private static async Task ReadCallLogNextPage(string nextURL)
{
// https://developers.ringcentral.com/my-account.html#/applications
// Find your credentials at the above url, set them as environment variables, or enter them below
// PATH PARAMETERS
string accountId = "xxxxxxxxx";
//start time
var fromDateTime = DateTime.Now.ToString("yyyy-MM-dd") + "T00:00:00.000Z";
string0] voiceOnly = new String>1];
voiceOnlyc0] = "Voice";
CallLogResponse rcCallLogResponse = null;
RestClient rc = new RestClient(
Environment.GetEnvironmentVariable("RC_CLIENT_ID"),
Environment.GetEnvironmentVariable("RC_CLIENT_SECRET"),
Environment.GetEnvironmentVariable("RC_SERVER_URL")
);
rc.Authorize(Environment.GetEnvironmentVariable("RC_JWT")).Wait();
if (nextURL == "")
{
// OPTIONAL QUERY PARAMETERS
ReadCompanyCallLogParameters readCompanyCallLogParameters = new ReadCompanyCallLogParameters
{
perPage = 500,
view = "Detailed",
type = voiceOnly,
dateFrom = fromDateTime
};
rcCallLogResponse = await rc.Restapi().Account(accountId).CallLog().List(readCompanyCallLogParameters);
}
else
{
rcCallLogResponse = await rc.Get<CallLogResponse>(nextURL);
}
if (rcCallLogResponse != null)
{
// insert RingCentralCallLogs
foreach (var item in rcCallLogResponse.records)
{
RingCentralCallLog insertRCLog = new RingCentralCallLog()
{
// add ringcentral call logs
//insert call legs if RingCentralCallLog session id is not in table which means new record just added.
if (returnRCLog == null)
{
Console.WriteLine("insert new ringcentral call:" + "ID: " + insertRCLog.id + " NewCallLog exist? " + returnRCLog);
foreach (var rcLogLeg in item.legs)
{
//add legs
}
}
}
// Check if there are next pages
var navigation = rcCallLogResponse.navigation;
if (navigation != null)
{
if (navigation.nextPage != null)
{
Console.WriteLine("next Page -------- " + navigation.nextPage.uri);
//call ReadCallLogNextPage again if CallLogResponse has next page
await ReadCallLogNextPage(navigation.nextPage.uri);
}
else
{
Console.WriteLine("no next page. Done");
}
}
}
}
Don’t call the authorize() function every time you call that function. Do exactly as the getting started sample code shows. Otherwise, you will hit the API rate limit and your app will stop working.
Got it. Thank you for great support!!
