← MySQL + Beekeeper integrations

Create Post with Beekeeper API on New or Updated Row from MySQL API

Pipedream makes it easy to connect APIs for Beekeeper, MySQL and 2,700+ other apps remarkably fast.

Trigger workflow on
New or Updated Row from the MySQL API
Next, do this
Create Post with the Beekeeper API
No credit card required
Intro to Pipedream
Watch us build a workflow
Watch us build a workflow
8 min
Watch now ➜

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

Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo
Adyen logo
Appcues logo
Bandwidth logo
Checkr logo
ChartMogul logo
Dataminr logo
Gopuff logo
Gorgias logo
LinkedIn logo
Logitech logo
Replicated logo
Rudderstack logo
SAS logo
Scale AI logo
Webflow logo
Warner Bros. logo

Developers Pipedream

Getting Started

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

  1. Select this integration
  2. Configure the New or Updated Row trigger
    1. Connect your MySQL account
    2. Configure timer
    3. Select a Table
    4. Select a Order By
  3. Configure the Create Post action
    1. Connect your Beekeeper account
    2. Select a Stream ID
    3. Configure Text
    4. Optional- Configure Files
    5. Optional- Configure Locked
    6. Optional- Configure Title
    7. Optional- Configure Media
    8. Optional- Configure Labels
    9. Optional- Configure Sticky
    10. Optional- Configure Reactions Disabled
    11. Optional- Configure Options
    12. Optional- Configure Scheduled At
  4. Deploy the workflow
  5. Send a test event to validate your setup
  6. 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

Description:Emit new event when you add or modify a new row in a table. [See the docs here](https://dev.mysql.com/doc/refman/8.0/en/select.html)
Version:2.0.5
Key:mysql-new-or-updated-row

MySQL Overview

The MySQL application on Pipedream enables direct interaction with your MySQL databases, allowing you to perform CRUD operations—create, read, update, delete—on your data with ease. You can leverage these capabilities to automate data synchronization, report generation, and event-based triggers that kick off workflows in other apps. With Pipedream's serverless platform, you can connect MySQL to hundreds of other services without managing infrastructure, crafting complex code, or handling authentication.

Trigger Code

import common from "../common/table.mjs";
import { v4 as uuidv4 } from "uuid";

const { mysql } = common.props;

export default {
  ...common,
  key: "mysql-new-or-updated-row",
  name: "New or Updated Row",
  description: "Emit new event when you add or modify a new row in a table. [See the docs here](https://dev.mysql.com/doc/refman/8.0/en/select.html)",
  type: "source",
  version: "2.0.5",
  dedupe: "unique",
  props: {
    ...common.props,
    db: "$.service.db",
    column: {
      propDefinition: [
        mysql,
        "column",
        (c) => ({
          table: c.table,
        }),
      ],
      label: "Order By",
      description:
        "A datetime column, such as 'date_updated' or 'last_modified' that is set to the current datetime when a row is updated.",
    },
  },
  hooks: {
    async deploy() {
      await this.listTopRows(this.column);
    },
  },
  methods: {
    ...common.methods,
    async listResults() {
      await this.listRowResults(this.column);
    },
    generateMeta(row) {
      return {
        id: uuidv4(),
        summary: `New Row Added/Updated ${row[this.column]}`,
        ts: Date.now(),
      };
    },
  },
};

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.
LabelPropTypeDescription
MySQLmysqlappThis component uses the MySQL app.
timer$.interface.timer
TabletablestringSelect a value from the drop down menu.
N/Adb$.service.dbThis component uses $.service.db to maintain state between executions.
Order BycolumnstringSelect a value from the drop down menu.

Trigger Authentication

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

Connecting to Restricted Databases

Either enable the shared static IP for this account below, or configure a VPC to deploy any workflow in your workspace to a private network with a dedicated static IP. Learn more in our docs

SSL Setup

Configure SSL on your MySQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications

About MySQL

MySQL is an open-source relational database management system.

Action

Description:Create a new text or multimedia post in a defined stream. [See the documentation](https://beekeeper.stoplight.io/docs/beekeeper-api/18408b41927b9-creates-a-new-post)
Version:0.0.1
Key:beekeeper-create-post

Beekeeper Overview

The Beekeeper API enables seamless integration of its workplace communications platform with other business tools and systems, enhancing team collaboration and operational efficiency. By leveraging the Beekeeper API on Pipedream, you can automate the flow of information between Beekeeper and various applications, trigger actions based on messages or alerts, and synchronize data across your organization's tools. Pipedream's serverless architecture simplifies the process of setting up these automations without the need for dedicated infrastructure.

Action Code

import beekeeper from "../../beekeeper.app.mjs";
import { parseObject } from "../../common/utils.mjs";

export default {
  key: "beekeeper-create-post",
  name: "Create Post",
  description: "Create a new text or multimedia post in a defined stream. [See the documentation](https://beekeeper.stoplight.io/docs/beekeeper-api/18408b41927b9-creates-a-new-post)",
  version: "0.0.1",
  type: "action",
  props: {
    beekeeper,
    streamId: {
      propDefinition: [
        beekeeper,
        "streamId",
      ],
    },
    text: {
      type: "string",
      label: "Text",
      description: "The text content of the post",
    },
    files: {
      type: "string[]",
      label: "Files",
      description: "List of file objects to be attached. E.g. [{\"name\": \"fair_play_rules.pdf\", \"url\": \"https://mytenant.beekeeper.io/file/665987/original/fair_play_rules.pdf\", \"userid\": \"5cb9v45d-8i78-4v65-b5fd-81cgfac3ef17\", \"height\": 619, \"width\": 700, \"key\": \"f4fdaab0-d198-49b4-b1cc-dd85572d72f1\", \"media_type\": \"image/png\", \"usage_type\": \"attachment_image\" }]. [See the documentation](https://beekeeper.stoplight.io/docs/beekeeper-api/18408b41927b9-creates-a-new-post) for further details.",
      optional: true,
    },
    locked: {
      type: "boolean",
      label: "Locked",
      description: "Disables adding comments on the post",
      optional: true,
    },
    title: {
      type: "string",
      label: "Title",
      description: "The title of the post",
      optional: true,
    },
    media: {
      type: "string[]",
      label: "Media",
      description: "List of Photo or Video objects. E.g. [{\"name\": \"fair_play_rules.pdf\", \"url\": \"https://mytenant.beekeeper.io/file/665987/original/fair_play_rules.pdf\", \"userid\": \"5cb9v45d-8i78-4v65-b5fd-81cgfac3ef17\", \"height\": 619, \"width\": 700, \"key\": \"f4fdaab0-d198-49b4-b1cc-dd85572d72f1\", \"media_type\": \"image/png\", \"usage_type\": \"attachment_image\" }]. [See the documentation](https://beekeeper.stoplight.io/docs/beekeeper-api/18408b41927b9-creates-a-new-post) for further details.",
      optional: true,
    },
    labels: {
      type: "string[]",
      label: "Labels",
      description: "List of labels attached to the post",
      optional: true,
    },
    sticky: {
      type: "boolean",
      label: "Sticky",
      description: "Flag that pins a post to the top of the stream",
      optional: true,
    },
    reactionsDisabled: {
      type: "boolean",
      label: "Reactions Disabled",
      description: "Flag that disables the ability to add reaction to the post and to see reactions that have been added",
      optional: true,
    },
    options: {
      type: "string[]",
      label: "Options",
      description: "List of poll options in a post. E.g. [\"This Friday\", \"Monday next week\"]",
      optional: true,
    },
    scheduledAt: {
      type: "string",
      label: "Scheduled At",
      description: "Date and time when the post is scheduled to be published (UTC timezone, yyyy-mm-ddTHH:MM:SS format)",
      optional: true,
    },
  },
  async run({ $ }) {
    const response = await this.beekeeper.createPost({
      $,
      data: {
        streamid: this.streamId,
        files: parseObject(this.files),
        locked: this.locked,
        title: this.title,
        media: parseObject(this.media),
        labels: parseObject(this.labels),
        sticky: this.sticky,
        reactions_disabled: this.reactionsDisabled,
        text: this.text,
        options: parseObject(this.options)?.map((item) => ({
          text: item,
        })),
        scheduled_at: this.scheduledAt,
      },
    });

    $.export("$summary", `Successfully created post with UUID: ${response.uuid}`);
    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.

LabelPropTypeDescription
BeekeeperbeekeeperappThis component uses the Beekeeper app.
Stream IDstreamIdstringSelect a value from the drop down menu.
Texttextstring

The text content of the post

Filesfilesstring[]

List of file objects to be attached. E.g. [{"name": "fair_play_rules.pdf", "url": "https://mytenant.beekeeper.io/file/665987/original/fair_play_rules.pdf", "userid": "5cb9v45d-8i78-4v65-b5fd-81cgfac3ef17", "height": 619, "width": 700, "key": "f4fdaab0-d198-49b4-b1cc-dd85572d72f1", "media_type": "image/png", "usage_type": "attachment_image" }]. See the documentation for further details.

Lockedlockedboolean

Disables adding comments on the post

Titletitlestring

The title of the post

Mediamediastring[]

List of Photo or Video objects. E.g. [{"name": "fair_play_rules.pdf", "url": "https://mytenant.beekeeper.io/file/665987/original/fair_play_rules.pdf", "userid": "5cb9v45d-8i78-4v65-b5fd-81cgfac3ef17", "height": 619, "width": 700, "key": "f4fdaab0-d198-49b4-b1cc-dd85572d72f1", "media_type": "image/png", "usage_type": "attachment_image" }]. See the documentation for further details.

Labelslabelsstring[]

List of labels attached to the post

Stickystickyboolean

Flag that pins a post to the top of the stream

Reactions DisabledreactionsDisabledboolean

Flag that disables the ability to add reaction to the post and to see reactions that have been added

Optionsoptionsstring[]

List of poll options in a post. E.g. ["This Friday", "Monday next week"]

Scheduled AtscheduledAtstring

Date and time when the post is scheduled to be published (UTC timezone, yyyy-mm-ddTHH:MM:SS format)

Action Authentication

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

You can access your access_token in the Beekeeper dashboard. Your subdomain appears in the URL you use to login: https://{subdomain}.beekeeper.io/login.

About Beekeeper

Beekeeper’s mobile platform is the single point of contact for your frontline workforce. We bring communications and tools together to increase productivity, agility, and safety.

More Ways to Connect Beekeeper + MySQL

Get User Profile with Beekeeper API on New Column from MySQL API
MySQL + Beekeeper
 
Try it
Get User Profile with Beekeeper API on New or Updated Row from MySQL API
MySQL + Beekeeper
 
Try it
Get User Profile with Beekeeper API on New Row (Custom Query) from MySQL API
MySQL + Beekeeper
 
Try it
Get User Profile with Beekeeper API on New Row from MySQL API
MySQL + Beekeeper
 
Try it
Get User Profile with Beekeeper API on New Table from MySQL API
MySQL + Beekeeper
 
Try it
New Column from the MySQL API

Emit new event when you add a new column to a table. See the docs here

 
Try it
New or Updated Row from the MySQL API

Emit new event when you add or modify a new row in a table. See the docs here

 
Try it
New Row from the MySQL API

Emit new event when you add a new row to a table. See the docs here

 
Try it
New Row (Custom Query) from the MySQL API

Emit new event when new rows are returned from a custom query. See the docs here

 
Try it
New Table from the MySQL API

Emit new event when a new table is added to a database. See the docs here

 
Try it
Execute SQL Query with the MySQL API

Execute a custom MySQL query. See our docs to learn more about working with SQL in Pipedream.

 
Try it
Create Row with the MySQL API

Adds a new row. See the docs here

 
Try it
Delete Row with the MySQL API

Delete an existing row. See the docs here

 
Try it
Execute Query with the MySQL API

Find row(s) via a custom query. See the docs here

 
Try it
Execute Stored Procedure with the MySQL API

Execute Stored Procedure. See the docs here

 
Try it

Explore Other Apps

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

HTTP / Webhook
HTTP / Webhook
Get a unique URL where you can send HTTP or webhook requests
Node
Node
Anything you can do with Node.js, you can do in a Pipedream workflow. This includes using most of npm's 400,000+ packages.
Python
Python
Anything you can do in Python can be done in a Pipedream Workflow. This includes using any of the 350,000+ PyPi packages available in your Python powered workflows.
Pipedream Utils
Pipedream Utils
Utility functions to use within your Pipedream workflows
Notion
Notion
Notion is a new tool that blends your everyday work apps into one. It's the all-in-one workspace for you and your team.
OpenAI (ChatGPT)
OpenAI (ChatGPT)
OpenAI is an AI research and deployment company with the mission to ensure that artificial general intelligence benefits all of humanity. They are the makers of popular models like ChatGPT, DALL-E, and Whisper.
Anthropic (Claude)
Anthropic (Claude)
AI research and products that put safety at the frontier. Introducing Claude, a next-generation AI assistant for your tasks, no matter the scale.
Google Sheets
Google Sheets
Use Google Sheets to create and edit online spreadsheets. Get insights together with secure sharing in real-time and from any device.
Telegram
Telegram
Telegram, is a cloud-based, cross-platform, encrypted instant messaging (IM) service.
Google Drive
Google Drive
Google Drive is a file storage and synchronization service which allows you to create and share your work online, and access your documents from anywhere.
Pinterest
Pinterest
Pinterest is a visual discovery engine for finding ideas like recipes, home and style inspiration, and more.
Google Calendar
Google Calendar
With Google Calendar, you can quickly schedule meetings and events and get reminders about upcoming activities, so you always know what’s next.
Shopify
Shopify
Shopify is a complete commerce platform that lets anyone start, manage, and grow a business. You can use Shopify to build an online store, manage sales, market to customers, and accept payments in digital and physical locations.
Supabase
Supabase
Supabase is an open source Firebase alternative.
MySQL
MySQL
MySQL is an open-source relational database management system.
PostgreSQL
PostgreSQL
PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.
Premium
AWS
AWS
Amazon Web Services (AWS) offers reliable, scalable, and inexpensive cloud computing services.
Premium
Twilio SendGrid
Twilio SendGrid
Send marketing and transactional email through the Twilio SendGrid platform with the Email API, proprietary mail transfer agent, and infrastructure for scalable delivery.
Amazon SES
Amazon SES
Amazon SES is a cloud-based email service provider that can integrate into any application for high volume email automation
Premium
Klaviyo
Klaviyo
Email Marketing and SMS Marketing Platform
Premium
Zendesk
Zendesk
Zendesk is award-winning customer service software trusted by 200K+ customers. Make customers happy via text, mobile, phone, email, live chat, social media.
Premium
ServiceNow
ServiceNow
The smarter way to workflow
Slack
Slack
Slack is a channel-based messaging platform. With Slack, people can work together more effectively, connect all their software tools and services, and find the information they need to do their best work — all within a secure, enterprise-grade environment.
Microsoft Teams
Microsoft Teams
Microsoft Teams has communities, events, chats, channels, meetings, storage, tasks, and calendars in one place.