Zendesk API Import

Attached a PDF with the full description.

EBANX is a cross border payment processor, placed in Brazil but with global operations. We make it possible to local customers (from Brazil, Mexico, Colombia, Chile and Peru) buy from Merchants abroad (like Sony, AliExpress, Airbnb and Spotify) using local payment methods.

We have several points from which customers can interact with our Customer Services agents, such as our website - [url removed, login to view], blogs - [url removed, login to view] and e-wallet - https://conta.ebanx.com.

We are now migrating our HelpDesk process to Zendesk ([url removed, login to view]), and need to fetch data from it automatically. Basically, Zendesk is a cloud-based CRM software where we integrate our customer services channels: E-mail, Telephone, Chat, Facebook and Twitter.

Phase 01 – Zendesk to MySQL

Import Zendesk data to a MySQL database.


We need the Zendesk data available in a local database in order to do queries and import it to a BI tool.

The deliverable is a script that we can run once to import all historical data available, and then on a daily basis to get all new data incrementally.

This is possible using the Zendesk’s API: [url removed, login to view]

Ticket ID: Identifier created by Zendesk for each ticket;

Origin (Via): Description of the ticket origin (E-mail, Chat, Phone, Facebook or Twitter);

Customer E-mail: End user e-mail address;

Date/hour when ticket was:

Created: Time when the ticket was imported on Zendesk;

Updated: Time when the ticket was updated by end user or Zendesk Agent (status changes). It can happen more than once;

1st response: Time when the ticket had its first answer;

Solved: Time when case status was updated to “Solved”. It can happen more than once;

Replies: The total number of interactions the ticket had (inbound and outbound);

Ticket fields: Customized classification. Each one has some specific info inside it.

“1. Merchant” - Example: "Brasil::Top 10::AliExpress", "Mexico::Wish";

“2. Produto”: "Cartão", "Boleto Bancário";

“[url removed, login to view]”: "Entrega::Quem Entrega", "Risco::Fraude";

“[url removed, login to view]”: "Dúvida", "Problema";

“[url removed, login to view]”: "E-mail Duplicado", "EBANX::Internos EBANX";

Tags: Tickets identifiers inserted automatically by Zendesk or manually by the agents;

Chat Satisfaction: Zopim Chat satisfaction rates: Good or Bad;


First Response Time: Date and time of the agent first response;

Average of First Response Time;

Maximum of First Response Time;

Minimum of First Response Time;

Average Duration: Average conversation duration;

Maximum Duration;

Minimum Duration;

Maximum of Average Response Time;

Average Response Time;

Minimum of Average Response Time;

Missed Chats: Number of unanswered requests;


Inbound and Outbound: Number of Phone interactions;

Call Status: Current status of the ticket (Resolved, Pending…);

Waiting Time: Waiting time until an agent answer the phone;

Wrap up time: Duration time between the call end and the manual status update by the agent;

Minutes: Total duration of the call;

1.2 Form to create new Zendesk tickets.


We need to make it possible to customers to open new tickets directly from our website, blog and e-wallet.

This is possible using the Zendesk’s API: [url removed, login to view]

Technical description:

Front-end: A simple form (HTML5, CSS and JS) that will be plugged in our sites and blogs in order to open new Zendesk tickets.

The infos we get on our side are:

Customer name;

Customer CPF (ID code);

Customer e-mail;

PIN (Order code);

Text (Customer observations).

Backend: The communication with the API is done on the backend side - we need it on Ruby or PHP. Only a simple script that works (handle the communication with the API) is needed, there’s no need to use any framework (e.g.: Rails), etc.

Beceriler: PHP, Ruby

Daha fazlasını gör: magento product import api, magento import api, xml import api soap prestashop, indesign xml import api, import folder recently created database mysql, gmail contact import api, facebook contact import api script php, net excel import api, vtiger import api, outlook contacts import api, import api feeds, import api quickbooks, oscommerce data import api, myemma import api, website created dreamweaver can updated pagemaker, yahoo maps flash api russia, system tray example application api, api interface ebay, google api map generatot, monster api

İşveren Hakkında:
( 2 değerlendirme ) Curitiba, Brazil

Proje NO: #11951995



Hi, We can create frontend forms to create tickets on zendesk from within your system using the ZenDesk Rest api. We will communicate with the api using PHP backend script. We can go over the details via chat - We've d Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 333%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(65 Değerlendirme)

Bu iş için 12 freelancer ortalamada $686 teklif veriyor


Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde555%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(223 Değerlendirme)

Dear Client, Greetings from Flowgica technologies, I have experience with these skills. We do have similar experience doing something similar to yours therefore I am looking forward to discuss and move ahead. please ch Daha Fazla

in %bids___i_period_sub_35% gün içinde330%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(39 Değerlendirme)

Hi, I can do your job but need to make a short chat discussion with you. let me know if possible for you. please let me know. You can check my profile and feedbacks of clients which itself I got from them . Hope the Daha Fazla

in %bids___i_period_sub_35% gün içinde2694%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(52 Değerlendirme)
in %bids___i_period_sub_35% gün içinde1000%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(102 Değerlendirme)

Hello , I'm good with Zendesk, Sorry but I have not found any pdf attached. Please send the PDF. Thanks , Sandeep

in %bids___i_period_sub_35% gün içinde472%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(27 Değerlendirme)

Hello, I am graduated software engineer and professional Rails developer for more than 5 years. If you want consistent & robust system, please consider me. You can check my profile reviews to see happy clients. Thanks!

in %bids___i_period_sub_35% gün içinde472%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(28 Değerlendirme)

Hello Sir, We are a development company India here. data published here were reviewed and want more clarification on it, so the message we talk about something else you will be able to move in it. Thank you

in %bids___i_period_sub_35% gün içinde366%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(8 Değerlendirme)

Hi, Would be nice to discuss project details. I have vast experience in complex web applications development from scratch, you may check some of the recent RoR projects: [login to view URL] [login to view URL] Daha Fazla

in %bids___i_period_sub_35% gün içinde472%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

Sounds like a straightforward project. From your detailed specs I should be able to get started right away. Do you have any language preferences about the script that pulls the data and writes to MySQL? I would general Daha Fazla

in %bids___i_period_sub_35% gün içinde350%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)

I have gone through your project description. I am ready to work with you as you approve me, I will start the work. But Before start the things I need to discuss regarding the project so we will be on same platform Daha Fazla

in %bids___i_period_sub_35% gün içinde472%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(4 Değerlendirme)

WARNING: Our bid is based on the average price, Contact us to negotiate the price you want! We are a company from Caracas-Venezuela specialized in different areas of engineering linked by the collaborative philoso Daha Fazla

in %bids___i_period_sub_35% gün içinde472%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)

I have already worked with zendesk restful API and have done almost the similar work as you want to integrate. Please view [login to view URL] Categorizer is an application built for categorizing Ze Daha Fazla

in %bids___i_period_sub_35% gün içinde388%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)

I have 8 years of experience with Zendesk and the Zendesk API. As one of their original customers, I have built numerous customized integrations with their REST API for my own personal support pages. I can easily do Daha Fazla

in %bids___i_period_sub_35% gün içinde777%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)