Add or update a single record with Data Stores API on New Ticket from Freshdesk API

Pipedream makes it easy to connect APIs for Data Stores, Freshdesk and 1000+ other apps remarkably fast.

Trigger workflow on

New Ticket from the Freshdesk API

Next, do this

Add or update a single record with the Data Stores API

No credit card required

▶

Watch us build a workflow

7 min

Watch now ➜

Trusted by 500,000+ developers from startups to Fortune 500 companies

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Freshdesk trigger and Data Stores action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Ticket trigger
1. Connect your Freshdesk account
2. Configure Polling interval
Configure the Add or update a single record action
1. Connect your Data Stores account
2. Configure Data Store
3. Select a Key
4. Configure Value
Deploy the workflow
Send a test event to validate your setup
Turn on the trigger

Details#

This integration uses pre-built, source-available components from Pipedream's GitHub repo. These components are developed by Pipedream and the community, and verified and maintained by Pipedream.

To contribute an update to an existing component or create a new component, create a PR on GitHub. If you're new to Pipedream component development, you can start with quickstarts for trigger span and action development, and then review the component API reference.

Trigger#

New Ticket on Freshdesk

Description:Emit new notifications when a new ticket is created

Version:0.0.2

Key:freshdesk-new-ticket

View on GitHub

Freshdesk Overview#

With the Freshdesk API, you can create powerful customer support applications.
Here are some examples of what you can build:

A ticketing system for tracking customer issues
A knowledge base for self-service customer support
A customer community for engaging customers and crowd-sourcing solutions
A call center management system

Trigger Code#

import freshdesk from "../../freshdesk.app.mjs";
import moment from "moment";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";

export default {
  key: "freshdesk-new-ticket",
  name: "New Ticket",
  description: "Emit new notifications when a new ticket is created",
  version: "0.0.2",
  type: "source",
  props: {
    freshdesk,
    timer: {
      label: "Polling interval",
      description: "Pipedream will poll Harvest API on this schedule",
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    db: "$.service.db",
  },
  dedupe: "unique",
  async run() {
    const data = [];
    let lastDateChecked = this.freshdesk.getLastDateChecked(this.db);
    if (!lastDateChecked) {
      lastDateChecked = new Date().toISOString();
      this.freshdesk.setLastDateChecked(this.db, lastDateChecked);
    }
    const formatedDate = lastDateChecked.substr(0, (lastDateChecked + "T").indexOf("T"));
    const tickets = await this.freshdesk.filterTickets({
      query: `"created_at:>'${formatedDate}'"`,
      page: 1,
    });
    for await (const ticket of tickets) {
      data.push(ticket);
    }
    data && data.reverse().forEach((ticket) => {
      this.freshdesk.setLastDateChecked(this.db, ticket.created_at);
      if (moment(ticket.created_at).isAfter(lastDateChecked)) {
        this.$emit(ticket,
          {
            id: ticket.id,
            summary: `Ticket number: ${ticket.id}`,
            ts: Date.parse(ticket.created_at),
          });
      }
    });
  },
};

Trigger Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI and CLI.

Label	Prop	Type	Description
Freshdesk	`freshdesk`	`app`	This component uses the Freshdesk app.
Polling interval	`timer`	`$.interface.timer`	Pipedream will poll Harvest API on this schedule
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.

Trigger Authentication#

Freshdesk uses API keys for authentication. When you connect your Freshdesk account, Pipedream securely stores the keys so you can easily authenticate to Freshdesk APIs in both code and no-code steps.

Your API key is in your Profile > Settings page, below the change password section on the right.
Your domain is 12345678 if your Freshdesk URL is https://12345678.freshdesk.com/

About Freshdesk#

Customer support software

Action#

Add or update a single record on Data Stores

Description:Add or update a single record in your [Pipedream Data Store](https://pipedream.com/data-stores/).

Version:0.0.8

Key:data_stores-add-update-record

View on GitHub

Data Stores Overview#

With the Data Stores API, you can build applications that:

Store data for later retrieval
Retrieve data from a store
Update data in a store
Delete data from a store

Action Code#

import app from "../../data_stores.app.mjs";

export default {
  key: "data_stores-add-update-record",
  name: "Add or update a single record",
  description: "Add or update a single record in your [Pipedream Data Store](https://pipedream.com/data-stores/).",
  version: "0.0.8",
  type: "action",
  props: {
    app,
    dataStore: {
      propDefinition: [
        app,
        "dataStore",
      ],
    },
    key: {
      propDefinition: [
        app,
        "key",
        ({ dataStore }) => ({
          dataStore,
        }),
      ],
      description: "Enter a key for the record you'd like to create or select an existing key to update.",
    },
    value: {
      propDefinition: [
        app,
        "value",
      ],
    },
  },
  async run({ $ }) {
    const {
      key,
      value,
    } = this;
    const exists = await this.dataStore.has(key);
    const parsedValue = this.app.parseValue(value);
    await this.dataStore.set(key, parsedValue);
    // eslint-disable-next-line multiline-ternary
    $.export("$summary", `Successfully ${exists ? "updated the record for" : "added a new record with the"} key, \`${key}\`.`);
    return {
      key,
      value: parsedValue,
    };
  },
};

Action Configuration#

This component may be configured based on the props defined in the component code. Pipedream automatically prompts for input values in the UI.

Label	Prop	Type	Description
Data Stores	`app`	`app`	This component uses the Data Stores app.
Data Store	`dataStore`	`data_store`	Select an existing Data Store or create a new one.
Key	`key`	`string`	Select a value from the drop down menu.
Value	`value`	`any`	Enter a string, object, or array.

Action Authentication#

The Data Stores API does not require authentication.

About Data Stores#

Use Pipedream Data Stores to manage state throughout your workflows.

More Ways to Connect Data Stores + Freshdesk#

Other Popular Integrations#

Add or update multiple records with Data Stores API on New Contact from Freshdesk API

Freshdesk + Data Stores

Try it

Add or update multiple records with Data Stores API on New Ticket from Freshdesk API

Freshdesk + Data Stores

Try it

Delete All Records with Data Stores API on New Contact from Freshdesk API

Freshdesk + Data Stores

Try it

List keys with Data Stores API on New Contact from Freshdesk API

Freshdesk + Data Stores

Try it

Delete All Records with Data Stores API on New Ticket from Freshdesk API

Freshdesk + Data Stores

Try it

Popular Triggers#

New Contact from the Freshdesk API

Emit new notifications when a new contact is created

Try it

New Ticket from the Freshdesk API

Emit new notifications when a new ticket is created

Try it

Popular Actions#

Create a Company with the Freshdesk API

Create a company. See docs here

Try it

Create a Contact with the Freshdesk API

Create a contact. See docs here

Try it

Create a Ticket with the Freshdesk API

Create a ticket. See docs here

Try it

Get Ticket Details with the Freshdesk API

Get a Ticket. See docs here

Try it

List All Tickets with the Freshdesk API

Use filters to view only specific tickets (those which match the criteria that you choose). By default, only tickets that have not been deleted or marked as spam will be returned, unless you use the 'deleted' filter.

Try it