Create Table Record with Pipefy API on New Comments By Search from Pushshift Reddit Search API

Pipedream makes it easy to connect APIs for Pipefy, Pushshift Reddit Search and 2,400+ other apps remarkably fast.

Trigger workflow on

New Comments By Search from the Pushshift Reddit Search API

Next, do this

Create Table Record with the Pipefy 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 Pushshift Reddit Search trigger and Pipefy action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Comments By Search trigger
1. Connect your Pushshift Reddit Search account
2. Configure Polling schedule
3. Optional- Configure IDs
4. Configure Q
5. Optional- Configure Size
6. Optional- Configure Fields
7. Optional- Select a Sort
8. Optional- Select a Sort Type
9. Optional- Select a Aggs
10. Optional- Configure Author
11. Optional- Configure Subreddit
12. Optional- Select a Frequency
13. Optional- Configure Metadata
Configure the Create Table Record action
1. Connect your Pipefy account
2. Select a Organization
3. Select a Table
4. Configure Title
5. Optional- Select one or more Members
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 Comments By Search on Pushshift Reddit Search

Description:Emit new event when a search of Reddit comments using the Pushshift.io API returns new results.

Version:0.0.3

Key:pushshift_reddit_search-new-comments-by-search

View on GitHub

Pushshift Reddit Search Overview#

Using Pushshift's Reddit Search API, you can build a variety of apps to explore
popular content from Reddit. Here are a few examples of what you can create
with the API:

Create filtered searching of Reddit content. With the Pushshift API, you can
filter Reddit content by string matches, subreddit, user ID, and more.
Build a Reddit-based article summarizer. Use the API to identify trending
topics and articles posted to Reddit and summarize them for easy reading.
Create subreddit recommendations. Use the API to identify posts related to a
certain topic and make personalized recommendations of subreddits associated
with that topic.
Develop a sentiment analysis tool. The API allows you to identify sentiment
in Reddit posts, providing a useful tool for understanding people’s opinions
on topics.
Create a subreddit crawler. With the API, you can crawl through subreddits to
identify posts that meet certain criteria - Allowing you to find the latest
news and hot topics in no time.
Develop an app for monitoring. Use the API to track keyword mentions and
subreddit activity over time to see how topics and conversations are trending
on Reddit.
Build an analytics dashboard. Use the API to aggregate Reddit data and build
a dashboard to visualize trends in popular topics and conversation over time.

Trigger Code#

import pushshift from "../../pushshift_reddit_search.app.mjs";
import utils from "../../common/utils.mjs";
import base from "../common/base.mjs";

export default {
  key: "pushshift_reddit_search-new-comments-by-search",
  name: "New Comments By Search",
  description: "Emit new event when a search of Reddit comments using the Pushshift.io API returns new results.",
  version: "0.0.3",
  type: "source",
  dedupe: "unique",
  props: {
    ...base.props,
    ids: {
      propDefinition: [
        pushshift,
        "ids",
      ],
    },
    q: {
      propDefinition: [
        pushshift,
        "q",
      ],
    },
    size: {
      propDefinition: [
        pushshift,
        "size",
      ],
    },
    fields: {
      propDefinition: [
        pushshift,
        "fields",
      ],
    },
    sort: {
      propDefinition: [
        pushshift,
        "sort",
      ],
    },
    sortType: {
      propDefinition: [
        pushshift,
        "sortType",
      ],
    },
    aggs: {
      propDefinition: [
        pushshift,
        "aggs",
      ],
    },
    author: {
      propDefinition: [
        pushshift,
        "author",
      ],
    },
    subreddit: {
      propDefinition: [
        pushshift,
        "subreddit",
      ],
    },
    frequency: {
      propDefinition: [
        pushshift,
        "frequency",
      ],
    },
    metadata: {
      propDefinition: [
        pushshift,
        "metadata",
      ],
    },
  },
  methods: {
    ...base.methods,
    generateMeta(comment) {
      return {
        id: comment.id,
        summary: `New Comment ID: ${comment.id}`,
        ts: comment.created_utc,
      };
    },
  },
  async run(event) {
    const params = utils.omitEmptyStringValues({
      q: this.q,
      ids: this.ids,
      size: this.size,
      fields: this.fields,
      sort: this.sort,
      sort_type: this.sortType,
      aggs: this.aggs,
      author: this.author,
      subreddit: this.subreddit,
      frequency: this.frequency,
      metadata: this.metadata,
      after: this._getAfter(),
    });

    const comments = await this.pushshift.searchComments({
      params,
    });
    for (const comment of comments) {
      const meta = this.generateMeta(comment);
      this.$emit(comment, meta);
    }

    this._setAfter(event.timestamp);
  },
};

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
Pushshift Reddit Search	`pushshift`	`app`	This component uses the Pushshift Reddit Search app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling schedule	`timer`	`$.interface.timer`	Pipedream will poll the Pushshift.io API on this schedule.
IDs	`ids`	`string`	Get specific submissions via their ids. Enter as comma-delimited base36 ids.
Q	`q`	`string`	Search term. Will search ALL possible fields
Size	`size`	`integer`	Number of results to return (Integer <= 500)
Fields	`fields`	`string`	Only return specific fields (comma delimited)
Sort	`sort`	`string`	Select a value from the drop down menu:`ascdesc`
Sort Type	`sortType`	`string`	Select a value from the drop down menu:`scorenum_commentscreated_utc`
Aggs	`aggs`	`string`	Select a value from the drop down menu:`authorlink_idcreated_utcsubreddit`
Author	`author`	`string`	Restrict to a specific author
Subreddit	`subreddit`	`string`	Restrict to a specific subreddit
Frequency	`frequency`	`string`	Select a value from the drop down menu:`secondminutehourday`
Metadata	`metadata`	`boolean`	Include metadata search information

Trigger Authentication#

The Pushshift Reddit Search API does not require authentication.

About Pushshift Reddit Search#

The pushshift.io Reddit API was designed and created by the /r/datasets mod team to help provide enhanced functionality and search capabilities for searching Reddit comments and submissions. The project lead, /u/stuck_in_the_matrix, is the maintainer of the Reddit comment and submissions archives located at https://files.pushshift.io. This RESTful API gives full functionality for searching Reddit data and also includes the capability of creating powerful data aggregations. With this API, you can quickly find the data that you are interested in and find fascinating correlations.

Action#

Create Table Record on Pipefy

Description:Creates a new table record. [See the docs here](https://api-docs.pipefy.com/reference/mutations/createTableRecord/)

Version:0.1.2

Key:pipefy-create-table-record

View on GitHub

Pipefy Overview#

Pipefy is a platform that empowers users to streamline complex processes and workflows without the need for technical skills. With the Pipefy API, you can automate various aspects of your Pipefy environment, such as creating cards, updating fields, and managing pipelines programmatically. Use Pipedream to connect Pipefy with hundreds of other apps and orchestrate workflows that can save time, reduce errors, and enhance efficiency.

Action Code#

import pipefy from "../../pipefy.app.mjs";

export default {
  key: "pipefy-create-table-record",
  name: "Create Table Record",
  description: "Creates a new table record. [See the docs here](https://api-docs.pipefy.com/reference/mutations/createTableRecord/)",
  version: "0.1.2",
  type: "action",
  props: {
    pipefy,
    organization: {
      propDefinition: [
        pipefy,
        "organization",
      ],
    },
    table: {
      propDefinition: [
        pipefy,
        "table",
        (c) => ({
          orgId: c.organization,
        }),
      ],
      reloadProps: true,
    },
    title: {
      type: "string",
      label: "Title",
      description: "Title of the new record",
    },
    assignees: {
      propDefinition: [
        pipefy,
        "members",
        (c) => ({
          orgId: c.organization,
        }),
      ],
    },
  },
  async additionalProps() {
    const props = {};
    const fields = await this.pipefy.listTableFields(this.table);
    for (const field of fields) {
      props[field.id] = {
        type: "string",
        label: field.label,
        description: field.description,
        optional: !field.required,
      };
      if (field.options.length > 0) {
        props[field.id].options = field.options;
      }
    }
    return props;
  },
  async run({ $ }) {
  /*
  Example query:

  mutation createNewTableRecord{
    createTableRecord(
        input: {id: 301501717, title: "Test Record" } ) {
            table_record{id status title}
        }
    }
  */
    const fieldsAttributes = [];
    const fields = await this.pipefy.listTableFields(this.table);
    for (const field of fields) {
      if (this[field.id]) {
        fieldsAttributes.push({
          field_id: field.id,
          field_value: this[field.id],
        });
      }
    }

    const variables = {
      tableId: this.table,
      assigneeIds: this.assignees,
      title: this.title,
      fieldsAttributes,
    };

    const response = await this.pipefy.createTableRecord(variables);
    $.export("$summary", "Successfully created table record");
    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
Pipefy	`pipefy`	`app`	This component uses the Pipefy app.
Organization	`organization`	`string`	Select a value from the drop down menu.
Table	`table`	`string`	Select a value from the drop down menu.
Title	`title`	`string`	Title of the new record
Members	`assignees`	`string[]`	Select a value from the drop down menu.

Action Authentication#

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

To authorize requests to the Pipefy API, you'll need to generate a Personal access token. In order to create Pipefy triggers in Pipedream, you will need to be a Pipefy administrator.

Go to https://app.pipefy.com/tokens
Click Generate new token and give the token a description
Click Save

Create Table Record with Pipefy API on New Comments By Search from Pushshift Reddit Search API

Pipedream makes it easy to connect APIs for Pipefy, Pushshift Reddit Search and 2,400+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,400+apps by most popular

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