Visual FoxPro Zendesk: Create Many Tickets

Back to Index

Creates multiple Zendesk tickets in one call.

Documentation: https://developer.zendesk.com/rest_api/docs/core/tickets#create-many-tickets

CURL Command

curl -X POST https://subdomain.zendesk.com/api/v2/tickets/create_many.json \
  -H "Content-Type: application/json" \
  -H "Accept: application/json" \
  -d '{
  "tickets": [
    {
      "subject":  "My USB port is smokin!",
      "comment":  { "body": "The smoke is very colorful." },
      "priority": "urgent"
    },
    {
      "subject":  "Help",
      "comment":  { "body": "This is a comment" },
      "priority": "normal"
    }
  ]
}' \
  -u zendesk_email:zendesk_password

Visual FoxPro Example

LOCAL loRest
LOCAL lnSuccess
LOCAL lnBTls
LOCAL lnPort
LOCAL lnBAutoReconnect
LOCAL loJson
LOCAL loSbRequestBody
LOCAL loSbResponseBody
LOCAL lnRespStatusCode
LOCAL loJsonResponse
LOCAL lcJob_statusId
LOCAL lcJob_statusUrl
LOCAL lcJob_statusTotal
LOCAL lcJob_statusProgress
LOCAL lcJob_statusStatus
LOCAL lcJob_statusMessage
LOCAL lcJob_statusResults

loRest = CreateObject('Chilkat_9_5_0.Rest')

*  URL: https://subdomain.zendesk.com/api/v2/tickets/create_many.json
lnBTls = 1
lnPort = 443
lnBAutoReconnect = 1
lnSuccess = loRest.Connect("subdomain.zendesk.com",lnPort,lnBTls,lnBAutoReconnect)
IF (lnSuccess <> 1) THEN
    ? "ConnectFailReason: " + STR(loRest.ConnectFailReason)
    ? loRest.LastErrorText
    RELEASE loRest
    CANCEL
ENDIF

loRest.SetAuthBasic("zendesk_email","zendesk_password")

loJson = CreateObject('Chilkat_9_5_0.JsonObject')
loJson.UpdateString("tickets[0].subject","My USB port is smokin!")
loJson.UpdateString("tickets[0].comment.body","The smoke is very colorful.")
loJson.UpdateString("tickets[0].priority","urgent")
loJson.UpdateString("tickets[1].subject","Help")
loJson.UpdateString("tickets[1].comment.body","This is a comment")
loJson.UpdateString("tickets[1].priority","normal")

loRest.AddHeader("Content-Type","application/json")
loRest.AddHeader("Accept","application/json")

loSbRequestBody = CreateObject('Chilkat_9_5_0.StringBuilder')
loJson.EmitSb(loSbRequestBody)
loSbResponseBody = CreateObject('Chilkat_9_5_0.StringBuilder')
lnSuccess = loRest.FullRequestSb("POST","/api/v2/tickets/create_many.json",loSbRequestBody,loSbResponseBody)
IF (lnSuccess <> 1) THEN
    ? loRest.LastErrorText
    RELEASE loRest
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

lnRespStatusCode = loRest.ResponseStatusCode
IF (lnRespStatusCode >= 400) THEN
    ? "Response Status Code = " + STR(lnRespStatusCode)
    ? "Response Header:"
    ? loRest.ResponseHeader
    ? "Response Body:"
    ? loSbResponseBody.GetAsString()
    RELEASE loRest
    RELEASE loJson
    RELEASE loSbRequestBody
    RELEASE loSbResponseBody
    CANCEL
ENDIF

loJsonResponse = CreateObject('Chilkat_9_5_0.JsonObject')
loJsonResponse.LoadSb(loSbResponseBody)

lcJob_statusId = loJsonResponse.StringOf("job_status.id")
lcJob_statusUrl = loJsonResponse.StringOf("job_status.url")
lcJob_statusTotal = loJsonResponse.StringOf("job_status.total")
lcJob_statusProgress = loJsonResponse.StringOf("job_status.progress")
lcJob_statusStatus = loJsonResponse.StringOf("job_status.status")
lcJob_statusMessage = loJsonResponse.StringOf("job_status.message")
lcJob_statusResults = loJsonResponse.StringOf("job_status.results")

RELEASE loRest
RELEASE loJson
RELEASE loSbRequestBody
RELEASE loSbResponseBody
RELEASE loJsonResponse

Sample JSON Response Body

{
  "job_status": {
    "id": "5d5531f033737e327ce44bf2e8cc6a1a",
    "url": "https://chilkat.zendesk.com/api/v2/job_statuses/5d5531f033737e327ce44bf2e8cc6a1a.json",
    "total": null,
    "progress": null,
    "status": "queued",
    "message": null,
    "results": null
  }
}