Exporting Zendesk Ticket Details to External SQL Database | Community
Skip to main content

Exporting Zendesk Ticket Details to External SQL Database

  • April 13, 2015
  • 3 replies
  • 0 views
M

I'm interested to find out if anyone is exporting ticket details from Zendesk for use in an external SQL database.  We are starting  to use Zendesk, but we must also maintain details of some ticket types within an existing SQL database.  To avoid duplication of effort, I wondered if anyone had used the XML export to the extent where only updated records in Zendesk of the specific ticket type(s) could be extracted.

As far as I can tell, currently, Zendesk simply exports data for ALL the tickets, not just new or updated.

Any tools out there we could use or thoughts on how this might be possible?

    This topic has been closed for replies.

    3 replies

    C
    • Colin17
    • April 13, 2015

    Mike, I don't do this but if I were to I would probably us an http target to send the ticket data to a webservice that pushed the data in to the SQL database. 

    Every time a ticket was created, some of the detail would also be pushed to the database much like the sales force addin does.

    A
    • Anonymous
    • June 22, 2016

    Hi Mike, just pop-ed (and as I am co-founder of Blendo, a self-serve data management tool that does exactly what you say). With Blendo you may connect to Zendesk and send your data consistently to a database like PostgreSQL or to Redshift/MS SQL. You could check it out if you want just ping me.

    W
    • Willy13
    • June 23, 2018

    Hi there,

    To export all your ticket details from Zendesk to an external SQL database (SQL Server, MySQL, PostgreSQL, etc.) take a look at Skyvia. It is a cloud-based solution for no-coding integration that supports all type of CRUD operations including UPSERT, that will help you to avoid duplicates.

    Terms & ConditionsCookie settingsAccessibility statement