Delete Contacts with Twilio SendGrid API on New Post Created from Hootsuite API

Pipedream makes it easy to connect APIs for Twilio SendGrid, Hootsuite and 2,400+ other apps remarkably fast.

Trigger workflow on

New Post Created from the Hootsuite API

Next, do this

Delete Contacts with the Twilio SendGrid 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 Hootsuite trigger and Twilio SendGrid action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Post Created trigger
1. Connect your Hootsuite account
2. Configure timer
3. Select one or more States
Configure the Delete Contacts action
1. Connect your Twilio SendGrid account
2. Configure Delete All Contacts?
3. Optional- Select one or more Contact IDs
4. Optional- Select one or more Contact Emails
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 Post Created on Hootsuite

Description:Emit new event on each new created post. [See docs here](https://platform.hootsuite.com/docs/api/index.html#operation/retrieveMessages).

Version:0.0.1

Key:hootsuite-new-post-created

View on GitHub

Hootsuite Overview#

The Hootsuite API offers a variety of endpoints to automate social media management tasks such as scheduling posts, managing social content, and analyzing social media performance. By leveraging Pipedream, you can create serverless workflows to interact with the Hootsuite API; you can schedule posts at optimal times, aggregate metrics for reporting, or even respond to social media activity in real-time. Pipedream's platform allows the seamless integration of the Hootsuite API with hundreds of other apps to streamline social media workflows, monitor brand presence, and engage with audiences effectively.

Trigger Code#

import dayjs from "dayjs";
import hootsuite from "../../hootsuite.app.mjs";
import constants from "../common/constants.mjs";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";

export default {
  name: "New Post Created",
  version: "0.0.1",
  key: "hootsuite-new-post-created",
  description: "Emit new event on each new created post. [See docs here](https://platform.hootsuite.com/docs/api/index.html#operation/retrieveMessages).",
  type: "source",
  dedupe: "unique",
  props: {
    hootsuite,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      static: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    states: {
      label: "States",
      description: "Selected the states to filter",
      options: constants.STATES,
      type: "string[]",
    },
  },
  methods: {
    emitEvent(data) {
      if (!this.states.includes(data.state)) {
        return;
      }

      this.$emit(data, {
        id: data.id,
        summary: `New post created with ID ${data.id}`,
        ts: new Date(),
      });
    },
    _setLastSyncTimestamp() {
      this.db.set("lastSyncTimestamp", dayjs().toISOString());
    },
    _getLastSyncTimestamp() {
      return this.db.get("lastSyncTimestamp");
    },
  },
  hooks: {
    async deploy() {
      this._setLastSyncTimestamp();

      const { data: posts } = await this.hootsuite.getPosts({
        params: {
          startTime: new Date(new Date().setDate(new Date().getDate() - 7)).toISOString(),
          endTime: new Date().toISOString(),
        },
      });

      posts.forEach(this.emitEvent);
    },
  },
  async run() {
    const lastSyncTimestamp = this._getLastSyncTimestamp();
    this._setLastSyncTimestamp();

    const { data: posts } = await this.hootsuite.getPosts({
      params: {
        startTime: dayjs(lastSyncTimestamp).subtract(24, "hour")
          .toISOString(),
        endTime: dayjs().add(24, "hour")
          .toISOString(),
      },
    });

    console.log({
      startTime: dayjs(lastSyncTimestamp).subtract(24, "hour")
        .toISOString(),
      endTime: dayjs().toISOString(),
    });

    posts.forEach(this.emitEvent);
  },
};

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
Hootsuite	`hootsuite`	`app`	This component uses the Hootsuite app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
States	`states`	`string[]`	Select a value from the drop down menu:`{ "label": "Scheduled", "value": "SCHEDULED" }{ "label": "Submitted", "value": "SUBMITTED" }{ "label": "Pending Approval", "value": "PENDING_APPROVAL" }{ "label": "Sent", "value": "SENT" }{ "label": "Send Failed Permanently", "value": "SEND_FAILED_PERMANENTLY" }{ "label": "Rejected", "value": "REJECTED" }`

Trigger Authentication#

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

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

offline

About Hootsuite#

Social media management platform.

Action#

Delete Contacts on Twilio SendGrid

Description:Allows you to delete one or more contacts. [See the docs here](https://docs.sendgrid.com/api-reference/contacts/delete-contacts)

Version:0.0.3

Key:sendgrid-delete-contacts

View on GitHub

Twilio SendGrid Overview#

The Twilio SendGrid API opens up a world of possibilities for email automation, enabling you to send emails efficiently and track their performance. With this API, you can programmatically create and send personalized email campaigns, manage contacts, and parse inbound emails for data extraction. When you harness the power of Pipedream, you can connect SendGrid to hundreds of other apps to automate workflows, such as triggering email notifications based on specific actions, syncing email stats with your analytics, or handling incoming emails to create tasks or tickets.

Action Code#

import common from "../common/common.mjs";

export default {
  ...common,
  key: "sendgrid-delete-contacts",
  name: "Delete Contacts",
  description: "Allows you to delete one or more contacts. [See the docs here](https://docs.sendgrid.com/api-reference/contacts/delete-contacts)",
  version: "0.0.3",
  type: "action",
  props: {
    ...common.props,
    deleteAllContacts: {
      propDefinition: [
        common.props.sendgrid,
        "deleteAll",
      ],
      label: "Delete All Contacts?",
      description: "This parameter allows you to delete all of your contacts. This can not be used with the `ids` parameter.",
    },
    contactIds: {
      propDefinition: [
        common.props.sendgrid,
        "contactIds",
      ],
    },
    contactEmails: {
      propDefinition: [
        common.props.sendgrid,
        "contactEmail",
      ],
      type: "string[]",
      label: "Contact Emails",
      description: "Array of email addresses to be deleted.",
      optional: true,
    },
  },
  async run({ $ }) {
    const {
      deleteAllContacts,
      contactIds = [],
      contactEmails = [],
    } = this;

    if (deleteAllContacts && (contactIds || contactEmails)) {
      throw new Error("If `deleteAllContacts` is selected, cannot select `contactIds` or `contactEmails`");
    }

    for (const email of contactEmails) {
      const { result } = await this.sendgrid.searchContacts(`email like '${email}'`);
      const id = result[0]?.id;
      if (!contactIds.includes(id)) {
        contactIds.push(id);
      }
    }
    const resp = await this.sendgrid.deleteContacts(deleteAllContacts, contactIds);
    $.export("$summary", `Successfully deleted ${contactIds.length} contact(s)`);
    return resp;
  },
};

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
Twilio SendGrid	`sendgrid`	`app`	This component uses the Twilio SendGrid app.
Delete All Contacts?	`deleteAllContacts`	`boolean`	This parameter allows you to delete all of your contacts. This can not be used with the `ids` parameter.
Contact IDs	`contactIds`	`string[]`	Select a value from the drop down menu.
Contact Emails	`contactEmails`	`string[]`	Select a value from the drop down menu.