Send Message to a Public Channel with Slack API on New Table from MySQL API

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

Trigger workflow on

New Table from the MySQL API

Next, do this

Send Message to a Public Channel with the Slack API

No credit card required

▶

Watch us build a workflow

4 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the New Table trigger
1. Connect your MySQL account
2. Configure timer
Configure the Send Message to a Public Channel action
1. Connect your Slack account
2. Select a Channel ID
3. Configure Text
4. Optional- Configure Send text as Slack mrkdwn
5. Optional- Configure Bot Username
6. Optional- Select a Icon (emoji)
7. Optional- Configure Icon (image URL)
8. Optional- Configure Send as User
9. Optional- Configure Schedule message
10. Optional- Configure Include link to workflow
11. Optional- Configure Metadata Event Type
12. Optional- Configure Metadata Event Payload
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 Table on MySQL

Description:Emit new event when a new table is added to a database. [See the docs here](https://dev.mysql.com/doc/refman/8.0/en/select.html)

Version:2.0.1

Key:mysql-new-table

View on GitHub

MySQL Overview#

MySQL is a powerful database management system used by some of the largest
organizations in the world, including Facebook, Google, and Amazon. MySQL is an
open-source relational database management system (RDBMS), as well as a popular
choice for web applications used by millions of websites.

Some applications that can be built using the MySQL API include:

A web application that stores and retrieves data from a MySQL database
A desktop application that uses a MySQL database for data storage
A mobile application that interacts with a MySQL database

Trigger Code#

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

export default {
  ...common,
  key: "mysql-new-table",
  name: "New Table",
  description: "Emit new event when a new table is added to a database. [See the docs here](https://dev.mysql.com/doc/refman/8.0/en/select.html)",
  type: "source",
  version: "2.0.1",
  dedupe: "unique",
  props: {
    ...common.props,
    db: "$.service.db",
  },
  hooks: {
    async deploy() {
      const tables = await this.mysql.listTopTables({
        maxCount: 10,
      });
      this.iterateAndEmitEvents(tables);
      this._setLastResult(tables, "CREATE_TIME");
    },
  },
  methods: {
    ...common.methods,
    async listResults() {
      const lastResult = this._getLastResult();
      const tables = lastResult
        ? await this.mysql.listBaseTables({
          lastResult,
        })
        : await this.mysql.listTopTables({
          maxCount: 10,
        });
      this.iterateAndEmitEvents(tables);
      this._setLastResult(tables, "CREATE_TIME");
    },
    generateMeta({
      TABLE_NAME: tableName, CREATE_TIME: createTime,
    }) {
      return {
        id: tableName,
        summary: tableName,
        ts: Date.parse(createTime),
      };
    },
  },
};

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

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.

Before you connect to your MySQL database from Pipedream, please make sure your database is either:

Accessible from the public internet (You may need to add a firewall rule on 0.0.0.0/0 on port 3306), or
Accessible from a static IP that you've configured using a VPC in Pipedream, and enabled the workflow to connect through that VPC

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#

Send Message to a Public Channel on Slack

Description:Send a message to a public channel and customize the name and avatar of the bot that posts the message. See [postMessage](https://api.slack.com/methods/chat.postMessage) or [scheduleMessage](https://api.slack.com/methods/chat.scheduleMessage) docs here

Version:0.2.17

Key:slack-send-message-public-channel

View on GitHub

Slack Overview#

The Pipedream Slack app enables you to build event-driven workflows that interact with the Slack API. When you authorize the Pipedream app's access to your workspace, you can use Pipedream workflows to perform common Slack actions, or write your own code against the Slack API.

The Pipedream Slack app is not a typical app. You don't interact with it directly as a bot, and it doesn't add custom functionality to your workspace out of the box. It makes it easier to automate anything you'd typically use the Slack API for, using Pipedream workflows.

Automate posting updates to your team channels
Create a bot to answer common questions
Integrate with your existing tools and services
And much more!

Action Code#

import common from "../common/send-message.mjs";
import constants from "../../common/constants.mjs";

export default {
  ...common,
  key: "slack-send-message-public-channel",
  name: "Send Message to a Public Channel",
  description: "Send a message to a public channel and customize the name and avatar of the bot that posts the message. See [postMessage](https://api.slack.com/methods/chat.postMessage) or [scheduleMessage](https://api.slack.com/methods/chat.scheduleMessage) docs here",
  version: "0.2.17",
  type: "action",
  props: {
    slack: common.props.slack,
    conversation: {
      propDefinition: [
        common.props.slack,
        "channelId",
        () => ({
          types: [
            constants.CHANNEL_TYPE.PUBLIC,
          ],
        }),
      ],
    },
    text: {
      propDefinition: [
        common.props.slack,
        "text",
      ],
    },
    mrkdwn: {
      propDefinition: [
        common.props.slack,
        "mrkdwn",
      ],
    },
    username: {
      propDefinition: [
        common.props.slack,
        "username",
      ],
      description: "Optionally customize your bot's username (default is `Pipedream`).",
    },
    icon_emoji: {
      propDefinition: [
        common.props.slack,
        "icon_emoji",
      ],
      description: "Optionally use an emoji as the bot icon for this message (e.g., `:fire:`). This value overrides `icon_url` if both are provided.",
    },
    icon_url: {
      propDefinition: [
        common.props.slack,
        "icon_url",
      ],
      description: "Optionally provide an image URL to use as the bot icon for this message.",
    },
    ...common.props,
  },
};

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
Slack	`slack`	`app`	This component uses the Slack app.
Channel ID	`conversation`	`string`	Select a value from the drop down menu.
Text	`text`	`string`	Text of the message to send (see Slack's formatting docs). This field is usually necessary, unless you're providing only attachments instead.
Send text as Slack mrkdwn	`mrkdwn`	`boolean`	`TRUE` by default. Pass `FALSE` to disable Slack markup parsing. See docs here
Bot Username	`username`	`string`	Optionally customize your bot's user name (default is `Pipedream`). Must be used in conjunction with `as_user` set to false, otherwise ignored.
Icon (emoji)	`icon_emoji`	`string`	Select a value from the drop down menu.
Icon (image URL)	`icon_url`	`string`	Optionally provide an image URL to use as the icon for this message. Must be used in conjunction with `as_user` set to `false`, otherwise ignored.
Send as User	`as_user`	`boolean`	Optionally pass `TRUE` to post the message as the authed user, instead of as a bot. Defaults to `FALSE`.
Schedule message	`post_at`	`integer`	Messages can only be scheduled up to 120 days in advance, and cannot be scheduled for the past. The datetime format should be a unix timestamp (e.g., `1650507616`, see here for help with this format).
Include link to workflow	`include_sent_via_pipedream_flag`	`boolean`	Defaults to `true`, includes a link to the workflow at the end of your Slack message.
Metadata Event Type	`metadata_event_type`	`string`	The name of the metadata event
Metadata Event Payload	`metadata_event_payload`	`string`	The payload of the metadata event. Must be a JSON string e.g. `{"key": "value"}`

Action Authentication#

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

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

bookmarks:writecalls:readcalls:writechannels:historychannels:readchannels:writednd:readdnd:writeemoji:readfiles:readgroups:historygroups:readgroups:writeim:historyim:readim:writelinks:readlinks:writempim:historympim:readmpim:writepins:readpins:writereactions:readreactions:writereminders:readreminders:writeremote_files:readremote_files:sharestars:readstars:writeteam:readusergroups:readusergroups:writeusers:readusers:read.emailusers:writechat:write:botchat:write:usercommandsfiles:write:userusers.profile:writeusers.profile:readsearch:read

About 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.

More Ways to Connect Slack + MySQL#

Other Popular Integrations#

Execute Query with MySQL API on New Message In Channels from Slack API

Slack + MySQL

Send Message to a Public Channel with Slack API on New Table from MySQL API

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

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

Developers ♥ Pipedream

SSL Setup

1-24of2,000+apps by most popular

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