Visit Freshworks.com Visit Freshworks

Replies posted by j.gouesse

8 Replies

M
Apprentice
mustaphaApprentice
posted in Archives - Freshdesk

Export all tickets to a Google Sheet using the API

Hi Get the list of all tickets by using the appropriate entry point as indicated here, you can use some filters to get some of the tickets. You can use my source code and adapt it to make it work with the version 2 of the API. You have to call this code several times as the results are paginated, each page contains at most 30 tickets (default value, can be modified). Then, write '\ufeff' at the very beginning of your CSV file so that Microsoft Excel understands that your sheet uses UTF-8. Maybe this step is optional for Google Sheets. After that, loop on each ticket, take care of the special characters (especially new line characters), write each field value of a ticket in this file separated by commas and write a new line for each ticket.

11
J
Community Debut
5 years ago
M
Apprentice
mustaphaApprentice
posted in Archives - Freshdesk

Export all tickets to a Google Sheet using the API

Note that Flatly is neither open source nor free of charge (except for a 14-day trial period or by using Slemma). If somebody needs some help, I can provide a more detailed example using the version 2 of the API.

11
J
Community Debut
5 years ago
Z
Apprentice
zbindenApprentice
posted in Archives - Freshdesk

MS Edge Copy Paste with Clipboard doesn't work

This bug is reproducible in Mozilla Firefox too.

33
aravind.sundararajan
Skilled Expert
4 years ago
Z
Apprentice
zbindenApprentice
posted in Archives - Freshdesk

MS Edge Copy Paste with Clipboard doesn't work

No it doesn't. This problem was already occurring with the previous version of Mozilla Firefox I was using four weeks ago. I've just switched to Mozilla Firefox 55 today and the situation is identical. Moreover, according to the log messages, your own source code is to blame, there's a bad management of cross-domain requests. Switching back to an older version of a web browser can't be an acceptable workaround as it exposes the end users to security flaws fixed in the latest version.

33
aravind.sundararajan
Skilled Expert
4 years ago
Z
Apprentice
zbindenApprentice
posted in Archives - Freshdesk

MS Edge Copy Paste with Clipboard doesn't work

 Thank you. It seems to work. I've just tested with Mozilla Firefox 55.0.3 32-bit.

33
aravind.sundararajan
Skilled Expert
4 years ago
M
Apprentice
mustaphaApprentice
posted in Archives - Freshdesk

Export all tickets to a Google Sheet using the API

I think this is the way to go:https://stackoverflow.com/a/29330280

11
J
Community Debut
5 years ago
M
Apprentice
mustaphaApprentice
posted in Archives - Freshdesk

Export all tickets to a Google Sheet using the API

Have you looked at my source code above? Your last problem might be a bug but it doesn't prevent me from getting the keys and the values. Why not filling a bug report?

11
J
Community Debut
5 years ago
M
Apprentice
mustaphaApprentice
posted in Archives - Freshdesk

Export all tickets to a Google Sheet using the API

You need to use the filters. I remind that the results are paginated (see the "per_page" and "page" filters) and you only see the tickets created within the past 30 days by default except if you use the "updated_since" filter. You might have to use the "include" filter to get some additional fields. Of course, you'll have to make some requests to get some information about the requesters and responders as the request on the tickets returns the requester id and the responder id.

11
J
Community Debut
5 years ago

Badge winners

Show all badges
Terms of UseCookie settings