Merge RSS Feeds with RSS API on New Row Created from Coda API

Pipedream makes it easy to connect APIs for RSS, Coda and 1,600+ other apps remarkably fast.

Trigger workflow on

New Row Created from the Coda API

Next, do this

Merge RSS Feeds with the RSS API

No credit card required

▶

Watch us build a workflow

7 min

Watch now ➜

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

Developers ♥ Pipedream

Getting Started#

This integration creates a workflow with a Coda trigger and RSS 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 Created trigger
1. Connect your Coda account
2. Configure timer
3. Select a Doc ID
4. Select a Table ID
5. Optional- Configure Include Updated Rows
Configure the Merge RSS Feeds action
1. Connect your RSS account
2. Configure Feed URLs
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 Created on Coda

Description:Emit new event for every created / updated row in a table. [See the documentation.](https://coda.io/developers/apis/v1#tag/Rows/operation/listRows)

Version:0.0.3

Key:coda-row-created

View on GitHub

Coda Overview#

With the Coda API, you can build:

A list of all the docs you have access to
A table of contents for a doc
A specific page from a doc
A list of all the action items in a doc
A list of all the people who have access to a doc
A list of all the docs a specific person has access to
A list of all the changes made to a doc

Trigger Code#

import coda from "../../coda.app.mjs";
import { DEFAULT_POLLING_SOURCE_TIMER_INTERVAL } from "@pipedream/platform";

export default {
  key: "coda-row-created",
  name: "New Row Created",
  description: "Emit new event for every created / updated row in a table. [See the documentation.](https://coda.io/developers/apis/v1#tag/Rows/operation/listRows)",
  type: "source",
  version: "0.0.3",
  dedupe: "unique",
  props: {
    coda,
    db: "$.service.db",
    timer: {
      type: "$.interface.timer",
      default: {
        intervalSeconds: DEFAULT_POLLING_SOURCE_TIMER_INTERVAL,
      },
    },
    docId: {
      propDefinition: [
        coda,
        "docId",
      ],
    },
    tableId: {
      propDefinition: [
        coda,
        "tableId",
        (c) => ({
          docId: c.docId,
        }),
      ],
    },
    includeUpdates: {
      type: "boolean",
      label: "Include Updated Rows",
      description: "Emit events for updates on existing rows?",
      optional: true,
    },
  },
  hooks: {
    async deploy() {
      const rows = await this.fetchRows(25);
      this.emitEvents(rows.reverse());
    },
  },
  methods: {
    _getLastTs() {
      return this.db.get("lastTs") || 0;
    },
    _setLastTs(lastTs) {
      this.db.set("lastTs", lastTs);
    },
    getTsKey() {
      return this.includeUpdates
        ? "updatedAt"
        : "createdAt";
    },
    async fetchRows(maxResults) {
      const rows = [];
      const tsKey = this.getTsKey();
      const lastTs = this._getLastTs();
      let maxTs = lastTs;
      let done = false;

      const params = {
        sortBy: tsKey,
      };

      while (true) {
        const {
          items = [],
          nextPageToken,
        } = await this.coda.findRow(
          null,
          this.docId,
          this.tableId,
          params,
        );
        for (const item of items) {
          const ts = Date.parse(item[tsKey]);
          if (ts > lastTs) {
            rows.push(item);
            if (ts > maxTs) {
              maxTs = ts;
            }
            if (rows.length >= maxResults) {
              done = true;
              break;
            }
          }
          else {
            done = true;
          }
        }
        params.pageToken = nextPageToken;

        if (!nextPageToken || done) {
          this._setLastTs(maxTs);
          return rows;
        }
      }
    },
    rowSummary(row) {
      const name = row.name && ` - ${row.name}` || "";
      return `Row index: ${row.index}` + name;
    },
    emitEvents(events) {
      for (const row of events) {
        const id = this.includeUpdates
          ? `${row.id}-${row.updatedAt}`
          : row.id;

        this.$emit(row, {
          id,
          summary: this.rowSummary(row),
          ts: row.updatedAt,
        });
      }
    },
  },
  async run() {
    const rows = await this.fetchRows();
    this.emitEvents(rows.reverse());
  },
};

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
Coda	`coda`	`app`	This component uses the Coda app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
	`timer`	`$.interface.timer`
Doc ID	`docId`	`string`	Select a value from the drop down menu.
Table ID	`tableId`	`string`	Select a value from the drop down menu.
Include Updated Rows	`includeUpdates`	`boolean`	Emit events for updates on existing rows?

Trigger Authentication#

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

Get your Coda API token in My account on Coda.

About Coda#

A doc as powerful as an app.

Action#

Merge RSS Feeds on RSS

Description:Retrieve multiple RSS feeds and return a merged array of items sorted by date [See documentation](https://www.rssboard.org/rss-specification)

Version:1.2.3

Key:rss-merge-rss-feeds

View on GitHub

RSS Overview#

With the RSS API you have the power to create powerful tools and applications.
RSS is a great way to reliably subscribe to, track and build around your
favorite content sources. Here are some examples of things you can create
using the RSS API:

A personal news website to syndicate articles from multiple sources.
A custom feed reader to deliver timely notifications of updates and news.
A live editorial dashboard to track news, trends and public sentiment.
An automated “report bot” to aggregate and report on news topics.
A competitor tracking tool to stay on top of industry news.
A custom RSS-based search engine or RSS-supported deep learning engine.
A live events feed to notify users and followers of new developments.

Action Code#

import rss from "../../app/rss.app.mjs";
import { defineAction } from "@pipedream/types";
export default defineAction({
    name: "Merge RSS Feeds",
    description: "Retrieve multiple RSS feeds and return a merged array of items sorted by date [See documentation](https://www.rssboard.org/rss-specification)",
    key: "rss-merge-rss-feeds",
    version: "1.2.3",
    type: "action",
    props: {
        rss,
        urls: {
            propDefinition: [
                rss,
                "urls",
            ],
        },
    },
    async run({ $ }) {
        const items = [];
        for (const url of this.urls) {
            const feedItems = await this.rss.fetchAndParseFeed(url);
            items.push(...feedItems);
        }
        $.export("$summary", "Successfully merged feeds");
        return this.rss.sortItemsForActions(items);
    },
});