(Excel) Activix CRM Create a Communication

Create a communication. Returns the created communication.

For more information, see https://docs.crm.activix.ca/api/resources/communication

Download Excel Class Modules Chilkat Excel Class Modules

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

Dim http As Chilkat.Http
Set http = Chilkat.NewHttp

http.AuthToken = "ACCESS_TOKEN"

http.Accept = "application/json"

' The following JSON is sent in the request body:

' {
'   "lead_id": "LEAD_ID",
'   "method": "phone",
'   "type": "outgoing",
'   "call_status": "calling"
' }

' Use this online tool to generate the code from sample JSON: 
' Generate Code to Create JSON

Dim jsonRequestBody As Chilkat.JsonObject
Set jsonRequestBody = Chilkat.NewJsonObject
Dim success As Boolean
success = jsonRequestBody.UpdateString("lead_id","LEAD_ID")
success = jsonRequestBody.UpdateString("method","phone")
success = jsonRequestBody.UpdateString("type","outgoing")
success = jsonRequestBody.UpdateString("call_status","calling")


url = "https://crm.activix.ca/api/v2/communications"


Set resp = http.PText("POST",url,jsonRequestBody.Emit(),"utf-8","application/json",False,False)
If (http.LastMethodSuccess <> True) Then
    Debug.Print http.LastErrorText
    Exit Sub
End If

Debug.Print "Response Status Code: "; resp.StatusCode

Dim jsonResponse As Chilkat.JsonObject
Set jsonResponse = Chilkat.NewJsonObject
success = jsonResponse.Load(resp.BodyStr)
jsonResponse.EmitCompact = False
Debug.Print jsonResponse.Emit()

If (resp.StatusCode >= 300) Then
    Debug.Print "Failed."

    Exit Sub
End If

' Sample output...
' (See the parsing code below..)
' 
' Use the this online tool to generate parsing code from sample JSON: 
' Generate Parsing Code from JSON

' {
'   "data": {
'     "id": 5411998,
'     "created_at": "2019-06-10T13:01:40+00:00",
'     "updated_at": "2019-06-10T13:01:40+00:00",
'     "lead_id": 7135833,
'     "user_id": 13705,
'     "method": "phone",
'     "type": "outgoing",
'     "email_subject": null,
'     "email_body": null,
'     "email_client": null,
'     "email_user": null,
'     "call_duration": null,
'     "call_phone": null,
'     "call_status": "calling"
'   }
' }
' 

dataId = jsonResponse.IntOf("data.id")
dataCreated_at = jsonResponse.StringOf("data.created_at")
dataUpdated_at = jsonResponse.StringOf("data.updated_at")
dataLead_id = jsonResponse.IntOf("data.lead_id")
dataUser_id = jsonResponse.IntOf("data.user_id")
dataMethod = jsonResponse.StringOf("data.method")
dataType = jsonResponse.StringOf("data.type")
dataEmail_subject = jsonResponse.StringOf("data.email_subject")
dataEmail_body = jsonResponse.StringOf("data.email_body")
dataEmail_client = jsonResponse.StringOf("data.email_client")
dataEmail_user = jsonResponse.StringOf("data.email_user")
dataCall_duration = jsonResponse.StringOf("data.call_duration")
dataCall_phone = jsonResponse.StringOf("data.call_phone")
dataCall_status = jsonResponse.StringOf("data.call_status")