Create New User with LightSpeed VT API on New Webhook Event (Instant) from Supabase API

Pipedream makes it easy to connect APIs for LightSpeed VT, Supabase and 2,400+ other apps remarkably fast.

Trigger workflow on

New Webhook Event (Instant) from the Supabase API

Next, do this

Create New User with the LightSpeed VT 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 Supabase trigger and LightSpeed VT action. When you configure and deploy the workflow, it will run on Pipedream's servers 24x7 for free.

Select this integration
Configure the New Webhook Event (Instant) trigger
1. Connect your Supabase account
2. Configure Table
3. Optional- Configure Row Identifier
Configure the Create New User action
1. Connect your LightSpeed VT account
2. Optional- Configure Is Active
3. Select a Location Id
4. Configure Username
5. Configure Password
6. Configure Email
7. Configure First Name
8. Configure Last Name
9. Optional- Configure Middle Name
10. Optional- Configure Title
11. Optional- Select a Gender
12. Optional- Configure DOB
13. Optional- Select a Language
14. Configure Access Level
15. Optional- Configure Company Name
16. Optional- Select a Team Id
17. Optional- Select a Job Position Id
18. Optional- Configure Hire Date
19. Optional- Configure Start Date
20. Optional- Configure Release Date
21. Optional- Configure Expire Date
22. Optional- Configure Affiliate Id
23. Optional- Configure Vendor Id
24. Optional- Configure Misc 1
25. Optional- Configure Misc 2
26. Optional- Configure Phone 1
27. Optional- Configure Phone 2
28. Optional- Select one or more Content Role Id
29. Optional- Configure Lock Username
30. Optional- Configure Lock Username Password
31. Optional- Configure Force Password Update
32. Optional- Configure Update My Profile
33. Optional- Configure Manage Users
34. Optional- Configure Billing Frequency
35. Optional- Configure Gross Fee Charged
36. Optional- Configure Promo Code
37. Optional- Configure Address 1
38. Optional- Configure Address 2
39. Optional- Configure City
40. Optional- Configure State
41. Optional- Configure ZIP
42. Optional- Configure Country
43. Optional- Configure Mobile
44. Optional- Configure Add Phone
45. Optional- Configure Cell Country
46. Optional- Configure Handle
47. Optional- Configure Hometown
48. Optional- Configure About Me
49. Optional- Configure Facebook
50. Optional- Configure LinkedIn
51. Optional- Configure Instagram
52. Optional- Configure Twitter
53. Optional- Configure Youtube
54. Optional- Configure TikTok
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 Webhook Event (Instant) on Supabase

Description:Emit new event for every `insert`, `update`, or `delete` operation in a table. This source requires user configuration using the Supabase website. More information in the README. [Also see documentation here](https://supabase.com/docs/guides/database/webhooks#creating-a-webhook)

Version:0.0.5

Key:supabase-new-webhook-event

View on GitHub

Supabase Overview#

Supabase is a real-time backend-as-a-service that provides developers with a suite of tools to quickly build and scale their applications. It offers database storage, authentication, instant APIs, and real-time subscriptions. With the Supabase API, you can perform CRUD operations on your database, manage users, and listen to database changes in real time. When integrated with Pipedream, you can automate workflows that react to these database events, synchronize data across multiple services, or streamline user management processes.

Trigger Code#

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

export default {
  key: "supabase-new-webhook-event",
  name: "New Webhook Event (Instant)",
  description: "Emit new event for every `insert`, `update`, or `delete` operation in a table. This source requires user configuration using the Supabase website. More information in the README. [Also see documentation here](https://supabase.com/docs/guides/database/webhooks#creating-a-webhook)",
  version: "0.0.5",
  type: "source",
  props: {
    ...base.props,
    http: {
      type: "$.interface.http",
    },
  },
  hooks: {
    async deploy() {
      const client = await this.supabase._client();
      const query = client
        .from(this.table)
        .select()
        .range(0, constants.HISTORICAL_EVENT_LIMIT);
      const { data } = await query;
      for (const row of data) {
        this.$emit({
          record: row,
        }, {
          summary: "Historical row in table",
        });
      }
    },
  },
  async run(event) {
    const { body: data } = event;
    let summary = `New ${data.type} event in table`;
    if (data.record?.[this.rowIdentifier]) {
      summary = `${summary}: ${data.record[this.rowIdentifier]}`;
    }
    this.$emit(data, {
      summary,
    });
  },
};

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
Supabase	`supabase`	`app`	This component uses the Supabase app.
Table	`table`	`string`	The name of the table to watch for new rows
Row Identifier	`rowIdentifier`	`string`	The column name to use as the row identifier
N/A	`http`	`$.interface.http`	This component uses `$.interface.http` to generate a unique URL when the component is first instantiated. Each request to the URL will trigger the `run()` method of the component.

Trigger Authentication#

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

Supabase provides a Service Key to get started. You can find the service_role in the API Settings page.

Finding the Supabase subdomain

About Supabase#

Supabase is an open source Firebase alternative.

Action#

Create New User on LightSpeed VT

Description:Creates a new user in the LightSpeed VT system. [See the documentation](https://lsvtapi.stoplight.io/docs/lsvt-rest-api/26844d671bbcf-create-user)

Version:0.0.1

Key:lightspeed_vt-create-new-user

View on GitHub

LightSpeed VT Overview#

LightSpeed VT is a learning management system (LMS) that provides a platform for delivering interactive training and e-learning experiences. Through the LightSpeed VT API, you can automate access to course catalogs, manage users, track progress and performance, and integrate this data with other systems. On Pipedream, you can leverage this API to create workflows that respond to events in real-time, synchronize training data with other platforms, and enhance the user learning experience with personalized automations.

Action Code#

import {
  GENDER_OPTIONS, LANGUAGE_OPTIONS,
} from "../../common/constants.mjs";
import lightspeedVt from "../../lightspeed_vt.app.mjs";

export default {
  key: "lightspeed_vt-create-new-user",
  name: "Create New User",
  description: "Creates a new user in the LightSpeed VT system. [See the documentation](https://lsvtapi.stoplight.io/docs/lsvt-rest-api/26844d671bbcf-create-user)",
  version: "0.0.1",
  type: "action",
  props: {
    lightspeedVt,
    isActive: {
      type: "boolean",
      label: "Is Active",
      description: "Set to return active or inactive users only.",
      optional: true,
    },
    locationId: {
      propDefinition: [
        lightspeedVt,
        "locationId",
      ],
    },
    username: {
      type: "string",
      label: "Username",
      description: "The username of the new user.",
    },
    password: {
      type: "string",
      label: "Password",
      description: "The password for the new user.",
      secret: true,
    },
    email: {
      type: "string",
      label: "Email",
      description: "The email of the new user.",
    },
    firstName: {
      type: "string",
      label: "First Name",
      description: "The first name of the new user.",
    },
    lastName: {
      type: "string",
      label: "Last Name",
      description: "The last name of the new user.",
    },
    middleName: {
      type: "string",
      label: "Middle Name",
      description: "The middle name of the new user.",
      optional: true,
    },
    title: {
      type: "string",
      label: "Title",
      description: "The title of the new user.",
      optional: true,
    },
    gender: {
      type: "string",
      label: "Gender",
      description: "The gender of the new user.",
      options: GENDER_OPTIONS,
      optional: true,
    },
    dob: {
      type: "string",
      label: "DOB",
      description: "Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's date of birth.",
      optional: true,
    },
    language: {
      type: "string",
      label: "Language",
      description: "Default: en-us - Language to set for user - Any valid ISO 639-1 code with region.",
      options: LANGUAGE_OPTIONS,
      optional: true,
    },
    accessLevel: {
      type: "integer",
      label: "Access Level",
      description: "The access level for the new user. [See Access Levels Definition](https://support.lightspeedvt.com/docs/access-level-management)",
      min: 2,
      max: 12,
    },
    companyName: {
      type: "string",
      label: "Company Name",
      description: "The company of the new user.",
      optional: true,
    },
    teamId: {
      propDefinition: [
        lightspeedVt,
        "teamId",
      ],
      optional: true,
    },
    jobPositionId: {
      propDefinition: [
        lightspeedVt,
        "jobPositionId",
      ],
      optional: true,
    },
    hireDate: {
      type: "string",
      label: "Hire Date",
      description: "Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's hiring date.",
      optional: true,
    },
    startDate: {
      type: "string",
      label: "Start Date",
      description: "Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's starting date.",
      optional: true,
    },
    releaseDate: {
      type: "string",
      label: "Release Date",
      description: "Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's release date.",
      optional: true,
    },
    expireDate: {
      type: "string",
      label: "Expire Date",
      description: "Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's account expiration date.",
      optional: true,
    },
    affiliateId: {
      type: "string",
      label: "Affiliate Id",
      description: "Affiliate Id associated with creation of user's account.",
      optional: true,
    },
    vendorId: {
      type: "string",
      label: "Vendor Id",
      description: "Custom vendor Id associated with creation of user's account.",
      optional: true,
    },
    misc1: {
      type: "string",
      label: "Misc 1",
      description: "Miscellaneous info field 1.",
      optional: true,
    },
    misc2: {
      type: "string",
      label: "Misc 2",
      description: "Miscellaneous info field 2.",
      optional: true,
    },
    phone1: {
      type: "string",
      label: "Phone 1",
      description: "User's phone number 1.",
      optional: true,
    },
    phone2: {
      type: "string",
      label: "Phone 2",
      description: "User's phone number 2.",
      optional: true,
    },
    contentRole: {
      propDefinition: [
        lightspeedVt,
        "contentRole",
      ],
      optional: true,
    },
    lockUsername: {
      type: "boolean",
      label: "Lock Username",
      description: "Restricts user from changing its username.",
      optional: true,
    },
    lockUsernamePassword: {
      type: "boolean",
      label: "Lock Username Password",
      description: "Restricts user from changing its username and password.",
      optional: true,
    },
    forcePasswordUpdate: {
      type: "boolean",
      label: "Force Password Update",
      description: "Forces user to update its password upon first sign in.",
      optional: true,
    },
    updateMyProfile: {
      type: "boolean",
      label: "Update My Profile",
      description: "Restricts user from updating its profile.",
      optional: true,
    },
    manageUsers: {
      type: "boolean",
      label: "Manage Users",
      description: "Restricts user from managing other users.",
      optional: true,
    },
    billingFrequency: {
      type: "integer",
      label: "Billing Frequency",
      description: "Use to specify the billing schedule frequency in months. **Required if your API settings are set to require this parameter**.",
      optional: true,
    },
    grossFeeCharged: {
      type: "string",
      label: "Gross Fee Charged",
      description: "Use to specify the fee per user. **Required if your API settings are set to require this parameter**.",
      optional: true,
    },
    promoCode: {
      type: "string",
      label: "Promo Code",
      description: "Promo code used during user's account creation.",
      optional: true,
    },
    address1: {
      type: "string",
      label: "Address 1",
      description: "User's address line 1.",
      optional: true,
    },
    address2: {
      type: "string",
      label: "Address 2",
      description: "User's address line 2.",
      optional: true,
    },
    city: {
      type: "string",
      label: "City",
      description: "User's city.",
      optional: true,
    },
    state: {
      type: "string",
      label: "State",
      description: "User's state or province.",
      optional: true,
    },
    zip: {
      type: "string",
      label: "ZIP",
      description: "User's zip or postal code.",
      optional: true,
    },
    country: {
      type: "string",
      label: "Country",
      description: "User's country.",
      optional: true,
    },
    mobile: {
      type: "string",
      label: "Mobile",
      description: "User's mobile phone.",
      optional: true,
    },
    addPhone: {
      type: "string",
      label: "Add Phone",
      description: "User's phone number 3.",
      optional: true,
    },
    cellCountry: {
      type: "string",
      label: "Cell Country",
      description: "User's mobile phone country code.",
      optional: true,
    },
    handle: {
      type: "string",
      label: "Handle",
      description: "This is the **Display Name** under **My Profile**. [View Support Article](https://support.lightspeedvt.com/knowledge-base/account-details/).",
      optional: true,
    },
    hometown: {
      type: "string",
      label: "Hometown",
      description: "User's hometown.",
      optional: true,
    },
    aboutMe: {
      type: "string",
      label: "About Me",
      description: "A short description about the user.",
      optional: true,
    },
    facebook: {
      type: "string",
      label: "Facebook",
      description: "Facebook username.",
      optional: true,
    },
    linkedIn: {
      type: "string",
      label: "LinkedIn",
      description: "LinkedIn username.",
      optional: true,
    },
    instagram: {
      type: "string",
      label: "Instagram",
      description: "Instagram username.",
      optional: true,
    },
    twitter: {
      type: "string",
      label: "Twitter",
      description: "Twitter handle.",
      optional: true,
    },
    youtube: {
      type: "string",
      label: "Youtube",
      description: "Youtube username.",
      optional: true,
    },
    tikTok: {
      type: "string",
      label: "TikTok",
      description: "TikTok username.",
      optional: true,
    },
  },
  async run({ $ }) {
    const {
      lightspeedVt,
      grossFeeCharged,
      ...data
    } = this;

    const response = await lightspeedVt.createUser({
      data: {
        ...data,
        grossFeeCharged: grossFeeCharged && parseFloat(grossFeeCharged),
      },
    });
    $.export("$summary", `Successfully created new user with ID ${response.userId}`);
    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
LightSpeed VT	`lightspeedVt`	`app`	This component uses the LightSpeed VT app.
Is Active	`isActive`	`boolean`	Set to return active or inactive users only.
Location Id	`locationId`	`string`	Select a value from the drop down menu.
Username	`username`	`string`	The username of the new user.
Password	`password`	`string`	The password for the new user.
Email	`email`	`string`	The email of the new user.
First Name	`firstName`	`string`	The first name of the new user.
Last Name	`lastName`	`string`	The last name of the new user.
Middle Name	`middleName`	`string`	The middle name of the new user.
Title	`title`	`string`	The title of the new user.
Gender	`gender`	`string`	Select a value from the drop down menu:`FemaleMale`
DOB	`dob`	`string`	Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's date of birth.
Language	`language`	`string`	Select a value from the drop down menu:`{ "label": "Arabic", "value": "ar" }{ "label": "Arabic (Egyptian)", "value": "ar-eg" }{ "label": "Armenian", "value": "hy-am" }{ "label": "Australian", "value": "en-au" }{ "label": "Bengali", "value": "bn-in" }{ "label": "Bulgarian", "value": "bg-bg" }{ "label": "Chinese", "value": "zh-cn" }{ "label": "Chinese - Hong Kong", "value": "zh-hk" }{ "label": "Chinese (Traditional)", "value": "zh-tw" }{ "label": "Czech Republic", "value": "cs-cz" }{ "label": "Dutch", "value": "nl-nl" }{ "label": "English", "value": "en-us" }{ "label": "English (GB)", "value": "en-gb" }{ "label": "English (NZ)", "value": "en-nz" }{ "label": "English (Queen's)", "value": "en-ca" }{ "label": "English (Southern)", "value": "en-aq" }{ "label": "French", "value": "fr-fr" }{ "label": "French-Canadian", "value": "fr-ca" }{ "label": "German", "value": "de-de" }{ "label": "Haitian (Creole)", "value": "ht-ht" }{ "label": "Hebrew", "value": "he-il" }{ "label": "Hindi", "value": "hi-in" }{ "label": "Italian", "value": "it-it" }{ "label": "Japanese", "value": "ja" }{ "label": "Korean", "value": "ko-kr" }{ "label": "Lithuanian", "value": "lt-lt" }{ "label": "Malay", "value": "ms" }{ "label": "Mongolian", "value": "mn-mn" }{ "label": "Polish", "value": "pl-pl" }{ "label": "Portuguese", "value": "pt-pt" }{ "label": "Portuguese (Brazil)", "value": "pt-br" }{ "label": "Romanian (MD)", "value": "ro-md" }{ "label": "Russian", "value": "ru-ru" }{ "label": "Serbian", "value": "sr-rs" }{ "label": "Slovak", "value": "sk-sk" }{ "label": "Slovenian", "value": "sl-si" }{ "label": "Spanish", "value": "es-es" }{ "label": "Spanish (Col)", "value": "es-co" }{ "label": "Spanish (Ecuador)", "value": "es-ec" }{ "label": "Spanish (Mex)", "value": "es-mx" }{ "label": "Spanish (US)", "value": "es-us" }{ "label": "Swahili", "value": "sw" }{ "label": "Thai", "value": "th-th" }{ "label": "Turkish", "value": "tr-tr" }{ "label": "Vietnamese", "value": "vi-vn" }`
Access Level	`accessLevel`	`integer`	The access level for the new user. See Access Levels Definition
Company Name	`companyName`	`string`	The company of the new user.
Team Id	`teamId`	`string`	Select a value from the drop down menu.
Job Position Id	`jobPositionId`	`string`	Select a value from the drop down menu.
Hire Date	`hireDate`	`string`	Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's hiring date.
Start Date	`startDate`	`string`	Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's starting date.
Release Date	`releaseDate`	`string`	Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's release date.
Expire Date	`expireDate`	`string`	Valid ISO 8601 timestamp, i.e. yyyyy-MM-ddTHH:mm:ssZ - User's account expiration date.
Affiliate Id	`affiliateId`	`string`	Affiliate Id associated with creation of user's account.
Vendor Id	`vendorId`	`string`	Custom vendor Id associated with creation of user's account.
Misc 1	`misc1`	`string`	Miscellaneous info field 1.
Misc 2	`misc2`	`string`	Miscellaneous info field 2.
Phone 1	`phone1`	`string`	User's phone number 1.
Phone 2	`phone2`	`string`	User's phone number 2.
Content Role Id	`contentRole`	`integer[]`	Select a value from the drop down menu.
Lock Username	`lockUsername`	`boolean`	Restricts user from changing its username.
Lock Username Password	`lockUsernamePassword`	`boolean`	Restricts user from changing its username and password.
Force Password Update	`forcePasswordUpdate`	`boolean`	Forces user to update its password upon first sign in.
Update My Profile	`updateMyProfile`	`boolean`	Restricts user from updating its profile.
Manage Users	`manageUsers`	`boolean`	Restricts user from managing other users.
Billing Frequency	`billingFrequency`	`integer`	Use to specify the billing schedule frequency in months. Required if your API settings are set to require this parameter.
Gross Fee Charged	`grossFeeCharged`	`string`	Use to specify the fee per user. Required if your API settings are set to require this parameter.
Promo Code	`promoCode`	`string`	Promo code used during user's account creation.
Address 1	`address1`	`string`	User's address line 1.
Address 2	`address2`	`string`	User's address line 2.
City	`city`	`string`	User's city.
State	`state`	`string`	User's state or province.
ZIP	`zip`	`string`	User's zip or postal code.
Country	`country`	`string`	User's country.
Mobile	`mobile`	`string`	User's mobile phone.
Add Phone	`addPhone`	`string`	User's phone number 3.
Cell Country	`cellCountry`	`string`	User's mobile phone country code.
Handle	`handle`	`string`	This is the Display Name under My Profile. View Support Article.
Hometown	`hometown`	`string`	User's hometown.
About Me	`aboutMe`	`string`	A short description about the user.
Facebook	`facebook`	`string`	Facebook username.
LinkedIn	`linkedIn`	`string`	LinkedIn username.
Instagram	`instagram`	`string`	Instagram username.
Twitter	`twitter`	`string`	Twitter handle.
Youtube	`youtube`	`string`	Youtube username.
TikTok	`tikTok`	`string`	TikTok username.

Action Authentication#

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

To retrieve your API Keys and API Password,

Navigate to your LightSpeed VT account and sign in
Go to “Super User Dashboard” > “API Management”

About LightSpeed VT#

LightSpeed VT is the most effective web-based training system on Earth. We provide the foundation for creating a training experience like no other.

More Ways to Connect LightSpeed VT + Supabase#

Other Popular Integrations#

Create New User with LightSpeed VT API on New Row Added from Supabase API

Supabase + LightSpeed VT

Try it

Delete Row with Supabase API on New User Added from LightSpeed VT API

LightSpeed VT + Supabase

Try it

Insert Row with Supabase API on New User Added from LightSpeed VT API

LightSpeed VT + Supabase

Try it

Remote Procedure Call with Supabase API on New User Added from LightSpeed VT API

LightSpeed VT + Supabase

Try it

Update Row with Supabase API on New User Added from LightSpeed VT API

LightSpeed VT + Supabase

Try it

Popular Triggers#

New Row Added from the Supabase API

Emit new event for every new row added in a table. See documentation here

Try it

New Webhook Event (Instant) from the Supabase API

Emit new event for every insert, update, or delete operation in a table. This source requires user configuration using the Supabase website. More information in the README. Also see documentation here

Try it

New User Added from the LightSpeed VT API

Emit new event every time there is a new user in the system

Try it