Connect Oracle Database to Roam

Both apps 24Oracle Database 12Roam 12

• 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
  Lobby Booked

  Triggers when a lobby is booked.

• Trigger
  New Recording

  Triggers when a new meeting recording is saved in your Roam.

• Trigger
  New Transcript

  Triggers when a new transcript is saved in your Roam.

• Trigger
  On-Air: Event Created

  Triggers when a new On-Air event is created.

• Trigger
  On-Air: Guest Added

  Triggers when a guest is added to an On-Air event.

• Trigger
  On-Air: Guest RSVP Changed

  Triggers when a guest changes their RSVP status on an On-Air event.

• Action
  Create Meeting Link

  Creates a new Roam meeting link and returns its ID and shareable URL. Optionally set the host's email and the meeting's start and end times.

• Action
  Find User by Email

  Looks up a member of your Roam organization by their email address and returns their profile, including user ID, name, photo and admin status.

• Action
  On-Air: Add Guest

  Adds a guest to a Roam On-Air event by email, optionally setting their name, phone and RSVP status, and returns the created guest.

• Action
  On-Air: Find Event

  Returns the On-Air events whose title contains the text you search for, taken from your most recent events. Returns an empty list when nothing matches.

• Action
  Send Channel Message

  Posts a message to a Roam channel and returns the message's timestamp, which you can reuse to reply in the same thread.

• Action
  Send Direct Message

  Sends a direct message to one person in Roam and returns the conversation ID plus the message's timestamp, which you can reuse to reply in the same thread.

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