Delete a Document with MongoDB API on New Post Created from Hootsuite API

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

Trigger workflow on

New Post Created from the Hootsuite API

Next, do this

Delete a Document with the MongoDB 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 MongoDB 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 a Document action
1. Connect your MongoDB account
2. Select a Database
3. Select a Collection
4. Select a Document
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 a Document on MongoDB

Description:Delete a single document by ID. [See the docs here](https://docs.mongodb.com/manual/tutorial/remove-documents/)

Version:0.1.5

Key:mongodb-delete-document

View on GitHub

MongoDB Overview#

The MongoDB API provides powerful capabilities to interact with a MongoDB database, allowing you to perform CRUD (Create, Read, Update, Delete) operations, manage databases, and execute sophisticated queries. With Pipedream, you can harness these abilities to automate tasks, sync data across various apps, and react to events in real-time. It’s a combo that’s particularly potent for managing data workflows, syncing application states, or triggering actions based on changes to your data.

Action Code#

import mongodbApp from "../../mongodb.app.mjs";

export default {
  key: "mongodb-delete-document",
  name: "Delete a Document",
  description: "Delete a single document by ID. [See the docs here](https://docs.mongodb.com/manual/tutorial/remove-documents/)",
  version: "0.1.5",
  type: "action",
  props: {
    mongodbApp,
    database: {
      propDefinition: [
        mongodbApp,
        "database",
      ],
    },
    collection: {
      propDefinition: [
        mongodbApp,
        "collection",
        (c) => ({
          database: c.database,
        }),
      ],
    },
    document: {
      propDefinition: [
        mongodbApp,
        "document",
        (c) => ({
          database: c.database,
          collection: c.collection,
        }),
      ],
    },
  },
  async run({ $ }) {
    await this.mongodbApp.deleteDocumentById(
      this.database,
      this.collection,
      this.document,
    );
    $.export("$summary", `Document "${this.document}" successfully deleted`);
  },
};

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
MongoDB	`mongodbApp`	`app`	This component uses the MongoDB app.
Database	`database`	`string`	Select a value from the drop down menu.
Collection	`collection`	`string`	Select a value from the drop down menu.
Document	`document`	`string`	Select a value from the drop down menu.

Action Authentication#

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

Before you connect to your Mongo database from Pipedream, please make sure your database is accessible from the public internet. You may need to add a firewall rule allowing connections from 0.0.0.0/0.

Then, enter the details of your Mongo host / database below.

Delete a Document with MongoDB API on New Post Created from Hootsuite API

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

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

Developers ♥ Pipedream

1-24of2,400+apps by most popular

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