Access Zendesk in Excel


This connector suite retrieves data from Zendesk Core API.

Groups

Lists Zendesk user groups

Fields

  • ID - Group ID
  • Url - Group URL
  • Name - Group name
  • Deleted - Whether group is deleted
  • Created - Date and time of creation
  • Updated - Date and time of last update

Organizations

Lists Zendesk customer organizations

Fields

  • ID - Organization ID
  • Url - Organization URL
  • Name - Organization name
  • External ID - A unique external id to associate organizations to an external record
  • Created - Date and time of creation
  • Updated - Date and time of last update
  • Domain names - An list of domain names associated with this organization
  • Details - Organization details
  • Notes - Additional notes
  • Group ID - New tickets from users in this organization are automatically put in this group
  • Tags - Tags assigned to organization

Search tickets

Search and filter Zendesk tickets.

Parameters

  • Search ticket subject - Search for text in ticket subject
  • Search ticket description - Search for text in ticket description
  • Status - Ticket status - All, New, Open, Pending, Hold, Solved, Closed
  • Ticket Type - All, Question, Incident, Problem, Ask
  • Priority - Ticket priority - All, Low, Normal, High, Urgent
  • Via - How ticket was originally created - Mail , Get Satisfaction , Dropbox , Chat , Twitter DM , Twitter Fav , Twitter Like , Twitter , Voicemail , Phone Call Inbound , Phone Call Outbound , Phone , Sms , Api , Logmein , Facebook Post , Facebook Message , Facebook , Web , All
  • Created After - Show tickets only created after this date
  • Created Before - Show tickets only created before this date
  • Sort By (required) - Created, Commented, Priority, Status, Ticket Type
  • Sort Direction - Ascending/Descending

Fields

  • ID
  • Url
  • Type
  • Subject
  • Description
  • Priority
  • Status
  • Created
  • Updated
  • Due
  • Recipient
  • Requester ID
  • Submitter ID
  • Assignee ID
  • Organization ID
  • Group ID
  • Collaborator IDs
  • Follower IDs
  • Forum Topic ID
  • Problem ID
  • Is a problem
  • Tags
  • Satisfaction Rating
  • Public
  • External ID
  • Via

Ticket comments

Lists ticket comments.

Parameters

  • Ticket ID (required) - Ticket ID
  • Sort Order - Ascending/Descending

Fields

  • ID
  • Type
  • Author ID
  • Body
  • HTML Body
  • Public
  • Author ID
  • Created

Ticket metrics

Lists ticket metrics.

Fields

  • ID
  • Ticket ID
  • Url
  • Created - Date
  • Updated - Date
  • Group Stations - Number of groups this ticket passed through
  • Assignee Stations - Number of assignees this ticket had
  • Reopens
  • Replies
  • Assignee Updated - Date
  • Requester Updated - Date
  • Status Updated - Date
  • Initially Assigned - Date
  • Last Assigned - Date
  • Solved at - Date
  • Latest Comment - Date
  • First Resolution Time(min) - number of minutes; only business days are counted.
  • Reply Time(min) - number of minutes; only business days are counted.
  • Full Resolution Time(min) - number of minutes; only business days are counted.
  • Agent Wait Time(min) - number of minutes; only business days are counted.
  • Requester Wait Time(min) - number of minutes; only business days are counted.

Ticket Skips

Lists ticket skips (records of when agents skip over tickets without responding).

Parameters

  • Filter by user ID

Fields

  • ID
  • Ticket ID
  • User ID
  • Reason
  • Created
  • Updated
  • Ticket Subject
  • Ticket Description

Tickets

Lists Zendesk tickets.

Parameters

  • Filter by user ID
  • User Filter Type - Filter particular status for user ID specified above CC'd, Assigned, Requested
  • Sort By (required) - Created , Updated , Assignee , Assignee Name , Group , Id , Locale , Requester , Requester Name , Status , Subject
  • Sort Direction - Ascending, Descending

Fields

  • ID
  • Url
  • Type
  • Subject
  • Description
  • Priority
  • Status
  • Created
  • Updated
  • Due
  • Recipient
  • Requester ID
  • Submitter ID
  • Assignee ID
  • Organization ID
  • Group ID
  • Collaborator IDs
  • Follower IDs
  • Forum Topic ID
  • Problem ID
  • Is a problem
  • Tags
  • Satisfaction Rating
  • Public
  • External ID
  • Via

Users

Lists all Zendesk users (including end-users).

Fields

  • ID
  • Email
  • Name
  • Active
  • Alias
  • Chat-only Agent
  • Role Type
  • Details
  • Locale
  • Moderator
  • Notes
  • Organization Id
  • Phone
  • Role
  • Signature
  • Suspended
  • Tags
  • Ticket Restriction
  • Time Zone
  • 2 factor Auth
  • Url
  • Verified
  • Created
  • Updated
  • Last Login

Access

Add from Manager

The Zendesk Connector is available in the Connectors Manager in the top ribbon:

Head over to the CRM and install Zendesk:

Get API keys

To use the Connector you need a Zendesk API Key


Contribute

This connector suite is open-sourced on GitHub.


See

Official Documentation

Zendesk Core API


Get help with this function in the community →