Add Lead to Campaign with Salesforce API on New Event from TicketSauce API

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

Trigger workflow on

New Event from the TicketSauce API

Next, do this

Add Lead to Campaign with the Salesforce 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 TicketSauce trigger and Salesforce action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Event trigger
1. Connect your TicketSauce account
2. Configure alert
3. Configure timer
4. Optional- Configure Partner ID
5. Optional- Configure Organization ID
Configure the Add Lead to Campaign action
1. Connect your Salesforce account
2. Select a Campaign ID
3. Select a Lead ID
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 Event on TicketSauce

Description:Emit new event when an event is created in Ticketsauce. [See the documentation](https://speca.io/ticketsauce/ticketsauce-public-api?key=204000d6bda66da78315e721920f43aa#list-of-events)

Version:0.0.1

Key:ticketsauce-new-event

View on GitHub

Trigger Code#

import ticketsauce from "../../ticketsauce.app.mjs";
import sampleEmit from "./test-event.mjs";

export default {
  key: "ticketsauce-new-event",
  name: "New Event",
  description: "Emit new event when an event is created in Ticketsauce. [See the documentation](https://speca.io/ticketsauce/ticketsauce-public-api?key=204000d6bda66da78315e721920f43aa#list-of-events)",
  version: "0.0.1",
  type: "source",
  dedupe: "unique",
  props: {
    ticketsauce,
    db: "$.service.db",
    alert: {
      type: "alert",
      alertType: "info",
      content: "The TicketSauce API caches responses to the **List of Events** endpoint for 1 hour. This affects how new events are polled. To avoid unnecessary API calls, set the polling interval accordingly. [See the documentation](https://speca.io/ticketsauce/ticketsauce-public-api?key=204000d6bda66da78315e721920f43aa#list-of-events)",
    },
    timer: {
      type: "$.interface.timer",
      default: {
        intervalSeconds: 60 * 60,
      },
    },
    partnerId: {
      propDefinition: [
        ticketsauce,
        "partnerId",
      ],
      description: "Filter events by a specific partner ID (optional)",
    },
    organizationId: {
      propDefinition: [
        ticketsauce,
        "organizationId",
      ],
      description: "Filter events by a specific organization ID (optional)",
    },
  },
  methods: {
    _getLastCreated() {
      return this.db.get("lastCreated") || "1970-01-01 00:00:00";
    },
    _setLastCreated(lastCreated) {
      this.db.set("lastCreated", lastCreated);
    },
    generateMeta(event) {
      return {
        id: event.Event.id,
        summary: `New Event: ${event.Event.name}`,
        ts: Date.parse(event.Event.created),
      };
    },
    async startEvent(maxResults = 0) {
      const lastCreated = this._getLastCreated();

      const events = await this.ticketsauce.listEvents(this, {
        partnerId: this.partnerId,
        organizationId: this.organizationId,
        params: {
          sort_by: "date",
          sort_dir: "desc",
          active_only: false,
        },
      });

      if (!events?.length) {
        return;
      }

      // Filter events created after lastCreated and sort by creation date
      const newEvents = events.filter((event) =>
        Date.parse(event.Event.created) > Date.parse(lastCreated));

      // Sort by created date ascending (oldest first) for emission order
      newEvents.sort((a, b) =>
        Date.parse(a.Event.created) - Date.parse(b.Event.created));

      // Limit results if maxResults is specified
      const eventsToEmit = maxResults && maxResults > 0
        ? newEvents.slice(0, maxResults)
        : newEvents;

      // Update last created date if we have new events
      if (newEvents.length > 0) {
        // Find the most recent created date
        const mostRecentEvent = events.reduce((latest, current) =>
          Date.parse(current.Event.created) > Date.parse(latest.Event.created)
            ? current
            : latest);
        this._setLastCreated(mostRecentEvent.Event.created);
      }

      // Emit events
      for (const event of eventsToEmit) {
        this.$emit(event, this.generateMeta(event));
      }
    },
  },
  hooks: {
    async deploy() {
      await this.startEvent(25);
    },
  },
  async run() {
    await this.startEvent();
  },
  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
TicketSauce	`ticketsauce`	`app`	This component uses the TicketSauce app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Partner ID	`partnerId`	`string`	Filter events by a specific partner ID (optional)
Organization ID	`organizationId`	`string`	Filter events by a specific organization ID (optional)

Trigger Authentication#

TicketSauce uses OAuth authentication. When you connect your TicketSauce account, Pipedream will open a popup window where you can sign into TicketSauce and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any TicketSauce API.

Pipedream requests the following authorization scopes when you connect your account:

About TicketSauce#

The #1 White Label Event Ticketing Software Platform

Action#

Add Lead to Campaign on Salesforce

Description:Adds an existing lead to an existing campaign. [See the documentation](https://developer.salesforce.com/docs/atlas.en-us.228.0.object_reference.meta/object_reference/sforce_api_objects_campaignmember.htm)

Version:0.1.3

Key:salesforce_rest_api-add-lead-to-campaign

View on GitHub

Salesforce Overview#

The Salesforce (REST API) provides a powerful platform for creating and managing customer relationships with a wide array of features like data manipulation, querying, and complex automation. With Pipedream's serverless execution, you can create workflows that automate your sales processes, sync data with other platforms, enhance customer engagement, and trigger actions based on specific events. Dive into Salesforce data, streamline lead management, track customer interactions, and push or pull data to or from Salesforce seamlessly.

Action Code#

import salesforce from "../../salesforce_rest_api.app.mjs";
import constants from "../../common/constants.mjs";

export default {
  key: "salesforce_rest_api-add-lead-to-campaign",
  name: "Add Lead to Campaign",
  description: "Adds an existing lead to an existing campaign. [See the documentation](https://developer.salesforce.com/docs/atlas.en-us.228.0.object_reference.meta/object_reference/sforce_api_objects_campaignmember.htm)",
  version: "0.1.3",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: false,
  },
  type: "action",
  props: {
    salesforce,
    campaignId: {
      propDefinition: [
        salesforce,
        "recordId",
        () => ({
          objType: "Campaign",
          nameField: "Name",
        }),
      ],
      label: "Campaign ID",
      description: "The Campaign to add a Lead to.",
    },
    leadId: {
      propDefinition: [
        salesforce,
        "recordId",
        () => ({
          objType: "Lead",
          nameField: "Name",
        }),
      ],
      label: "Lead ID",
      description: "The Lead to add to the selected Campaign.",
    },
  },
  async run({ $ }) {
    const {
      salesforce, campaignId, leadId,
    } = this;
    const response = await salesforce.createObject({
      $,
      objectType: constants.OBJECT_TYPE.CAMPAIGN_MEMBER,
      data: {
        CampaignId: campaignId,
        LeadId: leadId,
      },
    });
    $.export("$summary", `Successfully added lead (ID: ${leadId}) to campaign (ID: ${campaignId})`);
    return response;
  },
};

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
Salesforce	`salesforce`	`app`	This component uses the Salesforce app.
Campaign ID	`campaignId`	`string`	Select a value from the drop down menu.
Lead ID	`leadId`	`string`	Select a value from the drop down menu.

Action Authentication#

Salesforce uses OAuth authentication. When you connect your Salesforce account, Pipedream will open a popup window where you can sign into Salesforce and grant Pipedream permission to connect to your account. Pipedream securely stores and automatically refreshes the OAuth tokens so you can easily authenticate any Salesforce API.

Pipedream requests the following authorization scopes when you connect your account:

About Salesforce#

Cloud-based customer relationship management (CRM) platform that helps businesses manage sales, marketing, customer support, and other business activities, ultimately aiming to improve customer relationships and streamline operations.

More Ways to Connect Salesforce + TicketSauce#

Other Popular Integrations#

Get Order Details with TicketSauce API on Case Updated (Instant, of Selectable Type) from Salesforce API

Salesforce + TicketSauce

Add Lead to Campaign with Salesforce API on New Event from TicketSauce API

Pipedream makes it easy to connect APIs for Salesforce, TicketSauce 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