Create Payment Link with Mamo Business API on New Row from MySQL API

Pipedream makes it easy to connect APIs for Mamo Business, MySQL and 2,400+ other apps remarkably fast.

Trigger workflow on

New Row from the MySQL API

Next, do this

Create Payment Link with the Mamo Business 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 MySQL trigger and Mamo Business action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Row trigger
1. Connect your MySQL account
2. Configure timer
3. Select a Table
4. Optional- Select a Column
Configure the Create Payment Link action
1. Connect your Mamo Business account
2. Configure Title
3. Optional- Configure Description
4. Optional- Configure Capacity
5. Optional- Configure Active
6. Optional- Configure Return URL
7. Optional- Configure Failure Return URL
8. Optional- Configure Processing Fee Percentage
9. Optional- Configure Amount
10. Select a Amount Currency
11. Optional- Configure Is Widget
12. Optional- Configure Enable Tabby
13. Optional- Configure Enable Message
14. Optional- Configure Enable Tips
15. Optional- Configure Enable Customer Details
16. Optional- Configure Enable Quantity
17. Optional- Configure Enable QR Code
18. Optional- Configure Send Customer Receipt
19. Optional- Configure First Name
20. Optional- Configure Last Name
21. Optional- Configure Email
22. Optional- Configure External Id
23. Optional- Configure Custom Data
24. Configure Is Recurring
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 Row on MySQL

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

Version:2.0.5

Key:mysql-new-row

View on GitHub

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";

const { mysql } = common.props;

export default {
  ...common,
  key: "mysql-new-row",
  name: "New Row",
  description: "Emit new event when you add a new row to 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,
        }),
      ],
      optional: true,
    },
  },
  hooks: {
    /**
     * If column prop is left blank, get the table's primary key to use for ordering and deduping.
     * */
    async deploy() {
      const { table } = this;
      let column = this.column;

      if (!column) {
        const keyData = await this.mysql.getPrimaryKey({
          table,
        });
        column = keyData[0].Column_name;
      }

      this._setColumn(column);

      await this.listTopRows(column);
    },
  },
  methods: {
    ...common.methods,
    _getColumn() {
      return this.db.get("column");
    },
    _setColumn(column) {
      this.db.set("column", column);
    },
    async listResults() {
      const column = this._getColumn();
      await this.listRowResults(column);
    },
    iterateAndEmitEvents(rows) {
      const column = this._getColumn();
      for (const row of rows) {
        const meta = this.generateMeta(row, column);
        this.$emit(row, meta);
      }
    },
    generateMeta(row, column) {
      return {
        id: row[column],
        summary: `New Row Added ${column}: ${row[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.

Label	Prop	Type	Description
MySQL	`mysql`	`app`	This component uses the MySQL app.
	`timer`	`$.interface.timer`
Table	`table`	`string`	Select a value from the drop down menu.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Column	`column`	`string`	Select 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#

Create Payment Link on Mamo Business

Description:Generate a vanilla or subscription payment link. [See the documentation](https://mamopay.readme.io/reference/post_links)

Version:0.0.1

Key:mamo_business-create-payment-link

View on GitHub

Mamo Business Overview#

The Mamo Business API offers capabilities for organizations to manage payments and financial tasks. With the API, you can create and oversee invoices, process payments, and handle transfers among other operations. Integrating Mamo Business with Pipedream allows you to automate workflows involving payment processing, financial monitoring, and syncing transaction data with other business systems. Use it to streamline how money moves into and out of your organization, ensuring accurate financial records while saving time on manual tasks.

Action Code#

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

export default {
  key: "mamo_business-create-payment-link",
  name: "Create Payment Link",
  version: "0.0.1",
  description: "Generate a vanilla or subscription payment link. [See the documentation](https://mamopay.readme.io/reference/post_links)",
  type: "action",
  props: {
    app,
    title: {
      type: "string",
      label: "Title",
      description: "The title of the payment link.",
    },
    description: {
      type: "string",
      label: "Description",
      description: "Payment description. This will appear on the payment checkout page.",
      optional: true,
    },
    capacity: {
      type: "integer",
      label: "Capacity",
      description: "The capacity will be ignored when the subscription params exist and value will be null.",
      optional: true,
    },
    active: {
      type: "boolean",
      label: "Active",
      description: "Whether the payment is active or not.",
      optional: true,
    },
    returnUrl: {
      type: "string",
      label: "Return URL",
      description: "The URL which the customer will be redirected to after a successful payment.",
      optional: true,
    },
    failureReturnUrl: {
      type: "string",
      label: "Failure Return URL",
      description: "The URL which the customer will be redirected to after a failure payment.",
      optional: true,
    },
    processingFeePercentage: {
      type: "integer",
      label: "Processing Fee Percentage",
      description: "The percentage of the transaction that is the fee.",
      optional: true,
    },
    amount: {
      type: "string",
      label: "Amount",
      description: "The value number of the payment.",
      optional: true,
    },
    amountCurrency: {
      type: "string",
      label: "Amount Currency",
      description: "The currency that the transaction will be charged.",
      default: "AED",
      options: [
        "AED",
        "USD",
        "EUR",
        "GBP",
        "SAR",
      ],
    },
    isWidget: {
      type: "boolean",
      label: "Is Widget",
      description: "Generate widget payment link.",
      optional: true,
    },
    enableTabby: {
      type: "boolean",
      label: "Enable Tabby",
      description: "Enables the ability for customers to buy now and pay later.",
      optional: true,
    },
    enableMessage: {
      type: "boolean",
      label: "Enable Message",
      description: "Enables the ability for customers to add a message during the checkout process.",
      optional: true,
    },
    enableTips: {
      type: "boolean",
      label: "Enable Tips",
      description: "Enables the tips option. This will be displayed on the first screen.",
      optional: true,
    },
    enableCustomerDetails: {
      type: "boolean",
      label: "Enable Customer Details",
      description: "Enables adding customer details such as the name, email, and phone number. This screen will be displayed before the payment details screen.",
      optional: true,
    },
    enableQuantity: {
      type: "boolean",
      label: "Enable Quantity",
      description: "Enable the payment link to be used multiple times.",
      optional: true,
    },
    enableQrCode: {
      type: "boolean",
      label: "Enable QR Code",
      description: "Adds the ability to verify a payment through a QR code.",
      optional: true,
    },
    sendCustomerReceipt: {
      type: "boolean",
      label: "Send Customer Receipt",
      description: "Enables the sending of customer receipts.",
      optional: true,
    },
    firstName: {
      type: "string",
      label: "First Name",
      description: "The first name of customer which will pre-populate in card info step.",
      optional: true,
    },
    lastName: {
      type: "string",
      label: "Last Name",
      description: "The last name of customer which will pre-populate in card info step.",
      optional: true,
    },
    email: {
      type: "string",
      label: "Email",
      description: "The email of customer which will pre-populate in card info step.",
      optional: true,
    },
    externalId: {
      type: "string",
      label: "External Id",
      description: "The external ID of your choice to associate with payments captured by this payment link.",
      optional: true,
    },
    customData: {
      type: "object",
      label: "Custom Data",
      description: "An object with custom data of the payment link.",
      optional: true,
    },
    isRecurring: {
      type: "boolean",
      label: "Is Recurring",
      description: "Whether this payment link is for a recurring payment.",
      reloadProps: true,
    },
  },
  async additionalProps() {
    const props = {};
    if (this.isRecurring) {
      props.frequency = {
        type: "string",
        label: "Frequency",
        description: "Defines the interval that this subscription will be run on.",
        options: [
          "weekly",
          "monthly",
          "annually",
        ],
      };
      props.frequencyInterval = {
        type: "integer",
        label: "Frequency Interval",
        description: "Defines how often this subscription will run. This will be based on the frequency property defined above.",
      };
      props.endDate = {
        type: "string",
        label: "End Date",
        description: "The last date this subscription could run on. Format: YYYY/MM/DD",
      };
      props.paymentQuantity = {
        type: "string",
        label: "Payment Quantity",
        description: "Number of times this subscription will occur. If end_date defined, end_date takes precedence.",
      };
    }
    return props;
  },
  async run({ $ }) {
    const {
      app,
      returnUrl,
      failureReturnUrl,
      processingFeePercentage,
      amountCurrency,
      isWidget,
      enableTabby,
      enableMessage,
      enableTips,
      enableCustomerDetails,
      enableQuantity,
      enableQrCode,
      sendCustomerReceipt,
      firstName,
      lastName,
      externalId,
      customData,
      isRecurring,
      frequency,
      frequencyInterval,
      endDate,
      paymentQuantity,
      ...data
    } = this;

    const obj = {
      return_url: returnUrl,
      failure_return_url: failureReturnUrl,
      processing_fee_percentage: processingFeePercentage,
      amount_currency: amountCurrency,
      is_widget: isWidget,
      enable_tabby: enableTabby,
      enable_message: enableMessage,
      enable_tips: enableTips,
      enable_customer_details: enableCustomerDetails,
      enable_quantity: enableQuantity,
      enable_qr_code: enableQrCode,
      send_customer_receipt: sendCustomerReceipt,
      first_name: firstName,
      last_name: lastName,
      external_id: externalId,
      custom_data: customData && parseObject(customData),
      ...data,
    };
    if (isRecurring) {
      obj.subscription = {
        frequency,
        frequency_interval: frequencyInterval,
        end_ate: endDate,
        payment_quantity: paymentQuantity,
      };
    }

    const response = await app.createPaymentLink({
      $,
      data: obj,
    });

    $.export("$summary", `A new payment link with Id: ${response.id} was successfully created!`);
    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
Mamo Business	`app`	`app`	This component uses the Mamo Business app.
Title	`title`	`string`	The title of the payment link.
Description	`description`	`string`	Payment description. This will appear on the payment checkout page.
Capacity	`capacity`	`integer`	The capacity will be ignored when the subscription params exist and value will be null.
Active	`active`	`boolean`	Whether the payment is active or not.
Return URL	`returnUrl`	`string`	The URL which the customer will be redirected to after a successful payment.
Failure Return URL	`failureReturnUrl`	`string`	The URL which the customer will be redirected to after a failure payment.
Processing Fee Percentage	`processingFeePercentage`	`integer`	The percentage of the transaction that is the fee.
Amount	`amount`	`string`	The value number of the payment.
Amount Currency	`amountCurrency`	`string`	Select a value from the drop down menu:`AEDUSDEURGBPSAR`
Is Widget	`isWidget`	`boolean`	Generate widget payment link.
Enable Tabby	`enableTabby`	`boolean`	Enables the ability for customers to buy now and pay later.
Enable Message	`enableMessage`	`boolean`	Enables the ability for customers to add a message during the checkout process.
Enable Tips	`enableTips`	`boolean`	Enables the tips option. This will be displayed on the first screen.
Enable Customer Details	`enableCustomerDetails`	`boolean`	Enables adding customer details such as the name, email, and phone number. This screen will be displayed before the payment details screen.
Enable Quantity	`enableQuantity`	`boolean`	Enable the payment link to be used multiple times.
Enable QR Code	`enableQrCode`	`boolean`	Adds the ability to verify a payment through a QR code.
Send Customer Receipt	`sendCustomerReceipt`	`boolean`	Enables the sending of customer receipts.
First Name	`firstName`	`string`	The first name of customer which will pre-populate in card info step.
Last Name	`lastName`	`string`	The last name of customer which will pre-populate in card info step.
Email	`email`	`string`	The email of customer which will pre-populate in card info step.
External Id	`externalId`	`string`	The external ID of your choice to associate with payments captured by this payment link.
Custom Data	`customData`	`object`	An object with custom data of the payment link.
Is Recurring	`isRecurring`	`boolean`	Whether this payment link is for a recurring payment.