Connect Common Room and SQL Server

Both apps 24Common Room 13SQL Server 11

• Trigger
  Custom Fields List

  Triggers when a new contact custom field is added to the Common Room community.

• Trigger
  Segment Status List

  Triggers when a new status is added to the selected Common Room segment.

• Action
  Add Activity From Third Party Source

  Adds an activity from a third-party system to a Common Room API signal source, or updates an activity previously added with the same activity ID and type.

• Action
  Add Common Room Contact to Segment

  Adds one or more existing Common Room contacts to an existing segment, identified by email, Twitter, GitHub or LinkedIn, optionally setting their segment status.

• Action
  Add Organization From Third Party Source

  Adds an organization to a Common Room API source, or updates the organization previously added with the same domain.

• Action
  Add or Update a Contact Custom Field

  Sets the value of a contact custom field on a Common Room contact, creating or updating the contact in an API signal source.

• Action
  Add tag

  Creates a tag in Common Room, or returns the existing tag if one with the same name already exists.

• Action
  Delete tag

  Deletes a tag and removes it from everywhere it was applied. A tag that segments or workflows still use can't be deleted.

• Action
  Get tag

  Returns a Common Room tag by its id, including its name, description and the entity types it may be assigned to.

• Action
  List activity types

  Returns every activity type defined in your Common Room community, with its id and display name.

• Action
  List segments

  Returns all segments in the Common Room community, with each segment's id and name.

• Action
  List tags

  Returns all user-defined tags in your Common Room community, with their names, descriptions and the record types they can be applied to.

• Action
  Update tag

  Renames a tag or changes its description. A deleted tag is restored when it is updated.

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