Freshdesk Connector


Hi Dojo,
Has anybody used the freshdesk connector ?
In it, there is a dataset called 'List of Tickets' containing most of the columns I need but I can't seem to find some columns related to 'Ticket Close Date/Time' and 'Ticket Resolve Date/Time' as well as any Duration metrics.
Thanks
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'
Comments
-
Hello Godiepi,
I too have the same query, and I see in the dataset that there is a column called status, I believe it says if the ticket is closed or not, but it is coded in numbers, can you help me in finding out how to get a status column with ticket reloved, pending or closed items.
0 -
Hi @adithya
You can refer to their API documentation: https://developers.freshdesk.com/api/#list_all_tickets (Search for 'Ticket Properties')
Open: 2
Pending: 3
Resolved: 4
Closed: 5
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
@Godiepi - It appears they don't have a closed at field as part of their API documention. The closest you can likely get is to check the updated_at field when a ticket has a status value of 4 or 5. This will cause the ticket to lose the resolved time if it ever becomes closed. You'll likely need to talk with Freshdesk to see if they have any other way to get what you're looking for.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 815 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 45 Variables
- 775 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 81 Workflows
- 23 Code Engine
- 40 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 144 Manage
- 140 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive