List Records with Airtable API on New Contact from Textlocal API

Pipedream makes it easy to connect APIs for Airtable, Textlocal and 1000+ other apps remarkably fast.

Trigger workflow on

New Contact from the Textlocal API

Next, do this

List Records with the Airtable API

No credit card required

▶

Watch us build a workflow

7 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

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

Select this integration
Configure the New Contact trigger
1. Connect your Textlocal account
2. Configure timer
3. Select a Contact Group
Configure the List Records action
1. Connect your Airtable account
2. Select a Base
3. Select a Table
4. Optional- Select a Sort: Field
5. Optional- Select a Sort: Direction
6. Optional- Configure Max Records
7. Optional- Configure Filter by Formula
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 Contact on Textlocal

Description:Emit new contact

Version:0.0.3

Key:textlocal-new-contact

View on GitHub

Textlocal Overview#

You can do so much with the Textlocal API! Textlocal is an easy-to-use platform
for sending and receiving mobile and SMS messages, making it a great avenue for
businesses to communicate with their customers. Here are a few examples of what
you can build with the Textlocal API:

Automate SMS marketing campaigns to customers
Notify customers of special offers and discounts
Send reminders and appointment confirmations
Create location-based notifications
Receive two-way communication from customers
Integrate text alerts into other applications, like business workflows and
CRMs
Send mass notifications during emergencies

Trigger Code#

import common from "../common/timer-based.mjs";

export default {
  ...common,
  key: "textlocal-new-contact",
  name: "New Contact",
  description: "Emit new contact",
  type: "source",
  version: "0.0.3",
  dedupe: "unique",
  props: {
    ...common.props,
    groupId: {
      type: "string",
      label: "Contact Group",
      description: "The contact group to monitor for new contacts",
      async options(context) {
        const { page } = context;
        if (page !== 0) {
          return [];
        }

        const { groups } = await this.textlocal.getGroups();
        const options = groups.map((group) => ({
          label: group.name,
          value: group.id,
        }));
        return {
          options,
        };
      },
    },
  },
  hooks: {
    ...common.hooks,
    deactivate() {
      this.db.set("isInitialized", false);
    },
  },
  methods: {
    ...common.methods,
    _isContactProcessed(contact) {
      const { number } = contact;
      return Boolean(this.db.get(number));
    },
    _markContactAsProcessed(contact) {
      const { number } = contact;
      this.db.set(number, true);
    },
    async takeContactGroupSnapshot() {
      const contactScan = await this.textlocal.scanContactGroup({
        groupId: this.groupId,
      });

      for await (const contact of contactScan) {
        this._markContactAsProcessed(contact);
      }
    },
    generateMeta({
      contact,
      ts,
    }) {
      const {
        number,
        first_name: firstName,
        last_name: lastName,
      } = contact;
      const maskedName = this.getMaskedName({
        firstName,
        lastName,
      });
      const maskedNumber = this.getMaskedNumber(number);
      const summary = `New contact: ${maskedName} (${maskedNumber})`;
      return {
        id: number,
        summary,
        ts,
      };
    },
    async processEvent(event) {
      const isInitialized = this.db.get("isInitialized");
      if (!isInitialized) {
        await this.takeContactGroupSnapshot();
        this.db.set("isInitialized", true);
        return;
      }

      const { timestamp: ts } = event;
      const contactScan = await this.textlocal.scanContactGroup({
        groupId: this.groupId,
      });

      for await (const contact of contactScan) {
        if (this._isContactProcessed(contact)) {
          continue;
        }

        const meta = this.generateMeta({
          contact,
          ts,
        });
        this.$emit(contact, meta);
        this._markContactAsProcessed(contact);
      }
    },
  },
};

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
Textlocal	`textlocal`	`app`	This component uses the Textlocal app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Contact Group	`groupId`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

Get your api key in your settings > API keys.

About Textlocal#

Bulk SMS Marketing Service for Business | Send ...

Action#

List Records on Airtable

Description:Retrieve records from a table with automatic pagination. Optionally sort and filter results.

Version:0.2.0

Key:airtable-list-records

View on GitHub

Airtable Overview#

Using the Airtable API, you can build applications that can:

Create and manage databases
Add, update, and delete records
Search for records
Sort and filter records
Display records in a variety of ways
Import and export data

Action Code#

import common from "../common.mjs";
import commonList from "../common-list.mjs";

export default {
  key: "airtable-list-records",
  name: "List Records",
  description: "Retrieve records from a table with automatic pagination. Optionally sort and filter results.",
  type: "action",
  version: "0.2.0",
  ...commonList,
  props: {
    ...common.props,
    ...commonList.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
Airtable	`airtable`	`app`	This component uses the Airtable app.
Base	`baseId`	`string`	Select a value from the drop down menu.
Table	`tableId`	`string`	Select a value from the drop down menu.
Sort: Field	`sortFieldId`	`string`	Select a value from the drop down menu.
Sort: Direction	`sortDirection`	`string`	Select a value from the drop down menu:`{ "label": "Descending", "value": "desc" }{ "label": "Ascending", "value": "asc" }`
Max Records	`maxRecords`	`integer`	Optionally limit the maximum number of records to return. Leave blank to retrieve all records.
Filter by Formula	`filterByFormula`	`string`	Optionally provide a formula used to filter records. The formula will be evaluated for each record, and if the result is not `0`, `false`, `""`, `NaN`, `[]`, or `#Error!` the record will be included in the response. For example, to only include records where `Name` isn't empty, pass `NOT({Name} = '')`.

Action Authentication#

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

Visit your account settings, copy your API key, and enter it below. If you only need to read data from Airtable, and not modify it, you can generate a read-only API key.

get airtable api key

About Airtable#

Looks like a spreadsheet, acts like a database.

More Ways to Connect Airtable + Textlocal#

Other Popular Integrations#

Delete Record with Airtable API on New Contact from Textlocal API

Textlocal + Airtable

List Records with Airtable API on New Contact from Textlocal API

Pipedream makes it easy to connect APIs for Airtable, Textlocal and 1000+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-12of1000+apps by most popular

1
-
12
of
1000+
apps by most popular