Get Conversations with Symbl.ai API on New Column from Neon Postgres API

Pipedream makes it easy to connect APIs for Symbl.ai, Neon Postgres and 2,900+ other apps remarkably fast.

Trigger workflow on

New Column from the Neon Postgres API

Next, do this

Get Conversations with the Symbl.ai 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 Neon Postgres trigger and Symbl.ai action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Column trigger
1. Connect your Neon Postgres account
2. Configure Polling Interval
3. Select a Schema
4. Select a Table
Configure the Get Conversations action
1. Connect your Symbl.ai account
2. Optional- Configure Limit
3. Optional- Configure Offset
4. Optional- Select a Order
5. Optional- Configure Start Time
6. Optional- Configure End Time
7. Optional- Configure Sort
8. Optional- Configure Filter
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 Column on Neon Postgres

Description:Emit new event when a new column is added to a table. [See the documentation](https://node-postgres.com/features/queries)

Version:0.0.1

Key:neon_postgres-new-column

View on GitHub

Trigger Code#

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

export default {
  ...common,
  name: "New Column",
  key: "neon_postgres-new-column",
  description: "Emit new event when a new column is added to a table. [See the documentation](https://node-postgres.com/features/queries)",
  version: "0.0.1",
  type: "source",
  props: {
    ...common.props,
    schema: {
      propDefinition: [
        common.props.postgresql,
        "schema",
      ],
    },
    table: {
      propDefinition: [
        common.props.postgresql,
        "table",
        (c) => ({
          schema: c.schema,
        }),
      ],
    },
  },
  async run() {
    const previousColumns = this._getPreviousValues() || [];

    const columns = await this.postgresql.getColumns(this.table, this.schema);

    const newColumns = columns.filter((column) => !previousColumns.includes(column));
    for (const column of newColumns) {
      const meta = this.generateMeta(column);
      this.$emit(column, meta);
    }

    this._setPreviousValues(columns);
  },
};

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
Neon Postgres	`postgresql`	`app`	This component uses the Neon Postgres app.
N/A	`db`	`$.service.db`	This component uses `$.service.db` to maintain state between executions.
Polling Interval	`timer`	`$.interface.timer`	Pipedream will poll the API on this schedule
Schema	`schema`	`string`	Select a value from the drop down menu.
Table	`table`	`string`	Select a value from the drop down menu.

Trigger Authentication#

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

About Neon Postgres#

Serverless Postgres in seconds

Action#

Get Conversations on Symbl.ai

Description:Get a list of all conversations. See the doc [here](https://docs.symbl.ai/docs/conversation-api/all-conversations/)

Version:0.0.4

Key:symbl_ai-get-conversations

View on GitHub

Symbl.ai Overview#

The Symbl.ai API supercharges your applications with advanced conversation intelligence. By tapping into Symbl.ai via Pipedream, you can automate the analysis of voice, text, and video communications. Extract actionable items, follow-ups, and insights in real-time or from recorded content. This API's magic lies in its ability to provide contextually relevant insights, topic detection, sentiment analysis, and conversation metrics without extensive training data or setup time.

Action Code#

import symblAIApp from "../../symbl_ai.app.mjs";
import constants from "../../common/constants.mjs";

export default {
  key: "symbl_ai-get-conversations",
  name: "Get Conversations",
  description: "Get a list of all conversations. See the doc [here](https://docs.symbl.ai/docs/conversation-api/all-conversations/)",
  version: "0.0.4",
  annotations: {
    destructiveHint: false,
    openWorldHint: true,
    readOnlyHint: true,
  },
  type: "action",
  props: {
    symblAIApp,
    limit: {
      type: "integer",
      label: "Limit",
      description: "Specifies the limit number of conversations to be returned. Default value is `20`.",
      optional: true,
      min: 0,
      max: 65536,
    },
    offset: {
      type: "integer",
      label: "Offset",
      description: "Specifies the number of items to skip before applying `limit`",
      optional: true,
    },
    order: {
      type: "string",
      label: "Order",
      description: "Specifies the order in which the results should be sorted based on the start time.",
      options: Object.values(constants.resultsOrder),
      optional: true,
    },
    startTime: {
      type: "string",
      label: "Start Time",
      description: "Specifies the start of the date and time range for the results to be returned. Values accepted are [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601) formatted strings.",
      optional: true,
    },
    endTime: {
      type: "string",
      label: "End Time",
      description: "Specifies the end of the date and time range for the results to be returned. Values accepted are [ISO 8601](https://en.wikipedia.org/wiki/ISO_8601) formatted strings.",
      optional: true,
    },
    sort: {
      type: "string",
      label: "Sort",
      description: "Specifies the field to be used to sort the results. Default value is `conversation.startTime`.",
      optional: true,
    },
    filter: {
      type: "string",
      label: "Filter",
      description: "Specifies a filter string in RSQL format to filter the results. Default value is `conversation.startDate <= {currentTimestamp - 7 days}`.",
      optional: true,
    },
  },
  async run({ $ }) {
    const { conversations } = await this.symblAIApp.getConversations({
      $,
      params: {
        limit: this.limit,
        offset: this.offset,
        order: this.order,
        startTime: this.startTime,
        endTime: this.endTime,
        sort: this.sort,
        filter: this.filter,
      },
    });
    $.export("$summary", `Successfully retrieved ${conversations.length} conversations`);
    return conversations;
  },
};

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
Symbl.ai	`symblAIApp`	`app`	This component uses the Symbl.ai app.
Limit	`limit`	`integer`	Specifies the limit number of conversations to be returned. Default value is `20`.
Offset	`offset`	`integer`	Specifies the number of items to skip before applying `limit`
Order	`order`	`string`	Select a value from the drop down menu:`ascdesc`
Start Time	`startTime`	`string`	Specifies the start of the date and time range for the results to be returned. Values accepted are ISO 8601 formatted strings.
End Time	`endTime`	`string`	Specifies the end of the date and time range for the results to be returned. Values accepted are ISO 8601 formatted strings.
Sort	`sort`	`string`	Specifies the field to be used to sort the results. Default value is `conversation.startTime`.
Filter	`filter`	`string`	Specifies a filter string in RSQL format to filter the results. Default value is `conversation.startDate <= {currentTimestamp - 7 days}`.

Action Authentication#

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

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

Get Conversations with Symbl.ai API on New Column from Neon Postgres API

Pipedream makes it easy to connect APIs for Symbl.ai, Neon Postgres and 2,900+ other apps remarkably fast.

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

Developers ♥ Pipedream

1-24of2,900+apps by most popular

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