Visual FoxPro

CallRail API - Listing All Calls

See more CallRail Examples

Returns a paginated list of all calls in the target account. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lnAnswered
LOCAL lcBusiness_phone_number
LOCAL lcCustomer_city
LOCAL lcCustomer_country
LOCAL lcCustomer_name
LOCAL lcCustomer_phone_number
LOCAL lcCustomer_state
LOCAL lcDirection
LOCAL lnDuration
LOCAL lcId
LOCAL lcRecording
LOCAL lcRecording_duration
LOCAL lcRecording_player
LOCAL lcStart_time
LOCAL lcTracking_phone_number
LOCAL lnVoicemail
LOCAL lcAgent_email
LOCAL lnPage
LOCAL lnPer_page
LOCAL lnTotal_pages
LOCAL lnTotal_records
LOCAL i
LOCAL lnCount_i

lnSuccess = 0

* This example assumes the Chilkat API to have been previously unlocked.
* See Global Unlock Sample for sample code.

loHttp = CreateObject('Chilkat.Http')

* Implements the following CURL command:

* curl -H "Authorization: Token token={api_token}" \
*      -X GET \
*      "https://api.callrail.com/v3/a/{account_id}/calls.json"

* Use the following online tool to generate HTTP code from a CURL command
* Convert a cURL Command to HTTP Source Code

loHttp.SetRequestHeader("Authorization","Token token={api_token}")

loSbResponseBody = CreateObject('Chilkat.StringBuilder')
lnSuccess = loHttp.QuickGetSb("https://api.callrail.com/v3/a/{account_id}/calls.json",loSbResponseBody)
IF (lnSuccess = 0) THEN
    ? loHttp.LastErrorText
    RELEASE loHttp
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJResp = CreateObject('Chilkat.JsonObject')
loJResp.LoadSb(loSbResponseBody)
loJResp.EmitCompact = 0

? "Response Body:"
? loJResp.Emit()

lnRespStatusCode = loHttp.LastStatus
? "Response Status Code = " + STR(lnRespStatusCode)
IF (lnRespStatusCode >= 400) THEN
    ? "Response Header:"
    ? loHttp.LastHeader
    ? "Failed."
    RELEASE loHttp
    RELEASE loSbResponseBody
    RELEASE loJResp
    CANCEL
ENDIF

* Sample JSON response:
* (Sample code for parsing the JSON response is shown below)

* {
*   "page": 1,
*   "per_page": 100,
*   "total_pages": 1,
*   "total_records": 9,
*   "calls": [
*     {
*       "answered": false,
*       "business_phone_number": null,
*       "customer_city": "Denver",
*       "customer_country": "US",
*       "customer_name": "RUEGSEGGER SIMO",
*       "customer_phone_number": "+13036231131",
*       "customer_state": "CO",
*       "direction": "inbound",
*       "duration": 4,
*       "id": "CAL8154748ae6bd4e278a7cddd38a662f4f",
*       "recording": "https://api.callrail.com/v3/a/227799611/calls/111222333/recording.json",
*       "recording_duration": "27",
*       "recording_player": "https://app.callrail.com/calls/111222333/recording?access_key=3b91eb7f7cc08a4d01ed",
*       "start_time": "2017-01-24T11:27:48.119-05:00",
*       "tracking_phone_number": "+13038163491",
*       "voicemail": false,
*       "agent_email": "gil@televised.com"
*     },
*     {
*       "answered": false,
*       "business_phone_number": null,
*       "customer_city": "Blue Ridge",
*       "customer_country": "US",
*       "customer_name": "BLUE RIDGE, GA",
*       "customer_phone_number": "+17064558047",
*       "customer_state": "GA",
*       "direction": "inbound",
*       "duration": 16,
*       "id": "CAL8154748ae6bd4e278a7cddd38a662f4f",
*       "recording": null,
*       "recording_duration": null,
*       "recording_player": null,
*       "start_time": "2017-01-24T19:50:03.456-05:00",
*       "tracking_phone_number": "+17708243899",
*       "voicemail": false,
*       "agent_email": "elbert@bpp.com"
*     }
*   ]
* }

* Sample code for parsing the JSON response...
* Use the following online tool to generate parsing code from sample JSON:
* Generate Parsing Code from JSON

lnPage = loJResp.IntOf("page")
lnPer_page = loJResp.IntOf("per_page")
lnTotal_pages = loJResp.IntOf("total_pages")
lnTotal_records = loJResp.IntOf("total_records")
i = 0
lnCount_i = loJResp.SizeOfArray("calls")
DO WHILE i < lnCount_i
    loJResp.I = i
    lnAnswered = loJResp.BoolOf("calls[i].answered")
    lcBusiness_phone_number = loJResp.StringOf("calls[i].business_phone_number")
    lcCustomer_city = loJResp.StringOf("calls[i].customer_city")
    lcCustomer_country = loJResp.StringOf("calls[i].customer_country")
    lcCustomer_name = loJResp.StringOf("calls[i].customer_name")
    lcCustomer_phone_number = loJResp.StringOf("calls[i].customer_phone_number")
    lcCustomer_state = loJResp.StringOf("calls[i].customer_state")
    lcDirection = loJResp.StringOf("calls[i].direction")
    lnDuration = loJResp.IntOf("calls[i].duration")
    lcId = loJResp.StringOf("calls[i].id")
    lcRecording = loJResp.StringOf("calls[i].recording")
    lcRecording_duration = loJResp.StringOf("calls[i].recording_duration")
    lcRecording_player = loJResp.StringOf("calls[i].recording_player")
    lcStart_time = loJResp.StringOf("calls[i].start_time")
    lcTracking_phone_number = loJResp.StringOf("calls[i].tracking_phone_number")
    lnVoicemail = loJResp.BoolOf("calls[i].voicemail")
    lcAgent_email = loJResp.StringOf("calls[i].agent_email")
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp