Visual FoxPro

CallRail API - Retrieving a Single Call

See more CallRail Examples

Returns a single call object associated with the target account. Visual FoxPro

LOCAL lnSuccess
LOCAL loHttp
LOCAL loSbResponseBody
LOCAL loJResp
LOCAL lnRespStatusCode
LOCAL lcKeyword
LOCAL j
LOCAL lnCount_j
LOCAL lcSpeaker
LOCAL lcStart
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 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/{call_id}.json?fields=keywords_spotted"

* 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/{call_id}.json?fields=keywords_spotted",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)

* {
*   "answered": false,
*   "business_phone_number": null,
*   "customer_city": "New York City",
*   "customer_country": "US",
*   "customer_name": "Jimmy Pesto, Sr.",
*   "customer_phone_number": "+13036231131",
*   "customer_state": "NY",
*   "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",
*   "keywords_spotted": [
*     {
*       "keyword": "test phrase one",
*       "locations": [
*         {
*           "speaker": "caller",
*           "start": 7.71
*         },
*         {
*           "speaker": "agent",
*           "start": 13.38
*         },
*         {
*           "speaker": "caller",
*           "start": 17.96
*         }
*       ]
*     },
*     {
*       "keyword": "test phrase two",
*       "locations": [
*         {
*           "speaker": "caller",
*           "start": 8.44
*         }
*       ]
*     }
*   ]
* }

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

lnAnswered = loJResp.BoolOf("answered")
lcBusiness_phone_number = loJResp.StringOf("business_phone_number")
lcCustomer_city = loJResp.StringOf("customer_city")
lcCustomer_country = loJResp.StringOf("customer_country")
lcCustomer_name = loJResp.StringOf("customer_name")
lcCustomer_phone_number = loJResp.StringOf("customer_phone_number")
lcCustomer_state = loJResp.StringOf("customer_state")
lcDirection = loJResp.StringOf("direction")
lnDuration = loJResp.IntOf("duration")
lcId = loJResp.StringOf("id")
lcRecording = loJResp.StringOf("recording")
lcRecording_duration = loJResp.StringOf("recording_duration")
lcRecording_player = loJResp.StringOf("recording_player")
lcStart_time = loJResp.StringOf("start_time")
lcTracking_phone_number = loJResp.StringOf("tracking_phone_number")
lnVoicemail = loJResp.BoolOf("voicemail")
lcAgent_email = loJResp.StringOf("agent_email")
i = 0
lnCount_i = loJResp.SizeOfArray("keywords_spotted")
DO WHILE i < lnCount_i
    loJResp.I = i
    lcKeyword = loJResp.StringOf("keywords_spotted[i].keyword")
    j = 0
    lnCount_j = loJResp.SizeOfArray("keywords_spotted[i].locations")
    DO WHILE j < lnCount_j
        loJResp.J = j
        lcSpeaker = loJResp.StringOf("keywords_spotted[i].locations[j].speaker")
        lcStart = loJResp.StringOf("keywords_spotted[i].locations[j].start")
        j = j + 1
    ENDDO
    i = i + 1
ENDDO

RELEASE loHttp
RELEASE loSbResponseBody
RELEASE loJResp