Sync Freshservice Data
to Flat Files
& Spreadsheets
Automatically sync your Freshservice data to cloud storage and spreadsheets with Flatly's no-code, triggerless, turnkey integration service.
About the integration: Freshservice is a cloud-based IT Help Desk and service management solution that enables organizations to simplify their IT operations. The solution offers features that include a ticketing system, self-service portal and knowledge-base. Flatly integrates with Freshservice's official APIs.
Available Datasets
Flatly can sync the following datasets from Freshservice.
- Agents
- Agent Roles
- Agent Groups
- Assets
- Assets+Components Combo
- Assets+Requests Combo
- Assets+Contracts Combo
- Asset Types
- Changes-All
- Changes by Filter
- Departments
- Locations
- Products
- Projects
- Projects+Tasks Combo
- Releases
- Requesters
- ServiceRequests+Items-Alltime Combo
- ServiceRequests+Items-Last X days Combo Date-ranged
- Tickets+Requesters-Alltime Combo
- Tickets+Requesters-Last X days Combo Date-ranged
- Tickets+Conversations-Alltime Combo
- Tickets+Conversations-Last X days Combo Date-ranged
- Tickets+TimeEntries-Alltime Combo
- Tickets+TimeEntries-Last X days Combo Date-ranged
- Vendors
Send Freshservice data to
Flatly can sync Freshservice data to any of these destinations.
- Airtable Airtable
- Amazon S3 XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Azure Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Box XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- CSV
- Cloud Storage
- Dropbox XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Excel
- Excel Online XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- FTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google BigQuery NDJSON
- Google Cloud Storage XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Drive Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Google Looker Studio
- Google Sheets Google Sheets (Parsed) Google Sheets (Raw) XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Looker NDJSON
- Markdown
- Microsoft Power BI
- OneDrive XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- OneDrive for Business XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SFTP XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- SharePoint XLSX (Parsed) XLSX (Raw) CSV (Parsed) CSV (Raw) NDJSON Markdown (Table) Markdown (Key-Value)
- Smartsheet Smartsheet
- Zoho Sheet Zoho Sheet
Note: Some destinations are aliased, for intents and purposes they are functionally equivalent.
Freshservice
What are Combo Data Sets?
Flatly's pre-blended combo data sets from Freshservice are some of the most comprehensive in the industry. They take slightly longer to process, but their utility in a business intelligence context is unparalleled. These data sets are automatically presented in a left-joined format, with parent data sets repeated and child data sets unique to each row. This enables an analyst to examine individual child records with vital context from the parent records, without doing any additional blending or mapping.
What is the Analytics Export?
The Universal JSON Data Source in Flatly can be used to automatically extract the Scheduled Data Export JSON provided by Freshservice for custom use cases that go beyond the standard data resources provided by the Freshservice API. Flatly will try to automatically detect keys and values and produce a useful table. Additional layout options are available with assistance from Flatly Support.