Connect Oracle Database and Wodify Core

Both apps 33Oracle Database 12Wodify Core 21

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

• Trigger
  New/Updated Client

  Triggers when a client is added or an existing client is updated in Wodify.

• Trigger
  Tag Changed on Client

  Triggers when a client's tags change (a tag is added to or removed from a client).

• Action
  Add class reservation

  Reserves a spot in a class for a client, optionally as a recurring reservation.

• Action
  Add membership

  Creates a new membership for a client from a membership template. Values you leave blank are filled in from the template.

• Action
  Add Tag to Client

  Adds one or more tags to a Wodify client and returns the client's current tags.

• Action
  Add Tag to Lead

  Adds one or more tags to a Wodify lead and returns the lead's current tags.

• Action
  Add/Update Lead

  Creates a new lead in Wodify, or updates an existing lead when a Lead ID is supplied.

• Action
  Convert lead to client

  Converts a Lead into a Client. Any details you leave blank keep the Lead's existing values.

• Action
  Delete client

  Deletes an inactive Wodify client by its ID.

• Action
  Delete lead

  Deletes a lead record from Wodify by its ID.

• Action
  Find leads by criteria

  Searches your Wodify leads with a search query and returns the matching leads.

• Action
  Get Client

  Returns a Wodify client record by its id, including contact details, status, tags, memberships flags and custom field answers.

• Action
  Get Lead

  Returns a single Wodify lead record by its lead ID.

• Action
  Get membership

  Returns a single membership record by its membership ID.

• Action
  List clients

  Returns the clients in your Wodify account.

• Action
  List employees

  Returns the employees (staff and coaches) in your Wodify account.

• Action
  List invoices

  Returns the invoices in your Wodify gym, with amounts, status, due and paid dates, and the client or lead each one belongs to.

• Action
  List leads

  Returns the leads in your Wodify account, up to 100 at a time.

• Action
  List memberships

  Returns the memberships in your Wodify account, up to 100 at a time.

• Action
  Remove Tag From Client

  Removes one or more tags from a Wodify client and returns the client's remaining tags.

• Action
  Remove Tag From Lead

  Removes the given tags from a Wodify lead and returns the lead's remaining tags.

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