Connect LifterLMS and SQL Server

Both apps 35LifterLMS 24SQL Server 11

• Trigger
  Course Access Cancelled

  Triggers when a student's enrollment in the selected LifterLMS course is cancelled.

• Trigger
  Course Access Expired

  Triggers when a student's access to a LifterLMS course expires.

• Trigger
  Membership Access Cancelled

  Triggers when a student's access to a LifterLMS membership is cancelled.

• Trigger
  Membership Access Expired

  Triggers when a student's access to the selected LifterLMS membership expires.

• Trigger
  New Course

  Triggers when a new course is created in LifterLMS.

• Trigger
  New Course Enrollment

  Triggers when a student enrolls in the selected LifterLMS course.

• Trigger
  New Membership

  Triggers when a new LifterLMS membership is created.

• Trigger
  New Membership Enrollment

  Triggers when a student is enrolled in the selected LifterLMS membership.

• Trigger
  New Order

  Triggers when a new LifterLMS order is placed on your site, optionally limited to a status, student, product or access plan.

• Trigger
  New Student

  Triggers when a new LifterLMS student (a WordPress user with the student role) is created.

• Action
  Cancel Course Access

  Cancels a student's access to a LifterLMS course by setting their course enrollment status to cancelled.

• Action
  Cancel Membership Access

  Cancels a student's access to a LifterLMS membership by setting their membership enrollment status to cancelled.

• Action
  Create a WordPress User

  Creates a new WordPress user (a LifterLMS student) on your site, with the student role unless you choose another.

• Action
  Enroll in a Course

  Enrolls a WordPress user (student) in a LifterLMS course and returns the new enrollment.

• Action
  Enroll in a Membership

  Enrolls a WordPress user in a LifterLMS membership and returns the resulting enrollment.

• Action
  Expire Course Access

  Sets a student's enrollment in a LifterLMS course to expired and returns the updated enrollment.

• Action
  Expire Membership Access

  Sets a student's enrollment in a LifterLMS membership to expired and returns the updated enrollment.

• Action
  Find Courses

  Searches LifterLMS courses by a search term and returns the matching courses.

• Action
  Get Course

  Returns the details of a LifterLMS course, including its title, content, status, enrollment and access dates, and catalog settings.

• Action
  Get Course Enrollment

  Returns a student's enrollment in a LifterLMS course, including its status, dates and what triggered it.

• Action
  Get Order

  Returns the details of a LifterLMS order, including the student, purchased course or membership, access plan, totals and status.

• Action
  Retrieve a WordPress User

  Returns a WordPress user (LifterLMS student) by their user ID, including profile and billing details.

• Action
  Search WordPress User by Email

  Finds the WordPress user (LifterLMS student) whose email address exactly matches the one you supply, and returns their profile.

• Action
  Search WordPress User by Username

  Finds the WordPress user on your LifterLMS site whose username exactly matches the one you supply, and returns their profile.

• Trigger
  New or Updated Row

  Triggers when a new row is added or modified.

• Trigger
  New or Updated Row (Custom Query)

  Fires for each new or changed row returned by a SELECT statement you write against the connected SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

  Add one row to a table on the connected SQL Server database.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Find the first row in a table whose chosen column matches a value.

• Action
  Find Rows via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns every row it matches.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected SQL Server database and returns the first row it matches.

• Action
  Run Custom Statement

  Runs a statement you write against the connected SQL Server database that changes data rather than returning rows, and reports how many rows it changed.

• Action
  Update Row

  Change column values on every row of a table whose chosen column matches a value.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.