Conversations as rows
Ticket replies arrive as their own table with HTML and plain text bodies.
Freshdesk
Polytomic connects Freshdesk to your data warehouse, databases, and SaaS tools for support ETL and reverse ETL. Replicate tickets, conversations, contacts, and companies into your data warehouse and other systems, and write enriched contact and company data back into Freshdesk, without writing code.
Custom fields typed
Discovered from your Freshdesk config and coerced to real types.
Enrich contacts and companies
Write attributes from your data warehouse back onto Freshdesk records.
Example workflows
Replicate Freshdesk tickets and conversations into your data warehouse
What you can sync
Move data between Freshdesk and your data warehouse, databases, and SaaS tools, reading the support object model out and writing contacts and companies back in.
From Freshdesk
Tickets with their custom field values
Conversations with HTML and plain text bodies and attachments
Contacts and companies
Agents and ticket forms
Custom field definitions with type coercion
To Freshdesk
Contacts, created and updated
Companies, created and updated
Create only, update only, and create or update
Matching contacts on email, phone, mobile, or Twitter ID
Separate field mappings for creates and updates
How it works
Connect Freshdesk with an API key and your subdomain, then sync in either direction. Pull tickets, conversations, contacts, and companies into your data warehouse so support volume can be joined to revenue, or write attributes back so agents see plan and usage context on the record.
Conversations come through as their own table linked by ticket ID rather than nested inside tickets, carrying both the HTML and plain text body plus attachment metadata. That is the shape you want if you plan to analyze what was actually written.
- Connect Freshdesk with an API key and your subdomain
- Read tickets, conversations, contacts, companies, agents, and ticket forms
- Get custom fields discovered and coerced to real types
- Write contacts and companies with create, update, or upsert
- Use separate field mappings for creates versus updates
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic authenticates to Freshdesk using basic authentication with your API key. You also supply your Freshdesk subdomain, which is used to build the request host.
How to get connected
- 1In Freshdesk, generate an API key from your profile settings
- 2Note your Freshdesk subdomain
- 3In Polytomic, navigate to Connections, then Add Connection, then Freshdesk
- 4Enter the subdomain and API key
- 5Test the connection
- 6Select the objects you want to sync and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Freshdesk in minutes
No credit card required. Free trial available.