Connect Oracle Database and Referrizer

Both apps 26Oracle Database 12Referrizer 14

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

  Triggers when a new contact is added in Referrizer.

• Trigger
  New Visit

  Triggers when a contact checks in (a new visit is recorded) in Referrizer.

• Action
  Create Contact

  Creates a new contact in Referrizer and returns it.

• Action
  Create Custom Field

  Creates a custom field on Referrizer contacts.

• Action
  Create Label

  Creates a label for tagging Referrizer contacts.

• Action
  Create Visit

  Checks a Referrizer contact in by creating a visit.

• Action
  Delete Contact

  Deletes a Referrizer contact.

• Action
  Find Contact

  Finds Referrizer contacts matching an email or phone number.

• Action
  Get Contact

  Returns one Referrizer contact by its ID.

• Action
  Get Label

  Returns one Referrizer label by its ID.

• Action
  Get Visit

  Returns one Referrizer visit by its ID.

• Action
  Send Text

  Sends an SMS text to a Referrizer contact or phone number.

• Action
  Update Contact

  Updates an existing Referrizer contact and returns it.

• Action
  Update Loyalty Points

  Adds or subtracts loyalty points on a Referrizer contact.

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