Search Customers with Stripe API on New Message in Ticket from Richpanel API

Pipedream makes it easy to connect APIs for Stripe, Richpanel and 2,900+ other apps remarkably fast.

Trigger workflow on

New Message in Ticket from the Richpanel API

Next, do this

Search Customers with the Stripe API

No credit card required

▶

Watch us build a workflow

8 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the New Message in Ticket trigger
1. Connect your Richpanel account
2. Configure timer
Configure the Search Customers action
1. Connect your Stripe account
2. Optional- Configure Search Query
3. Optional- Configure Email
4. Optional- Configure Email Domain
5. Optional- Configure Created After
6. Optional- Configure Created Before
7. Configure Result Limit
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 Message in Ticket on Richpanel

Description:Emit new event when a new message is sent on an existing or new ticket.

Version:0.0.1

Key:richpanel-new-message

View on GitHub

Trigger Code#

import common from "../common/base.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  ...common,
  key: "richpanel-new-message",
  name: "New Message in Ticket",
  description: "Emit new event when a new message is sent on an existing or new ticket.",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  methods: {
    ...common.methods,
    getDateField() {
      return "updatedAt";
    },
    getSummary(item) {
      return `New message on ticket ${item.id}`;
    },
    async prepareData(data, lastDate) {
      const response = [];
      for await (const item of data) {
        for (const message of item.comments) {
          if (Date.parse(message.created_at) > Date.parse(lastDate)) {
            response.push({
              ...message,
              updated_at: message.created_at,
              ticket_id: item.id,
            });
          }
        }
      }
      return response;
    },
  },
  sampleEmit,
};

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
Richpanel	`richpanel`	`app`	This component uses the Richpanel app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`

Trigger Authentication#

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

About Richpanel#

Richpanel is the help desk software that helps you create a seamless support experience for both the customer & support teams.

Action#

Search Customers on Stripe

Description:Search customers by various attributes like email domain, created date, etc. [See the documentation](https://stripe.com/docs/api/customers/search).

Version:0.0.4

Key:stripe-search-customers

View on GitHub

Stripe Overview#

The Stripe API is a powerful tool for managing online payments, subscriptions, and invoices. With Pipedream, you can leverage this API to automate payment processing, monitor transactions, and sync billing data with other services. Pipedream's no-code platform allows for quick integration and creation of serverless workflows that react to Stripe events in real-time. For instance, you might automatically update customer records, send personalized emails after successful payments, or escalate failed transactions to your support team.

Action Code#

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

export default {
  key: "stripe-search-customers",
  name: "Search Customers",
  type: "action",
  version: "0.0.4",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: true,
  },
  description: "Search customers by various attributes like email domain, created date, etc. [See the documentation](https://stripe.com/docs/api/customers/search).",
  props: {
    app,
    query: {
      type: "string",
      label: "Search Query",
      description: "Search query using Stripe's [search query language](https://stripe.com/docs/search#search-query-language). Example: `email~\"example.com\" AND created>1609459200`",
      optional: true,
    },
    email: {
      description: "Search by customer email address (e.g.,`user@example.com`)",
      propDefinition: [
        app,
        "email",
      ],
    },
    emailDomain: {
      type: "string",
      label: "Email Domain",
      description: "Search by email **domain** (e.g., `example.com` to find all emails from that domain)",
      optional: true,
    },
    createdAfter: {
      type: "string",
      label: "Created After",
      description: "Filter customers created after this date (format: `YYYY-MM-DD`)",
      optional: true,
    },
    createdBefore: {
      type: "string",
      label: "Created Before",
      description: "Filter customers created before this date (format: `YYYY-MM-DD`)",
      optional: true,
    },
    limit: {
      propDefinition: [
        app,
        "limit",
      ],
      description: "Maximum number of customers to return",
      default: 25,
    },
  },
  methods: {
    convertDateToTimestamp(dateStr) {
      if (!dateStr) {
        return null;
      }
      const date = new Date(`${dateStr}T00:00:00Z`);
      return Math.floor(date.getTime() / 1000);
    },
    buildSearchQuery() {
      const queryParts = [];

      if (this.query) {
        return this.query;
      }

      if (this.email) {
        // Escape quotes in the email value to prevent query syntax errors
        const escapedEmail = this.email.replace(/"/g, "\\\"");
        queryParts.push(`email:"${escapedEmail}"`);
      }

      if (this.emailDomain) {
        // Escape quotes in the domain value to prevent query syntax errors
        const escapedDomain = this.emailDomain.replace(/"/g, "\\\"");
        queryParts.push(`email~"${escapedDomain}"`);
      }

      const afterTimestamp = this.convertDateToTimestamp(this.createdAfter);
      if (afterTimestamp) {
        queryParts.push(`created>${afterTimestamp}`);
      }

      const beforeTimestamp = this.convertDateToTimestamp(this.createdBefore);
      if (beforeTimestamp) {
        queryParts.push(`created<${beforeTimestamp}`);
      }

      return queryParts.join(" AND ");
    },
  },
  async run({ $ }) {
    const {
      buildSearchQuery,
      app,
      limit,
    } = this;

    const query = buildSearchQuery();

    if (!query) {
      throw new Error("Please provide at least one search parameter");
    }

    // Search API requires minimum API version 2020-08-27
    const results = await app.sdk().customers.search({
      query,
      limit,
    });

    const resultCount = results.data.length;
    $.export("$summary", `Found ${resultCount} customer${resultCount === 1
      ? ""
      : "s"}`);

    return results.data;
  },
};

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
Stripe	`app`	`app`	This component uses the Stripe app.
Search Query	`query`	`string`	Search query using Stripe's search query language. Example: `email~"example.com" AND created>1609459200`
Email	`email`	`string`	Search by customer email address (e.g.,`user@example.com`)
Email Domain	`emailDomain`	`string`	Search by email domain (e.g., `example.com` to find all emails from that domain)
Created After	`createdAfter`	`string`	Filter customers created after this date (format: `YYYY-MM-DD`)
Created Before	`createdBefore`	`string`	Filter customers created before this date (format: `YYYY-MM-DD`)
Result Limit	`limit`	`integer`	Maximum number of customers to return

Search Customers with Stripe API on New Message in Ticket from Richpanel API

Pipedream makes it easy to connect APIs for Stripe, Richpanel and 2,900+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,900+apps by most popular

1
-
24
of
2,900+
apps by most popular