1. Telebroad | Support Center
  2. Solution home
  3. Legacy API Documentation
  4. REST API - GET Requests
Open navigation

GET/pbx/logs/csv (Legacy)

  Articles in this support section discuss Telebroad's legacy APIs. To learn about the current version of Telebroad APIs, which offer additional authentication options and support for advanced features, please go to https://developers.telebroad.com/.



Function and Response Fields


The GET/pbx/logs/csv request will return a log of PBX call flow records in the form of a downloadable CSV file. Each leg of a call takes one row of the CSV file. The top row contains the names of the fields.

The response is similar to GET/pbx/logs but has less information fields. Another difference between the two requests is that instead of a Unix time format, the CSV file shows a regular date-time for the start and end time fields.  

The response returns records for all calls dialled or received by all users in the requested time frame, regardless of the provided user login credentials. 


The API response includes a "file" field. It is the URL for the CSV file. Copy-paste it into a web browser to download the CSV file and open it with any program or app the supports the format.


The CSV file itself includes the following information fields:


  • Call Identifier - a unique ID for each call. It is created by combining its start time (in Unix time format), direction and other values.  Note that all legs of a call share the same Call Identifier!
  • Date - the date for the start time for the call log leg.
  • Start Time - the start time for the call log leg.
  • Caller Number or Name - phone number of the caller based on his caller ID. If it is not available, in the case his caller ID is blocked, his name will be used here (also for internal calls sometimes the name and number are idential on the PBX system).
  • Caller Name - name of caller based on his caller ID. If it is not available, their number will be used.
  • Status - indication of the status of the call log leg in terms of connection between the source and destination points of the previous and current call flow legs. Possible responses include "answer","noanswer" (by the recipient), "cancel" (by the caller), "congestion" (too much traffic preventing a connection), "busy" (the recipient is on another call), or "chanunavail" - the destination communication channel is unavailable or the requested peer is not registered.
  • Direction - direction of the call leg,  "in" for inbound call, "out" for outbound call, or "internal" for a leg that has been routed or transferred internally.
  • Called Type -  the type of called point, where the caller originally dialed to or where the preceding call leg transferred the call to. Examples of such points can be a specific department, a phone line,  "ivr", "phone", "huntgroup", "voicemailbox", or "external" for outbound calls.  
  • Called Number or Name - the phone number or PBX name of the destination point for the current or previous leg. As a call progresses through a call flow, this may sometimes be identical to the called number.
  • Dialed Number - the phone number of the destination point for the next leg where the call is going to be routed to. As a call progresses through a call flow this may be sometimes identical to the called number.
  • Arrived to Type - a definition for the type of destination point (where the call was routed to) for the leg. Examples can be  "ivr", "user, "queue", "external" etc. 
  • Arrived to Number or Name - the destination point for the leg where the call arrived to. It extends on the "Arrived to Type" with a more specific point. For example, if the type is "user" then their name or number will be given here. 
  • Event Total Time - the total time (hours, minutes, seconds) for the call log leg including holding and talking time.
  • Event Talk Time - the talk time (hours, minutes, seconds) for the call log leg.
  • Total Time - an accumulation of total time (hold time+ talk time) for all preceding and current call log legs in hours, minutes, seconds.
  • Total Talk Time - an accumulation of talk time for all preceding and current call log legs in hours, minutes, seconds. 
  • Call End Time - the date and time when the call ended.


Parameters


ParameterTypeOperation
callid
stringIf used, will limit the response to the one call specified by this parameter.

You can obtain it by using the GET/pbx/logs request.
*startstringThe starting time from which point the request is to display the call logs, specified in Unix timestamp.
*endstringThe ending time until which point the request is to display the call logs, specified in Unix timestamp.
descendingBooleanUse this to sort the list -  1 to sort in descending order, 0 not to.
**limitintegerSpecify the number of call log records to be returned by the request.
offsetintegerSpecify the first call log record to display. For example, an offset of 3 will start the list on the 3rd record. If left empty, the default will be the first record.

* Use start=0 and end=-1 to display all records.


** The returned list may be many pages long. Using the limit parameter is particularly useful in this situation.


Example


To request the first three available PBX log records:


HTTPS method: GET


webserv.telebroad.com/api/teleconsole/rest/pbx/logs/csv?descending=1&end=-1&start=0&limit=3


Response:


{
    "error": null,
    
    "result": {
     
    "file": 

            "http:\/\/webserv.telebroad.com\/tmp\/pbxlogs-1532-

            7e6d2141fabdd129925ea2ac7ec2bdbe.csv"
    
}
}


When downloaded, the CSV file will look something like this (only four rows are shown here. The full file may contain hundreds of rows): 


"Call Identifier",Date,"Start Time","Caller Number or Name","Caller Name",Status,"Call Direction","Called Type","Called Number or Name","Dialed Number","Arrived to Type","Arrived to Number or Name","Event Total Time","Event Talk Time","Total Time","Total Talk Time","Call End Time"


"1589949387.701748 ",05/20/2019,"12:36:27 PM","1 (212) 583-2122","ROBERT HARRISON",Answer,In,Number,"1 (212) 583-2122",16466991356,IVR,"Auto Attendant Main Menu",00:01:02,00:01:02,00:01:02,00:01:02,"05/20/2019 12:37:29 PM"


"1589949387.701748 ",05/20/2019,"12:36:33 PM","1 (212) 583-2122","ROBERT HARRISON",Answer,Internal,IVR,"Auto Attendant Main Menu",1409,Queue,"Sales Department ",00:00:56,00:00:56,00:01:02,00:01:02,"05/20/2019 12:37:29 PM"


"1589949387.701748 ",05/20/2019,"12:37:03 PM","1 (212) 583-2122","ROBERT HARRISON",Mailbox,Internal,Number,"1 (212) 583-2122",1113840,User,"Rick L. Goodwin",00:00:26,00:00:16,00:01:02,00:00:52,"05/19/2020 12:37:29 PM"

.

.

.