Connect Roam and SQL Server

Both apps 23Roam 12SQL Server 11

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

• 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 SQL Server database.

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected SQL Server database.

• Action
  Add Row

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

• Action
  Find Row via Custom Query

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

• Action
  Run Custom Statement

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