Create Invoice with Stripe API on New, Modified or Deleted Records from Airtable (OAuth) API

Pipedream makes it easy to connect APIs for Stripe, Airtable (OAuth) and 2,000+ other apps remarkably fast.

Trigger workflow on

New, Modified or Deleted Records from the Airtable (OAuth) API

Next, do this

Create Invoice with the Stripe 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 Airtable (OAuth) trigger and Stripe action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New, Modified or Deleted Records trigger
1. Connect your Airtable (OAuth) account
2. Configure timer
3. Select a Base
4. Select a Table
5. Optional- Configure Return Fields By Field ID
Configure the Create Invoice action
1. Connect your Stripe account
2. Select a Customer ID
3. Optional- Select a Subscription ID
4. Optional- Configure Description
5. Optional- Configure Auto Collect
6. Optional- Select a Collection Method
7. Optional- Configure Payment Terms
8. Optional- Select a Default Payment Method
9. Optional- Configure Metadata
10. Optional- Configure Advanced Options
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, Modified or Deleted Records on Airtable (OAuth)

Description:Emit new event each time a record is added, updated, or deleted in an Airtable table. Supports tables up to 10,000 records

Version:0.0.6

Key:airtable_oauth-new-modified-or-deleted-records

View on GitHub

Airtable (OAuth) Overview#

Airtable (OAuth) API on Pipedream allows you to manipulate and leverage your Airtable data in a myriad of powerful ways. Sync data between Airtable and other apps, trigger workflows on updates, or process bulk data operations asynchronously. By using Airtable's structured databases with Pipedream's serverless platform, you can craft custom automation solutions, integrate with other services seamlessly, and streamline complex data processes.

Trigger Code#

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

export default {
  ...base,
  name: "New, Modified or Deleted Records",
  key: "airtable_oauth-new-modified-or-deleted-records",
  version: "0.0.6",
  type: "source",
  description: "Emit new event each time a record is added, updated, or deleted in an Airtable table. Supports tables up to 10,000 records",
  props: {
    ...base.props,
    tableId: {
      propDefinition: [
        base.props.airtable,
        "tableId",
        ({ baseId }) => ({
          baseId,
        }),
      ],
      description: "The table ID to watch for changes.",
    },
    returnFieldsByFieldId: {
      propDefinition: [
        base.props.airtable,
        "returnFieldsByFieldId",
      ],
    },
  },
  methods: {
    ...base.methods,
    _getPrevAllRecordIds() {
      return this.db.get("prevAllRecordIds");
    },
    _setPrevAllRecordIds(prevAllRecordIds) {
      this.db.set("prevAllRecordIds", prevAllRecordIds);
    },
  },
  async run(event) {
    const {
      baseId,
      tableId,
      viewId,
    } = this;

    const metadata = {
      baseId,
      tableId,
      viewId,
    };

    const prevAllRecordIds = this._getPrevAllRecordIds();

    const lastTimestamp = this._getLastTimestamp();
    const params = {
      filterByFormula: `LAST_MODIFIED_TIME() > "${lastTimestamp}"`,
      returnFieldsByFieldId: this.returnFieldsByFieldId || false,
    };

    const records = await this.airtable.listRecords({
      baseId,
      tableId,
      params,
    });

    let allRecordIds = [],
      newRecordsCount = 0,
      modifiedRecordsCount = 0,
      deletedRecordsCount = 0;

    if (records) {
      for (const record of records) {
        if (!lastTimestamp || moment(record.createdTime) > moment(lastTimestamp)) {
          record.type = "new_record";
          newRecordsCount++;
        } else {
          record.type = "record_modified";
          modifiedRecordsCount++;
        }

        record.metadata = metadata;

        this.$emit(record, {
          summary: `${record.type}: ${JSON.stringify(record.fields)}`,
          id: record.id,
        });
      }
    }

    delete params.filterByFormula;

    const data = await this.airtable.listRecords({
      baseId,
      tableId,
      params,
    });
    if (!data.length || data.length === 0) return;
    allRecordIds = [
      ...data.map((record) => record.id),
    ];

    if (prevAllRecordIds) {
      const deletedRecordIds = prevAllRecordIds.filter(
        (prevRecord) => !allRecordIds.includes(prevRecord),
      );
      for (const recordID of deletedRecordIds) {
        deletedRecordsCount++;
        const deletedRecordObj = {
          metadata,
          type: "record_deleted",
          id: recordID,
        };
        this.$emit(deletedRecordObj, {
          summary: "record_deleted",
          id: recordID,
        });
      }
    }

    console.log(
      `Emitted ${newRecordsCount} new records(s) and ${modifiedRecordsCount} modified record(s) and ${deletedRecordsCount} deleted records.`,
    );
    this._setPrevAllRecordIds(allRecordIds);

    // We keep track of the timestamp of the current invocation
    this.updateLastTimestamp(event);
  },
};

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
Airtable (OAuth)	`airtable`	`app`	This component uses the Airtable (OAuth) app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Base	`baseId`	`string`	Select a value from the drop down menu.
Table	`tableId`	`string`	Select a value from the drop down menu.
Return Fields By Field ID	`returnFieldsByFieldId`	`boolean`	An optional boolean value that lets you return field objects where the key is the field id. This defaults to `false`, which returns field objects where the key is the field name.

Trigger Authentication#

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

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

data.records:readdata.records:writedata.recordComments:readdata.recordComments:writeschema.bases:readschema.bases:writewebhook:manageuser.email:read

About Airtable (OAuth)#

Airtable is a low-code platform to build next-gen apps. Move beyond rigid tools, operationalize your critical data, and reimagine workflows with AI.

Action#

Create Invoice on Stripe

Description:Create an invoice. [See the docs](https://stripe.com/docs/api/invoices/create) for more information

Version:0.1.0

Key:stripe-create-invoice

View on GitHub

Stripe Overview#

The Stripe API is a powerful tool for managing online payments, subscriptions, and invoices. With Pipedream, you can leverage this API to automate payment processing, monitor transactions, and sync billing data with other services. Pipedream's no-code platform allows for quick integration and creation of serverless workflows that react to Stripe events in real-time. For instance, you might automatically update customer records, send personalized emails after successful payments, or escalate failed transactions to your support team.

Action Code#

import pick from "lodash.pick";
import app from "../../stripe.app.mjs";

export default {
  key: "stripe-create-invoice",
  name: "Create Invoice",
  type: "action",
  version: "0.1.0",
  description: "Create an invoice. [See the docs](https://stripe.com/docs/api/invoices/create) " +
    "for more information",
  props: {
    app,
    customer: {
      propDefinition: [
        app,
        "customer",
      ],
      optional: false,
    },
    subscription: {
      propDefinition: [
        app,
        "subscription",
        ({ customer }) => ({
          customer,
        }),
      ],
    },
    description: {
      propDefinition: [
        app,
        "description",
      ],
    },
    auto_advance: {
      propDefinition: [
        app,
        "invoice_auto_advance",
      ],
    },
    collection_method: {
      propDefinition: [
        app,
        "invoice_collection_method",
      ],
      default: "charge_automatically",
      description: "When charging automatically, Stripe will attempt to pay this invoice using the default source attached to the customer. When sending an invoice, Stripe will email this invoice to the customer with payment instructions.",
    },
    days_until_due: {
      propDefinition: [
        app,
        "invoice_days_until_due",
      ],
    },
    default_payment_method: {
      propDefinition: [
        app,
        "payment_method",
        ({ customer }) => ({
          customer,
        }),
      ],
      label: "Default Payment Method",
      description: "Must belong to the customer associated with the invoice. If not set, " +
        "defaults to the subscription’s default payment method, if any, or to the default " +
        "payment method in the customer’s invoice settings.",
    },
    metadata: {
      propDefinition: [
        app,
        "metadata",
      ],
    },
    advanced: {
      propDefinition: [
        app,
        "metadata",
      ],
      label: "Advanced Options",
      description: "Add any additional parameters that you require here",
    },
  },
  async run({ $ }) {
    const resp = await this.app.sdk().invoices.create({
      ...pick(this, [
        "customer",
        "subscription",
        "auto_advance",
        "description",
        "collection_method",
        "days_until_due",
        "default_payment_method",
        "metadata",
      ]),
      ...this.advanced,
    });

    $.export("$summary", "Successfully created a new invoice");

    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
Stripe	`app`	`app`	This component uses the Stripe app.
Customer ID	`customer`	`string`	Select a value from the drop down menu.
Subscription ID	`subscription`	`string`	Select a value from the drop down menu.
Description	`description`	`string`
Auto Collect	`auto_advance`	`boolean`	Attempt to automatically collect the invoice. When disabled, the invoice's state will not automatically advance without an explicit action.
Collection Method	`collection_method`	`string`	Select a value from the drop down menu:`charge_automaticallysend_invoice`
Payment Terms	`days_until_due`	`integer`	The number of days until the invoice is due (valid when collection method is `send_invoice`)
Default Payment Method	`default_payment_method`	`string`	Select a value from the drop down menu.
Metadata	`metadata`	`object`	Associate other information that's meaningful to you with Stripe activity. Metadata will not be shown to customers or affect whether or not a payment is accepted.
Advanced Options	`advanced`	`object`	Add any additional parameters that you require here

Action Authentication#

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

Stripe uses API keys to authenticate requests (more info in their docs here).

To connect Pipedream to your Stripe account,

Create a Stripe API key
Click "Create Restricted Key"
Enter the Restricted API key below.

To help ensure proper security, we recommend you create a Restricted key with scopes relevant to the specific operations you will use in Pipedream.

About Stripe#

Stripe powers online and in-person payment processing and financial solutions for businesses of all sizes.

More Ways to Connect Stripe + Airtable (OAuth)#

Other Popular Integrations#

Create Multiple Records with Airtable API on Canceled Subscription from Stripe API

Stripe + Airtable (OAuth)

Create Invoice with Stripe API on New, Modified or Deleted Records from Airtable (OAuth) API

Pipedream makes it easy to connect APIs for Stripe, Airtable (OAuth) and 2,000+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,000+apps by most popular

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