Connect MemberSpace and Oracle Database

Both apps 27MemberSpace 15Oracle Database 12

• Trigger
  Canceled Membership

  Triggers when a member cancels a membership plan (sets it to cancel) or a plan is removed from a member.

• Trigger
  Created Member Profile

  Triggers when a new member signs up on your MemberSpace site, returning the member's profile.

• Trigger
  New member event

  Triggers when a new activity event is recorded for a member, such as a log in, plan added, plan upgraded or card updated.

• Trigger
  New Membership

  Triggers when a member is enrolled on a plan in your MemberSpace site, returning the new membership with its plan, status and billing details.

• Trigger
  Updated Member Profile

  Triggers when a member's profile changes — their name, email, status, profile image or custom signup field answers.

• Action
  Find Member

  Returns up to 100 members on your MemberSpace site that match the email, name, status, signup date or custom signup field answer you specify.

• Action
  Get plan

  Returns a single membership plan from your MemberSpace site, including its name, status, type, pricing and expiration settings.

• Action
  List content views

  Returns records of members viewing your Content Library content, optionally filtered by member, content item and view date.

• Action
  List coupon redemptions

  Returns the members who redeemed a coupon, most recent first, with the membership and plan it was applied to.

• Action
  List coupons

  Returns the discount coupons on your MemberSpace site, ordered by id. Optionally narrow the list to coupons with a specific code.

• Action
  List custom signup fields

  Returns the custom signup fields defined on your MemberSpace site, including each field's id.

• Action
  List member events

  Returns activity events recorded for your members, such as logins, plan changes and charges, optionally filtered by member, event type and date range.

• Action
  List memberships

  Returns the memberships on your MemberSpace site, optionally filtered by plan, member, status, and creation, renewal or expiration date.

• Action
  List plans

  Returns the active (non-archived) membership plans on your MemberSpace site, optionally filtered by plan type and status.

• Action
  List sites

  Returns the MemberSpace sites your API key can access, with each site's name, domain, currency, locale and member counts.

• Trigger
  New Column

  Fires when a new column appears on an Oracle table you choose.

• 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 Oracle database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected Oracle user's own schema.

• Action
  Add Row

  Add one row to a table on the connected Oracle 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 Oracle database and returns every row it matches.

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

  Runs a statement you write against the connected Oracle 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.