Connectors → Freshservice

About Freshservice

Freshservice is a cloud information technology service desk solution that provides incident management, asset management, release management, and service catalog features.

Freshservice Connector

With the Freshservice connector, you can ingest data that the Freshservice API exposes into Incorta for descriptive, diagnostic, explorative, and predictive analysis. The connector utilizes the Freshservice Application Programming Interface (API), a REpresentational State Transfer (REST) API.

For example, using the Freshservice connector and Incorta, you can easily analyze ticket and asset data in order to monitor service desk performance and improve service delivery.

The Freshservice connector supports the following Incorta specific functionality:

Feature Supported
Incremental loading
Encryption at ingest
Performance Optimization
Webhook Callbacks

Freshservice API

The Freshservice connector support two versions of the Freshservice API:

Recommendation

For Release 4.4 and higher, Incorta recommends using the Freshservice API v2.

As a REST API, a HTTP requests may retrieve table metadata or transactional data. Data is in JavaScript Object Notation (JSON) format. JSON may contain key values, nested objects, and object arrays.

The Freshservice API does not support the dynamic discovery of entities and fields. It is not possible to select specific fields or write advanced queries.


Steps to connect Freshservice and Incorta

To connect Freshservice and Incorta, here are the high level steps, tools, and procedures :

Create an external data source

Here are the steps to create a external data source with the Freshservice connector:

  • Sign in to the Incorta Direct Data Platform.
  • In the Navigation bar, select Data.
  • In the Action bar, select + NewAdd Data Source.
  • In the Choose a Data Source dialog, in Application, select Freshservice.
  • In the New Data Source dialog, specify the applicable connector properties for the selected API version.
  • To test, select Test Connection.
  • Select Ok to save your changes.

Freshservice connector properties

Here are the properties for the Freshservice connector that are common to both API v1 and API v2:

Property Control Description
Data Source Name text box
Domain text box
Authentication Type drop down list
  • Email/Password
  • API Token
  • Email text box Email/Password authentication only
    Password text box Email/Password authentication only
    Token text box
  • API Token authentication only
  • Use Personal API key
  • API Version drop down list v2 for Incorta Release 4.4 and higher
    Custom Date Formats text box Specify any Custom date formats
    Custom date formats

    The Freshservice API v1 and v2 support the following custom date formats:

    YYYY-MM-DD
    YYYY-MM-DDTHH:MM
    YYYY-MM-DDTHH:MMZ
    YYYY-MM-DDTHH:MM:SS
    YYYY-MM-DDTHH:MM:SSZ
    YYYY-MM-DDTHH:MM:SS±hh:mm
    YYYY-MM-DDTHH:MM:SS±hh
    YYYY-MM-DDTHH:MM:SS±hhmm

    Formats without the time zone are assumed to be in UTC. Here are some format examples for datefields:

    2016-02-15T21:16:25Z
    2012-12-24T12:56:15+05:30
    2010-03-23T12:00

    Freshservice connector properties API v2

    Here are the additional properties for the Freshservice API v2:

    Warning

    Ticket Stats and Ticket Requester will consume additional Freshservice API credits.

    Property Control Description
    Include Ticket Stats toggle Includes:
  • Closed At
  • Resolved At
  • First Responded At Time
  • Include Ticket Requester toggle Includes:
  • Name
  • Email
  • Mobile
  • Phone
  • Create a schema with the Schema Wizard

    Here are the steps to create a Freshservice schema with the Schema Wizard:

    • Sign in to the Incorta Direct Data Platform.
    • In the Navigation bar, select Schema.
    • In the Action bar, select + NewSchema Wizard
    • In (1) Choose a Source, specify the following:

      • For Enter a name, enter the schema name.
      • For Select a Datasource, select the Freshservice external data source.
      • Optionally create a description.
    • In the Schema Wizard footer, select Next.
    • In (2) Manage Tables, in the Data Panel, first select the name of the Data Source, and then check the Select All checkbox.
    • In the Schema Wizard footer, select Next.
    • In (3) Finalize, in the Schema Wizard footer, select Create Schema.

    Create a schema with the Schema Designer

    Here are the steps to create a Freshservice schema using the Schema Designer:

    • Sign in to the Incorta Direct Data Platform.
    • In the Navigation bar, select Schema.
    • In the Action bar, select + NewCreate Schema.
    • In Name, specify the schema name, and select Save.
    • In Start adding tables to your schema, select Freshservice.
    • In the Data Source dialog, specify the Freshservice table data source properties.
    • Select Add.
    • In the Table Editor, in the Table Summary section, enter the table name.
    • To save your changes, in the Action bar, and select Done.

    Freshservice table data source properties

    For a schema table in Incorta, you can define the following Freshservice specific data source properties as follows:

    Property Control Description
    Type drop down list Default is Freshservice.
    Data Source drop down list Select the Freshservice external data source.
    Table drop down list Choose the Freshservice table to add to the schema.
    Filter text box Specify a Ticket filter
    Callback toggle Enables Callback URL field
    Callback URL text box Specify URL
    Ticket filters

    Here are the available filters for the Ticket table:

    Filter Description
    new_and_my_open Returns new and open tickets for the agent whose credentials were used to make this API call.
    watching Returns the tickets being watched by the agent whose credentials were used to make the API call.
    spam Returns tickets marked as spam.
    deleted Returns deleted tickets.

    View the schema diagram with the

    Here are the steps to view the schema diagram using the Schema Diagram Viewer:

    • Sign in to the Incorta Direct Data Platform.
    • In the Navigation bar, select Schema.
    • In the list of schemas, select the Freshservice schema.
    • In the Schema Designer, in the Action bar, select Diagram.

    Freshservice schema diagram

    The following is an example schema for an external data source that utilizes the Freshservice connector:

    Load the schema

    Here are the steps to perform a Full Load of the Freshservice schema using the Schema Designer:

    • Sign in to the Incorta Direct Data Platform.
    • In the Navigation bar, select Schema.
    • In the list of schemas, select the Freshservice schema.
    • In the Schema Designer, in the Action bar, select LoadLoad NowFull.
    • To review the load status, in Last Load Status, select the date.

    Explore the schema

    With the full load of the Freshservice schema complete, you can use the Analyzer to explore, the schema, create your first insight, and save the insight to a new dashboard.

    To open the Analyzer from the schema, follow these steps:

    • In the Navigation bar, select Schema.
    • In the Schema Manager, in the List view, select the Freshservice .
    • In the Schema Designer, in the Action bar, select Explore Data.

    © Incorta, Inc. All Rights Reserved.