Connect Oracle Database and ReadyCloud Suite

Both apps 29Oracle Database 12ReadyCloud Suite 17

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

• Trigger
  New Order

  Triggers when a new order is created in the selected ReadyCloud organization.

• Action
  Add order note

  Adds a note to an existing ReadyCloud order, optionally attributed to a named author.

• Action
  Add product

  Creates a product (SKU) in a ReadyCloud organization's product catalog.

• Action
  Add tag

  Adds a tag to a ReadyCloud order.

• Action
  Create Contact

  Creates a new contact in a ReadyCloud organization's directory, with optional addresses and custom fields.

• Action
  Create Member Event

  Creates a calendar event for a member of a ReadyCloud organization, with its title, times, location and alert.

• Action
  Create Order

  Creates a new order in a ReadyCloud organization, with its shipping and billing addresses, boxes, tags, notes and custom fields.

• Action
  Find boxes

  Returns every box packed for a ReadyCloud order, with dimensions, weight, shipping options, tracking number and custom fields.

• Action
  Find Contact

  Returns the contacts in a ReadyCloud organization's directory that match the email address and/or first and last name you supply.

• Action
  Find Order

  Returns the orders in a ReadyCloud organization that match a search phrase and/or filters such as order number, primary ID, PO number, customer email, tag, status or date range.

• Action
  Find products

  Returns the products in a ReadyCloud organization whose code, part number, EAN, ISBN or UPS matches the search text, or whose description contains it.

• Action
  Get contact

  Returns one contact from a ReadyCloud organization's directory, including its addresses, custom fields and optionally its notes.

• Action
  Get order

  Returns one ReadyCloud order with its billing and shipping details, addresses, boxes, tags, notes, relations and custom fields.

• Action
  Update contact

  Updates an existing contact in a ReadyCloud organization's directory. Only the details you fill in are changed.

• Action
  Update order

  Updates an existing order in a ReadyCloud organization, changing only the details you fill in, and returns the updated order.

• Action
  Update product

  Updates an existing product in a ReadyCloud organization's product catalog. Only the details you fill in are changed.

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