Connect Rootly and SQL Server

Both apps 29Rootly 18SQL Server 11

• Trigger
  New Alert

  Triggers when a new alert is created in Rootly.

• Trigger
  New Incident

  Triggers when a new incident is created in Rootly.

• Trigger
  New Pulse

  Triggers when a new pulse, such as a deploy or config change, is recorded in Rootly.

• Action
  Add action item

  Adds an action item (task or follow-up) to a Rootly incident.

• Action
  Add service

  Creates a new service in Rootly's service catalog.

• Action
  Create Alert

  Creates a new alert in Rootly and returns its ID and status.

• Action
  Create Incident

  Creates a new incident in Rootly and returns its ID, status and link.

• Action
  Create Pulse

  Records a pulse in Rootly, such as a deploy or configuration change, and returns its ID.

• Action
  Get Alert

  Returns one Rootly alert by its ID.

• Action
  Get Incident

  Returns one Rootly incident by its ID.

• Action
  Get Pulse

  Returns one Rootly pulse by its ID.

• Action
  List alerts

  Returns alerts in your Rootly organization, optionally filtered by status, source, service, team, environment, label or time range.

• Action
  List incidents

  Returns incidents in your Rootly organization, optionally filtered by status, severity, services, teams, dates and more.

• Action
  List pulses

  Returns the pulses (deploys and other change events) recorded in Rootly, optionally filtered by source, service, environment, label, ref or time range.

• Action
  List services

  Returns the services in your Rootly organization, optionally filtered by name, slug, external ids or creation date.

• Action
  List teams

  Returns the teams in your Rootly organization, optionally filtered by name, slug, color, external ids or creation date.

• Action
  List users

  Returns the users in your Rootly organization, optionally filtered by search text, email, role or creation date.

• Action
  Update incident

  Updates an existing Rootly incident's title, status, severity, teams, services, timestamps and other details.

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