Back to Collection Items
' This example assumes the Chilkat API to have been previously unlocked.
' See Global Unlock Sample for sample code.
Dim http As New ChilkatHttp
Dim success As Long
http.BasicAuth = 1
http.Login = "login"
http.Password = "password"
' Use this online tool to generate code from sample JSON: Generate Code to Create JSON
' The following JSON is sent in the request body.
' {
' "ticket": {
' "comment": {
' "attachments": [
' {
' "content_type": "<string>",
' "content_url": "<string>",
' "deleted": "<boolean>",
' "file_name": "<string>",
' "height": "<string>",
' "id": "<integer>",
' "inline": "<boolean>",
' "malware_access_override": "<boolean>",
' "malware_scan_result": "<string>",
' "mapped_content_url": "<string>",
' "size": "<integer>",
' "url": "<string>",
' "width": "<string>",
' "thumbnails": [
' {
' "content_type": "<string>",
' "content_url": "<string>",
' "deleted": "<boolean>",
' "file_name": "<string>",
' "height": "<string>",
' "id": "<integer>",
' "inline": "<boolean>",
' "malware_access_override": "<boolean>",
' "malware_scan_result": "<string>",
' "mapped_content_url": "<string>",
' "size": "<integer>",
' "url": "<string>",
' "width": "<string>"
' },
' {
' "content_type": "<string>",
' "content_url": "<string>",
' "deleted": "<boolean>",
' "file_name": "<string>",
' "height": "<string>",
' "id": "<integer>",
' "inline": "<boolean>",
' "malware_access_override": "<boolean>",
' "malware_scan_result": "<string>",
' "mapped_content_url": "<string>",
' "size": "<integer>",
' "url": "<string>",
' "width": "<string>"
' }
' ]
' },
' {
' "content_type": "<string>",
' "content_url": "<string>",
' "deleted": "<boolean>",
' "file_name": "<string>",
' "height": "<string>",
' "id": "<integer>",
' "inline": "<boolean>",
' "malware_access_override": "<boolean>",
' "malware_scan_result": "<string>",
' "mapped_content_url": "<string>",
' "size": "<integer>",
' "url": "<string>",
' "width": "<string>",
' "thumbnails": [
' {
' "content_type": "<string>",
' "content_url": "<string>",
' "deleted": "<boolean>",
' "file_name": "<string>",
' "height": "<string>",
' "id": "<integer>",
' "inline": "<boolean>",
' "malware_access_override": "<boolean>",
' "malware_scan_result": "<string>",
' "mapped_content_url": "<string>",
' "size": "<integer>",
' "url": "<string>",
' "width": "<string>"
' },
' {
' "content_type": "<string>",
' "content_url": "<string>",
' "deleted": "<boolean>",
' "file_name": "<string>",
' "height": "<string>",
' "id": "<integer>",
' "inline": "<boolean>",
' "malware_access_override": "<boolean>",
' "malware_scan_result": "<string>",
' "mapped_content_url": "<string>",
' "size": "<integer>",
' "url": "<string>",
' "width": "<string>"
' }
' ]
' }
' ],
' "audit_id": "<integer>",
' "author_id": "<integer>",
' "body": "<string>",
' "created_at": "<dateTime>",
' "html_body": "<string>",
' "id": "<integer>",
' "metadata": {
' "occaecat_2d1": -71498595,
' "incididunt3": -68401909.632414,
' "nond": -22715203,
' "voluptate9e": -92868072
' },
' "plain_body": "<string>",
' "public": "<boolean>",
' "type": "<string>",
' "uploads": [
' "<string>",
' "<string>"
' ],
' "via": {
' "channel": "<string>",
' "source": {
' "ut797": -65734664.31848694,
' "incididunt_14a": 54532844.54826489,
' "enim_2": false,
' "sed_ac": 43217710
' }
' }
' },
' "additional_collaborators": [
' {
' "email": "<email>",
' "name": "<string>"
' },
' {
' "email": "<email>",
' "name": "<string>"
' }
' ],
' "assignee_email": "<email>",
' "assignee_id": "<integer>",
' "attribute_value_ids": [
' "<integer>",
' "<integer>"
' ],
' "collaborator_ids": "<array>",
' "custom_fields": "<array>",
' "custom_status_id": "<integer>",
' "due_at": "<dateTime>",
' "email_ccs": [
' {
' "action": "put",
' "user_email": "<email>",
' "user_id": "<string>",
' "user_name": "<string>"
' },
' {
' "action": "delete",
' "user_email": "<email>",
' "user_id": "<string>",
' "user_name": "<string>"
' }
' ],
' "external_id": "<string>",
' "followers": [
' {
' "action": "put",
' "user_email": "<email>",
' "user_id": "<string>"
' },
' {
' "action": "delete",
' "user_email": "<email>",
' "user_id": "<string>"
' }
' ],
' "group_id": "<integer>",
' "organization_id": "<integer>",
' "priority": "urgent",
' "problem_id": "<integer>",
' "requester_id": "<integer>",
' "safe_update": "<boolean>",
' "sharing_agreement_ids": [
' "<integer>",
' "<integer>"
' ],
' "status": "closed",
' "subject": "<string>",
' "tags": "<array>",
' "type": "task",
' "updated_stamp": "<dateTime>",
' "brand_id": "<integer>",
' "collaborators": "<array>",
' "email_cc_ids": "<array>",
' "follower_ids": "<array>",
' "macro_ids": "<array>",
' "raw_subject": "<string>",
' "recipient": "<string>",
' "submitter_id": "<integer>",
' "ticket_form_id": "<integer>",
' "via": {
' "channel": "<string>",
' "source": {
' "from": {
' "address": "<string>",
' "id": "<integer>",
' "name": "<string>",
' "title": "<string>"
' },
' "rel": "<string>",
' "to": {
' "address": "<string>",
' "name": "<string>"
' }
' }
' },
' "via_followup_source_id": "<integer>"
' }
' }
Dim json As New ChilkatJsonObject
success = json.UpdateString("ticket.comment.attachments[0].content_type","<string>")
success = json.UpdateString("ticket.comment.attachments[0].content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].deleted","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].file_name","<string>")
success = json.UpdateString("ticket.comment.attachments[0].height","<string>")
success = json.UpdateString("ticket.comment.attachments[0].id","<integer>")
success = json.UpdateString("ticket.comment.attachments[0].inline","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].malware_access_override","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].malware_scan_result","<string>")
success = json.UpdateString("ticket.comment.attachments[0].mapped_content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].size","<integer>")
success = json.UpdateString("ticket.comment.attachments[0].url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].width","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].content_type","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].deleted","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].file_name","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].height","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].id","<integer>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].inline","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].malware_access_override","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].malware_scan_result","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].mapped_content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].size","<integer>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[0].width","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].content_type","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].deleted","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].file_name","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].height","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].id","<integer>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].inline","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].malware_access_override","<boolean>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].malware_scan_result","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].mapped_content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].size","<integer>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].url","<string>")
success = json.UpdateString("ticket.comment.attachments[0].thumbnails[1].width","<string>")
success = json.UpdateString("ticket.comment.attachments[1].content_type","<string>")
success = json.UpdateString("ticket.comment.attachments[1].content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].deleted","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].file_name","<string>")
success = json.UpdateString("ticket.comment.attachments[1].height","<string>")
success = json.UpdateString("ticket.comment.attachments[1].id","<integer>")
success = json.UpdateString("ticket.comment.attachments[1].inline","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].malware_access_override","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].malware_scan_result","<string>")
success = json.UpdateString("ticket.comment.attachments[1].mapped_content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].size","<integer>")
success = json.UpdateString("ticket.comment.attachments[1].url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].width","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].content_type","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].deleted","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].file_name","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].height","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].id","<integer>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].inline","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].malware_access_override","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].malware_scan_result","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].mapped_content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].size","<integer>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[0].width","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].content_type","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].deleted","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].file_name","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].height","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].id","<integer>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].inline","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].malware_access_override","<boolean>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].malware_scan_result","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].mapped_content_url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].size","<integer>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].url","<string>")
success = json.UpdateString("ticket.comment.attachments[1].thumbnails[1].width","<string>")
success = json.UpdateString("ticket.comment.audit_id","<integer>")
success = json.UpdateString("ticket.comment.author_id","<integer>")
success = json.UpdateString("ticket.comment.body","<string>")
success = json.UpdateString("ticket.comment.created_at","<dateTime>")
success = json.UpdateString("ticket.comment.html_body","<string>")
success = json.UpdateString("ticket.comment.id","<integer>")
success = json.UpdateInt("ticket.comment.metadata.occaecat_2d1",-71498595)
success = json.UpdateNumber("ticket.comment.metadata.incididunt3","-68401909.632414")
success = json.UpdateInt("ticket.comment.metadata.nond",-22715203)
success = json.UpdateInt("ticket.comment.metadata.voluptate9e",-92868072)
success = json.UpdateString("ticket.comment.plain_body","<string>")
success = json.UpdateString("ticket.comment.public","<boolean>")
success = json.UpdateString("ticket.comment.type","<string>")
success = json.UpdateString("ticket.comment.uploads[0]","<string>")
success = json.UpdateString("ticket.comment.uploads[1]","<string>")
success = json.UpdateString("ticket.comment.via.channel","<string>")
success = json.UpdateNumber("ticket.comment.via.source.ut797","-65734664.31848694")
success = json.UpdateNumber("ticket.comment.via.source.incididunt_14a","54532844.54826489")
success = json.UpdateBool("ticket.comment.via.source.enim_2",0)
success = json.UpdateInt("ticket.comment.via.source.sed_ac",43217710)
success = json.UpdateString("ticket.additional_collaborators[0].email","<email>")
success = json.UpdateString("ticket.additional_collaborators[0].name","<string>")
success = json.UpdateString("ticket.additional_collaborators[1].email","<email>")
success = json.UpdateString("ticket.additional_collaborators[1].name","<string>")
success = json.UpdateString("ticket.assignee_email","<email>")
success = json.UpdateString("ticket.assignee_id","<integer>")
success = json.UpdateString("ticket.attribute_value_ids[0]","<integer>")
success = json.UpdateString("ticket.attribute_value_ids[1]","<integer>")
success = json.UpdateString("ticket.collaborator_ids","<array>")
success = json.UpdateString("ticket.custom_fields","<array>")
success = json.UpdateString("ticket.custom_status_id","<integer>")
success = json.UpdateString("ticket.due_at","<dateTime>")
success = json.UpdateString("ticket.email_ccs[0].action","put")
success = json.UpdateString("ticket.email_ccs[0].user_email","<email>")
success = json.UpdateString("ticket.email_ccs[0].user_id","<string>")
success = json.UpdateString("ticket.email_ccs[0].user_name","<string>")
success = json.UpdateString("ticket.email_ccs[1].action","delete")
success = json.UpdateString("ticket.email_ccs[1].user_email","<email>")
success = json.UpdateString("ticket.email_ccs[1].user_id","<string>")
success = json.UpdateString("ticket.email_ccs[1].user_name","<string>")
success = json.UpdateString("ticket.external_id","<string>")
success = json.UpdateString("ticket.followers[0].action","put")
success = json.UpdateString("ticket.followers[0].user_email","<email>")
success = json.UpdateString("ticket.followers[0].user_id","<string>")
success = json.UpdateString("ticket.followers[1].action","delete")
success = json.UpdateString("ticket.followers[1].user_email","<email>")
success = json.UpdateString("ticket.followers[1].user_id","<string>")
success = json.UpdateString("ticket.group_id","<integer>")
success = json.UpdateString("ticket.organization_id","<integer>")
success = json.UpdateString("ticket.priority","urgent")
success = json.UpdateString("ticket.problem_id","<integer>")
success = json.UpdateString("ticket.requester_id","<integer>")
success = json.UpdateString("ticket.safe_update","<boolean>")
success = json.UpdateString("ticket.sharing_agreement_ids[0]","<integer>")
success = json.UpdateString("ticket.sharing_agreement_ids[1]","<integer>")
success = json.UpdateString("ticket.status","closed")
success = json.UpdateString("ticket.subject","<string>")
success = json.UpdateString("ticket.tags","<array>")
success = json.UpdateString("ticket.type","task")
success = json.UpdateString("ticket.updated_stamp","<dateTime>")
success = json.UpdateString("ticket.brand_id","<integer>")
success = json.UpdateString("ticket.collaborators","<array>")
success = json.UpdateString("ticket.email_cc_ids","<array>")
success = json.UpdateString("ticket.follower_ids","<array>")
success = json.UpdateString("ticket.macro_ids","<array>")
success = json.UpdateString("ticket.raw_subject","<string>")
success = json.UpdateString("ticket.recipient","<string>")
success = json.UpdateString("ticket.submitter_id","<integer>")
success = json.UpdateString("ticket.ticket_form_id","<integer>")
success = json.UpdateString("ticket.via.channel","<string>")
success = json.UpdateString("ticket.via.source.from.address","<string>")
success = json.UpdateString("ticket.via.source.from.id","<integer>")
success = json.UpdateString("ticket.via.source.from.name","<string>")
success = json.UpdateString("ticket.via.source.from.title","<string>")
success = json.UpdateString("ticket.via.source.rel","<string>")
success = json.UpdateString("ticket.via.source.to.address","<string>")
success = json.UpdateString("ticket.via.source.to.name","<string>")
success = json.UpdateString("ticket.via_followup_source_id","<integer>")
http.SetRequestHeader "Content-Type","application/json"
http.SetRequestHeader "Accept","application/json"
Dim resp As ChilkatHttpResponse
Set resp = http.PostJson3("https://example.zendesk.com/api/v2/tickets","application/json",json)
If (http.LastMethodSuccess = 0) Then
Debug.Print http.LastErrorText
Exit Sub
End If
Dim sbResponseBody As New ChilkatStringBuilder
success = resp.GetBodySb(sbResponseBody)
Dim jResp As New ChilkatJsonObject
success = jResp.LoadSb(sbResponseBody)
jResp.EmitCompact = 0
Debug.Print "Response Body:"
Debug.Print jResp.Emit()
Dim respStatusCode As Long
respStatusCode = resp.StatusCode
Debug.Print "Response Status Code = " & respStatusCode
If (respStatusCode >= 400) Then
Debug.Print "Response Header:"
Debug.Print resp.Header
Debug.Print "Failed."
Exit Sub
End If
' Sample JSON response:
' (Sample code for parsing the JSON response is shown below)
' {
' "ticket": {
' "requester_id": "<integer>",
' "allow_attachments": "<boolean>",
' "allow_channelback": "<boolean>",
' "assignee_email": "<string>",
' "assignee_id": "<integer>",
' "attribute_value_ids": "<array>",
' "brand_id": "<integer>",
' "collaborator_ids": "<array>",
' "collaborators": [
' {
' "email": "<email>",
' "name": "<string>"
' },
' {
' "email": "<email>",
' "name": "<string>"
' }
' ],
' "comment": {},
' "created_at": "<dateTime>",
' "custom_fields": "<array>",
' "custom_status_id": "<integer>",
' "description": "<string>",
' "due_at": "<dateTime>",
' "email_cc_ids": "<array>",
' "email_ccs": {},
' "external_id": "<string>",
' "follower_ids": "<array>",
' "followers": {},
' "followup_ids": "<array>",
' "forum_topic_id": "<integer>",
' "from_messaging_channel": "<boolean>",
' "group_id": "<integer>",
' "has_incidents": "<boolean>",
' "id": "<integer>",
' "is_public": "<boolean>",
' "macro_id": "<integer>",
' "macro_ids": "<array>",
' "metadata": {},
' "organization_id": "<integer>",
' "priority": "normal",
' "problem_id": "<integer>",
' "raw_subject": "<string>",
' "recipient": "<string>",
' "requester": {},
' "safe_update": "<boolean>",
' "satisfaction_rating": {
' "in_11": -9796534.714120895
' },
' "sharing_agreement_ids": "<array>",
' "status": "hold",
' "subject": "<string>",
' "submitter_id": "<integer>",
' "tags": "<array>",
' "ticket_form_id": "<integer>",
' "type": "question",
' "updated_at": "<dateTime>",
' "updated_stamp": "<string>",
' "url": "<string>",
' "via": {
' "channel": "<string>",
' "source": {
' "Ut__a": -44750185.46031158,
' "dolored2b": 8252599,
' "mollit1a6": true
' }
' },
' "via_followup_source_id": "<integer>",
' "via_id": "<integer>",
' "voice_comment": {}
' }
' }
' Sample code for parsing the JSON response...
' Use this online tool to generate parsing code from sample JSON: Generate JSON Parsing Code
Dim email As String
Dim name As String
Dim Requester_id As String
Requester_id = jResp.StringOf("ticket.requester_id")
Dim Allow_attachments As String
Allow_attachments = jResp.StringOf("ticket.allow_attachments")
Dim Allow_channelback As String
Allow_channelback = jResp.StringOf("ticket.allow_channelback")
Dim Assignee_email As String
Assignee_email = jResp.StringOf("ticket.assignee_email")
Dim Assignee_id As String
Assignee_id = jResp.StringOf("ticket.assignee_id")
Dim Attribute_value_ids As String
Attribute_value_ids = jResp.StringOf("ticket.attribute_value_ids")
Dim Brand_id As String
Brand_id = jResp.StringOf("ticket.brand_id")
Dim Collaborator_ids As String
Collaborator_ids = jResp.StringOf("ticket.collaborator_ids")
Dim Created_at As String
Created_at = jResp.StringOf("ticket.created_at")
Dim Custom_fields As String
Custom_fields = jResp.StringOf("ticket.custom_fields")
Dim Custom_status_id As String
Custom_status_id = jResp.StringOf("ticket.custom_status_id")
Dim Description As String
Description = jResp.StringOf("ticket.description")
Dim Due_at As String
Due_at = jResp.StringOf("ticket.due_at")
Dim Email_cc_ids As String
Email_cc_ids = jResp.StringOf("ticket.email_cc_ids")
Dim External_id As String
External_id = jResp.StringOf("ticket.external_id")
Dim Follower_ids As String
Follower_ids = jResp.StringOf("ticket.follower_ids")
Dim Followup_ids As String
Followup_ids = jResp.StringOf("ticket.followup_ids")
Dim Forum_topic_id As String
Forum_topic_id = jResp.StringOf("ticket.forum_topic_id")
Dim From_messaging_channel As String
From_messaging_channel = jResp.StringOf("ticket.from_messaging_channel")
Dim Group_id As String
Group_id = jResp.StringOf("ticket.group_id")
Dim Has_incidents As String
Has_incidents = jResp.StringOf("ticket.has_incidents")
Dim Id As String
Id = jResp.StringOf("ticket.id")
Dim Is_public As String
Is_public = jResp.StringOf("ticket.is_public")
Dim Macro_id As String
Macro_id = jResp.StringOf("ticket.macro_id")
Dim Macro_ids As String
Macro_ids = jResp.StringOf("ticket.macro_ids")
Dim Organization_id As String
Organization_id = jResp.StringOf("ticket.organization_id")
Dim Priority As String
Priority = jResp.StringOf("ticket.priority")
Dim Problem_id As String
Problem_id = jResp.StringOf("ticket.problem_id")
Dim Raw_subject As String
Raw_subject = jResp.StringOf("ticket.raw_subject")
Dim Recipient As String
Recipient = jResp.StringOf("ticket.recipient")
Dim Safe_update As String
Safe_update = jResp.StringOf("ticket.safe_update")
Dim In_11 As String
In_11 = jResp.StringOf("ticket.satisfaction_rating.in_11")
Dim Sharing_agreement_ids As String
Sharing_agreement_ids = jResp.StringOf("ticket.sharing_agreement_ids")
Dim Status As String
Status = jResp.StringOf("ticket.status")
Dim Subject As String
Subject = jResp.StringOf("ticket.subject")
Dim Submitter_id As String
Submitter_id = jResp.StringOf("ticket.submitter_id")
Dim Tags As String
Tags = jResp.StringOf("ticket.tags")
Dim Ticket_form_id As String
Ticket_form_id = jResp.StringOf("ticket.ticket_form_id")
Dim v_Type As String
v_Type = jResp.StringOf("ticket.type")
Dim Updated_at As String
Updated_at = jResp.StringOf("ticket.updated_at")
Dim Updated_stamp As String
Updated_stamp = jResp.StringOf("ticket.updated_stamp")
Dim v_Url As String
v_Url = jResp.StringOf("ticket.url")
Dim Channel As String
Channel = jResp.StringOf("ticket.via.channel")
Dim Ut__a As String
Ut__a = jResp.StringOf("ticket.via.source.Ut__a")
Dim Dolored2b As Long
Dolored2b = jResp.IntOf("ticket.via.source.dolored2b")
Dim Mollit1a6 As Long
Mollit1a6 = jResp.BoolOf("ticket.via.source.mollit1a6")
Dim Via_followup_source_id As String
Via_followup_source_id = jResp.StringOf("ticket.via_followup_source_id")
Dim Via_id As String
Via_id = jResp.StringOf("ticket.via_id")
Dim i As Long
i = 0
Dim count_i As Long
count_i = jResp.SizeOfArray("ticket.collaborators")
Do While i < count_i
jResp.I = i
email = jResp.StringOf("ticket.collaborators[i].email")
name = jResp.StringOf("ticket.collaborators[i].name")
i = i + 1
Loop
Curl Command
curl -u login:password -X POST
-H "Content-Type: application/json"
-H "Accept: application/json"
-d '{
"ticket": {
"comment": {
"attachments": [
{
"content_type": "<string>",
"content_url": "<string>",
"deleted": "<boolean>",
"file_name": "<string>",
"height": "<string>",
"id": "<integer>",
"inline": "<boolean>",
"malware_access_override": "<boolean>",
"malware_scan_result": "<string>",
"mapped_content_url": "<string>",
"size": "<integer>",
"url": "<string>",
"width": "<string>",
"thumbnails": [
{
"content_type": "<string>",
"content_url": "<string>",
"deleted": "<boolean>",
"file_name": "<string>",
"height": "<string>",
"id": "<integer>",
"inline": "<boolean>",
"malware_access_override": "<boolean>",
"malware_scan_result": "<string>",
"mapped_content_url": "<string>",
"size": "<integer>",
"url": "<string>",
"width": "<string>"
},
{
"content_type": "<string>",
"content_url": "<string>",
"deleted": "<boolean>",
"file_name": "<string>",
"height": "<string>",
"id": "<integer>",
"inline": "<boolean>",
"malware_access_override": "<boolean>",
"malware_scan_result": "<string>",
"mapped_content_url": "<string>",
"size": "<integer>",
"url": "<string>",
"width": "<string>"
}
]
},
{
"content_type": "<string>",
"content_url": "<string>",
"deleted": "<boolean>",
"file_name": "<string>",
"height": "<string>",
"id": "<integer>",
"inline": "<boolean>",
"malware_access_override": "<boolean>",
"malware_scan_result": "<string>",
"mapped_content_url": "<string>",
"size": "<integer>",
"url": "<string>",
"width": "<string>",
"thumbnails": [
{
"content_type": "<string>",
"content_url": "<string>",
"deleted": "<boolean>",
"file_name": "<string>",
"height": "<string>",
"id": "<integer>",
"inline": "<boolean>",
"malware_access_override": "<boolean>",
"malware_scan_result": "<string>",
"mapped_content_url": "<string>",
"size": "<integer>",
"url": "<string>",
"width": "<string>"
},
{
"content_type": "<string>",
"content_url": "<string>",
"deleted": "<boolean>",
"file_name": "<string>",
"height": "<string>",
"id": "<integer>",
"inline": "<boolean>",
"malware_access_override": "<boolean>",
"malware_scan_result": "<string>",
"mapped_content_url": "<string>",
"size": "<integer>",
"url": "<string>",
"width": "<string>"
}
]
}
],
"audit_id": "<integer>",
"author_id": "<integer>",
"body": "<string>",
"created_at": "<dateTime>",
"html_body": "<string>",
"id": "<integer>",
"metadata": {
"occaecat_2d1": -71498595,
"incididunt3": -68401909.632414,
"nond": -22715203,
"voluptate9e": -92868072
},
"plain_body": "<string>",
"public": "<boolean>",
"type": "<string>",
"uploads": [
"<string>",
"<string>"
],
"via": {
"channel": "<string>",
"source": {
"ut797": -65734664.31848694,
"incididunt_14a": 54532844.54826489,
"enim_2": false,
"sed_ac": 43217710
}
}
},
"additional_collaborators": [
{
"email": "<email>",
"name": "<string>"
},
{
"email": "<email>",
"name": "<string>"
}
],
"assignee_email": "<email>",
"assignee_id": "<integer>",
"attribute_value_ids": [
"<integer>",
"<integer>"
],
"collaborator_ids": "<array>",
"custom_fields": "<array>",
"custom_status_id": "<integer>",
"due_at": "<dateTime>",
"email_ccs": [
{
"action": "put",
"user_email": "<email>",
"user_id": "<string>",
"user_name": "<string>"
},
{
"action": "delete",
"user_email": "<email>",
"user_id": "<string>",
"user_name": "<string>"
}
],
"external_id": "<string>",
"followers": [
{
"action": "put",
"user_email": "<email>",
"user_id": "<string>"
},
{
"action": "delete",
"user_email": "<email>",
"user_id": "<string>"
}
],
"group_id": "<integer>",
"organization_id": "<integer>",
"priority": "urgent",
"problem_id": "<integer>",
"requester_id": "<integer>",
"safe_update": "<boolean>",
"sharing_agreement_ids": [
"<integer>",
"<integer>"
],
"status": "closed",
"subject": "<string>",
"tags": "<array>",
"type": "task",
"updated_stamp": "<dateTime>",
"brand_id": "<integer>",
"collaborators": "<array>",
"email_cc_ids": "<array>",
"follower_ids": "<array>",
"macro_ids": "<array>",
"raw_subject": "<string>",
"recipient": "<string>",
"submitter_id": "<integer>",
"ticket_form_id": "<integer>",
"via": {
"channel": "<string>",
"source": {
"from": {
"address": "<string>",
"id": "<integer>",
"name": "<string>",
"title": "<string>"
},
"rel": "<string>",
"to": {
"address": "<string>",
"name": "<string>"
}
}
},
"via_followup_source_id": "<integer>"
}
}'
https://example.zendesk.com/api/v2/tickets
Postman Collection Item JSON
{
"name": "Create Ticket",
"request": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/json"
},
{
"key": "Accept",
"value": "application/json"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"ticket\": {\n \"comment\": {\n \"attachments\": [\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\",\n \"thumbnails\": [\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n },\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n }\n ]\n },\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\",\n \"thumbnails\": [\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n },\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n }\n ]\n }\n ],\n \"audit_id\": \"<integer>\",\n \"author_id\": \"<integer>\",\n \"body\": \"<string>\",\n \"created_at\": \"<dateTime>\",\n \"html_body\": \"<string>\",\n \"id\": \"<integer>\",\n \"metadata\": {\n \"occaecat_2d1\": -71498595,\n \"incididunt3\": -68401909.632414,\n \"nond\": -22715203,\n \"voluptate9e\": -92868072\n },\n \"plain_body\": \"<string>\",\n \"public\": \"<boolean>\",\n \"type\": \"<string>\",\n \"uploads\": [\n \"<string>\",\n \"<string>\"\n ],\n \"via\": {\n \"channel\": \"<string>\",\n \"source\": {\n \"ut797\": -65734664.31848694,\n \"incididunt_14a\": 54532844.54826489,\n \"enim_2\": false,\n \"sed_ac\": 43217710\n }\n }\n },\n \"additional_collaborators\": [\n {\n \"email\": \"<email>\",\n \"name\": \"<string>\"\n },\n {\n \"email\": \"<email>\",\n \"name\": \"<string>\"\n }\n ],\n \"assignee_email\": \"<email>\",\n \"assignee_id\": \"<integer>\",\n \"attribute_value_ids\": [\n \"<integer>\",\n \"<integer>\"\n ],\n \"collaborator_ids\": \"<array>\",\n \"custom_fields\": \"<array>\",\n \"custom_status_id\": \"<integer>\",\n \"due_at\": \"<dateTime>\",\n \"email_ccs\": [\n {\n \"action\": \"put\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\",\n \"user_name\": \"<string>\"\n },\n {\n \"action\": \"delete\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\",\n \"user_name\": \"<string>\"\n }\n ],\n \"external_id\": \"<string>\",\n \"followers\": [\n {\n \"action\": \"put\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\"\n },\n {\n \"action\": \"delete\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\"\n }\n ],\n \"group_id\": \"<integer>\",\n \"organization_id\": \"<integer>\",\n \"priority\": \"urgent\",\n \"problem_id\": \"<integer>\",\n \"requester_id\": \"<integer>\",\n \"safe_update\": \"<boolean>\",\n \"sharing_agreement_ids\": [\n \"<integer>\",\n \"<integer>\"\n ],\n \"status\": \"closed\",\n \"subject\": \"<string>\",\n \"tags\": \"<array>\",\n \"type\": \"task\",\n \"updated_stamp\": \"<dateTime>\",\n \"brand_id\": \"<integer>\",\n \"collaborators\": \"<array>\",\n \"email_cc_ids\": \"<array>\",\n \"follower_ids\": \"<array>\",\n \"macro_ids\": \"<array>\",\n \"raw_subject\": \"<string>\",\n \"recipient\": \"<string>\",\n \"submitter_id\": \"<integer>\",\n \"ticket_form_id\": \"<integer>\",\n \"via\": {\n \"channel\": \"<string>\",\n \"source\": {\n \"from\": {\n \"address\": \"<string>\",\n \"id\": \"<integer>\",\n \"name\": \"<string>\",\n \"title\": \"<string>\"\n },\n \"rel\": \"<string>\",\n \"to\": {\n \"address\": \"<string>\",\n \"name\": \"<string>\"\n }\n }\n },\n \"via_followup_source_id\": \"<integer>\"\n }\n}",
"options": {
"raw": {
"headerFamily": "json",
"language": "json"
}
}
},
"url": {
"raw": "{{baseUrl}}/api/v2/tickets",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"tickets"
]
}
},
"response": [
{
"name": "Create ticket",
"originalRequest": {
"method": "POST",
"header": [
{
"key": "Content-Type",
"value": "application/json"
},
{
"description": "Added as a part of security scheme: basic",
"key": "Authorization",
"value": "Basic <credentials>"
}
],
"body": {
"mode": "raw",
"raw": "{\n \"ticket\": {\n \"comment\": {\n \"attachments\": [\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\",\n \"thumbnails\": [\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n },\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n }\n ]\n },\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\",\n \"thumbnails\": [\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n },\n {\n \"content_type\": \"<string>\",\n \"content_url\": \"<string>\",\n \"deleted\": \"<boolean>\",\n \"file_name\": \"<string>\",\n \"height\": \"<string>\",\n \"id\": \"<integer>\",\n \"inline\": \"<boolean>\",\n \"malware_access_override\": \"<boolean>\",\n \"malware_scan_result\": \"<string>\",\n \"mapped_content_url\": \"<string>\",\n \"size\": \"<integer>\",\n \"url\": \"<string>\",\n \"width\": \"<string>\"\n }\n ]\n }\n ],\n \"audit_id\": \"<integer>\",\n \"author_id\": \"<integer>\",\n \"body\": \"<string>\",\n \"created_at\": \"<dateTime>\",\n \"html_body\": \"<string>\",\n \"id\": \"<integer>\",\n \"metadata\": {\n \"occaecat_2d1\": -71498595,\n \"incididunt3\": -68401909.632414,\n \"nond\": -22715203,\n \"voluptate9e\": -92868072\n },\n \"plain_body\": \"<string>\",\n \"public\": \"<boolean>\",\n \"type\": \"<string>\",\n \"uploads\": [\n \"<string>\",\n \"<string>\"\n ],\n \"via\": {\n \"channel\": \"<string>\",\n \"source\": {\n \"ut797\": -65734664.31848694,\n \"incididunt_14a\": 54532844.54826489,\n \"enim_2\": false,\n \"sed_ac\": 43217710\n }\n }\n },\n \"additional_collaborators\": [\n {\n \"email\": \"<email>\",\n \"name\": \"<string>\"\n },\n {\n \"email\": \"<email>\",\n \"name\": \"<string>\"\n }\n ],\n \"assignee_email\": \"<email>\",\n \"assignee_id\": \"<integer>\",\n \"attribute_value_ids\": [\n \"<integer>\",\n \"<integer>\"\n ],\n \"collaborator_ids\": \"<array>\",\n \"custom_fields\": \"<array>\",\n \"custom_status_id\": \"<integer>\",\n \"due_at\": \"<dateTime>\",\n \"email_ccs\": [\n {\n \"action\": \"put\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\",\n \"user_name\": \"<string>\"\n },\n {\n \"action\": \"delete\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\",\n \"user_name\": \"<string>\"\n }\n ],\n \"external_id\": \"<string>\",\n \"followers\": [\n {\n \"action\": \"put\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\"\n },\n {\n \"action\": \"delete\",\n \"user_email\": \"<email>\",\n \"user_id\": \"<string>\"\n }\n ],\n \"group_id\": \"<integer>\",\n \"organization_id\": \"<integer>\",\n \"priority\": \"urgent\",\n \"problem_id\": \"<integer>\",\n \"requester_id\": \"<integer>\",\n \"safe_update\": \"<boolean>\",\n \"sharing_agreement_ids\": [\n \"<integer>\",\n \"<integer>\"\n ],\n \"status\": \"closed\",\n \"subject\": \"<string>\",\n \"tags\": \"<array>\",\n \"type\": \"task\",\n \"updated_stamp\": \"<dateTime>\",\n \"brand_id\": \"<integer>\",\n \"collaborators\": \"<array>\",\n \"email_cc_ids\": \"<array>\",\n \"follower_ids\": \"<array>\",\n \"macro_ids\": \"<array>\",\n \"raw_subject\": \"<string>\",\n \"recipient\": \"<string>\",\n \"submitter_id\": \"<integer>\",\n \"ticket_form_id\": \"<integer>\",\n \"via\": {\n \"channel\": \"<string>\",\n \"source\": {\n \"from\": {\n \"address\": \"<string>\",\n \"id\": \"<integer>\",\n \"name\": \"<string>\",\n \"title\": \"<string>\"\n },\n \"rel\": \"<string>\",\n \"to\": {\n \"address\": \"<string>\",\n \"name\": \"<string>\"\n }\n }\n },\n \"via_followup_source_id\": \"<integer>\"\n }\n}",
"options": {
"raw": {
"headerFamily": "json",
"language": "json"
}
}
},
"url": {
"raw": "{{baseUrl}}/api/v2/tickets",
"host": [
"{{baseUrl}}"
],
"path": [
"api",
"v2",
"tickets"
]
}
},
"status": "Created",
"code": 201,
"_postman_previewlanguage": "json",
"header": [
{
"key": "Content-Type",
"value": "application/json"
},
{
"key": "Location",
"value": "<string>",
"description": {
"content": "The URL of the created ticket",
"type": "text/plain"
}
}
],
"cookie": [
],
"body": "{\n \"ticket\": {\n \"requester_id\": \"<integer>\",\n \"allow_attachments\": \"<boolean>\",\n \"allow_channelback\": \"<boolean>\",\n \"assignee_email\": \"<string>\",\n \"assignee_id\": \"<integer>\",\n \"attribute_value_ids\": \"<array>\",\n \"brand_id\": \"<integer>\",\n \"collaborator_ids\": \"<array>\",\n \"collaborators\": [\n {\n \"email\": \"<email>\",\n \"name\": \"<string>\"\n },\n {\n \"email\": \"<email>\",\n \"name\": \"<string>\"\n }\n ],\n \"comment\": {},\n \"created_at\": \"<dateTime>\",\n \"custom_fields\": \"<array>\",\n \"custom_status_id\": \"<integer>\",\n \"description\": \"<string>\",\n \"due_at\": \"<dateTime>\",\n \"email_cc_ids\": \"<array>\",\n \"email_ccs\": {},\n \"external_id\": \"<string>\",\n \"follower_ids\": \"<array>\",\n \"followers\": {},\n \"followup_ids\": \"<array>\",\n \"forum_topic_id\": \"<integer>\",\n \"from_messaging_channel\": \"<boolean>\",\n \"group_id\": \"<integer>\",\n \"has_incidents\": \"<boolean>\",\n \"id\": \"<integer>\",\n \"is_public\": \"<boolean>\",\n \"macro_id\": \"<integer>\",\n \"macro_ids\": \"<array>\",\n \"metadata\": {},\n \"organization_id\": \"<integer>\",\n \"priority\": \"normal\",\n \"problem_id\": \"<integer>\",\n \"raw_subject\": \"<string>\",\n \"recipient\": \"<string>\",\n \"requester\": {},\n \"safe_update\": \"<boolean>\",\n \"satisfaction_rating\": {\n \"in_11\": -9796534.714120895\n },\n \"sharing_agreement_ids\": \"<array>\",\n \"status\": \"hold\",\n \"subject\": \"<string>\",\n \"submitter_id\": \"<integer>\",\n \"tags\": \"<array>\",\n \"ticket_form_id\": \"<integer>\",\n \"type\": \"question\",\n \"updated_at\": \"<dateTime>\",\n \"updated_stamp\": \"<string>\",\n \"url\": \"<string>\",\n \"via\": {\n \"channel\": \"<string>\",\n \"source\": {\n \"Ut__a\": -44750185.46031158,\n \"dolored2b\": 8252599,\n \"mollit1a6\": true\n }\n },\n \"via_followup_source_id\": \"<integer>\",\n \"via_id\": \"<integer>\",\n \"voice_comment\": {}\n }\n}"
}
]
}
