Create New User with Coassemble API on New Column from PostgreSQL API

Pipedream makes it easy to connect APIs for Coassemble, PostgreSQL and 2,400+ other apps remarkably fast.

Trigger workflow on

New Column from the PostgreSQL API

Next, do this

Create New User with the Coassemble 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 PostgreSQL trigger and Coassemble 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 PostgreSQL account
2. Configure Polling Interval
3. Select a Schema
4. Select a Table
Configure the Create New User action
1. Connect your Coassemble account
2. Configure Email
3. Optional- Select a User type
4. Optional- Configure Username
5. Optional- Configure Password
6. Optional- Configure First Name
7. Optional- Configure Last Name
8. Optional- Configure Timezone
9. Optional- Configure Avatar
10. Optional- Configure Email Verified
11. Optional- Configure Locale
12. Optional- Configure Active
13. Optional- Configure Disable course enrolment notification
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 PostgreSQL

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

Version:2.0.6

Key:postgresql-new-column

View on GitHub

PostgreSQL Overview#

On Pipedream, you can leverage the PostgreSQL app to create workflows that automate database operations, synchronize data across platforms, and react to database events in real-time. Think handling new row entries, updating records from webhooks, or even compiling reports on a set schedule. Pipedream's serverless platform provides a powerful way to connect PostgreSQL with a variety of apps, enabling you to create tailored automation that fits your specific needs.

Trigger Code#

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

export default {
  ...common,
  name: "New Column",
  key: "postgresql-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: "2.0.6",
  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
PostgreSQL	`postgresql`	`app`	This component uses the PostgreSQL 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#

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

Connecting to Restricted Databases

Either enable the shared static IP for this account below, or configure a VPC to deploy any workflow in your workspace to a private network with a dedicated static IP. Learn more in our docs.

SSL Setup

Configure SSL on your PostgreSQL database by providing the CA (Certificate Authority), and choosing between Full Verification, Verify Certificate Authority (CA), or Skip Verification. Skipping verification is not recommended as this has serious security implications.

About PostgreSQL#

PostgreSQL is a free and open-source relational database management system emphasizing extensibility and SQL compliance.

Action#

Create New User on Coassemble

Description:Create a user as a member of your campus or add an existing user to it. [See the docs here](https://developers.coassemble.com/api/users#add-users)

Version:0.0.1

Key:coassemble-create-new-user

View on GitHub

Coassemble Overview#

Coassemble is a user-friendly training and development platform that lets you create and deliver online courses. The Coassemble API enables the automation of various eLearning tasks, such as user management, course enrollment, and tracking course progress. By leveraging this API within Pipedream, you can streamline educational operations, synchronize educational data with other systems, and create dynamic learning experiences by triggering actions based on course activities.

Action Code#

import coassemble from "../../app/coassemble.app.mjs";
export default {
    key: "coassemble-create-new-user",
    name: "Create New User",
    version: "0.0.1",
    description: "Create a user as a member of your campus or add an existing user to it. [See the docs here](https://developers.coassemble.com/api/users#add-users)",
    type: "action",
    props: {
        coassemble,
        email: {
            type: "string",
            label: "Email",
            description: "The user's email address.",
        },
        userType: {
            type: "string",
            label: "User type",
            description: "Add this user to either your learners (student) or trainers (team).",
            optional: true,
            options: [
                "student",
                "team",
            ],
        },
        username: {
            type: "string",
            label: "Username",
            description: "A username for the new user. If omitted, their email address will be used instead.",
            optional: true,
        },
        password: {
            type: "string",
            label: "Password",
            description: "New user's password. If omitted, they will be prompted to set a password on first login.",
            optional: true,
            secret: true,
        },
        firstname: {
            type: "string",
            label: "First Name",
            description: "The new user's first name. If omitted, their email address will be used instead.",
            optional: true,
        },
        lastname: {
            type: "string",
            label: "Last Name",
            description: "The new user's last name, if they have one. This is completely optional.",
            optional: true,
        },
        timezone: {
            type: "string",
            label: "Timezone",
            description: "The new user's timezone. Will be automatically detected if not provided.",
            optional: true,
        },
        avatar: {
            type: "string",
            label: "Avatar",
            description: "URL pointing to the new user's avatar. They can set this later, or not at all, if desired.",
            optional: true,
        },
        emailVerified: {
            type: "boolean",
            label: "Email Verified",
            description: "Whether you'd like to skip the email verification process for this user.",
            optional: true,
        },
        locale: {
            type: "string",
            label: "Locale",
            description: "The user's locale (language and region). Will be automatically detected if not provided.",
            optional: true,
        },
        active: {
            type: "boolean",
            label: "Active",
            description: "Whether you'd like to skip activation for this user. Recommended for SSO usage.",
            optional: true,
        },
        disableCourseEnrolmentNotification: {
            type: "boolean",
            label: "Disable course enrolment notification",
            description: "Prevent this user from receiving notification emails when enrolled in a course.",
            optional: true,
        },
    },
    async run({ $ }) {
        const { coassemble, emailVerified: email_verified, disableCourseEnrolmentNotification: disable_course_enrolment_notification, ...data } = this;
        const response = await coassemble.createUser({
            $,
            data: {
                ...data,
                email_verified,
                disable_course_enrolment_notification,
            },
        });
        $.export("$summary", `A new User with id: ${response.id} was successfully created!`);
        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
Coassemble	`coassemble`	`app`	This component uses the Coassemble app.
Email	`email`	`string`	The user's email address.
User type	`userType`	`string`	Select a value from the drop down menu:`studentteam`
Username	`username`	`string`	A username for the new user. If omitted, their email address will be used instead.
Password	`password`	`string`	New user's password. If omitted, they will be prompted to set a password on first login.
First Name	`firstname`	`string`	The new user's first name. If omitted, their email address will be used instead.
Last Name	`lastname`	`string`	The new user's last name, if they have one. This is completely optional.
Timezone	`timezone`	`string`	The new user's timezone. Will be automatically detected if not provided.
Avatar	`avatar`	`string`	URL pointing to the new user's avatar. They can set this later, or not at all, if desired.
Email Verified	`emailVerified`	`boolean`	Whether you'd like to skip the email verification process for this user.
Locale	`locale`	`string`	The user's locale (language and region). Will be automatically detected if not provided.
Active	`active`	`boolean`	Whether you'd like to skip activation for this user. Recommended for SSO usage.
Disable course enrolment notification	`disableCourseEnrolmentNotification`	`boolean`	Prevent this user from receiving notification emails when enrolled in a course.

Action Authentication#

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

To retrieve your User ID and API Key,

Navigate to your Coassemble account and sign in
Go to “Settings” > “Integrations” > “Coassemble API”

Your domain is 1234 if your Coassemble workspace URL is https://1234.coassemble.com/