Connect Reamaze and SQL Server

Both apps 25Reamaze 14SQL Server 11

• Trigger
  New Contact

  Triggered when a new contact is created in Re:amaze.

• Action
  Add Message to Conversation

  Adds a new message to an existing conversation.

• Action
  Create Contact

  Creates a new contact in Re:amaze from an email address or mobile number.

• Action
  Create Conversation

  Create a new conversation on behalf of a user.

• Action
  Create SMS Contact

  Creates a Re:amaze contact identified by a mobile phone number, so they can be reached by SMS.

• Action
  Create SMS Conversation

  Create a new SMS conversation on behalf of a user.

• Action
  Get Article

  Retrieve a single FAQ article by id.

• Action
  Get Contact

  Looks up a single Re:amaze contact by email address.

• Action
  Get Conversation

  Retrieve a single conversation by slug, including its messages.

• Action
  List Contacts

  Lists contacts on the Re:amaze account, optionally searching by name or email, filtering by contact type, and sorting by creation date.

• Action
  List Messages

  Returns messages from across all of your conversations, newest first. Narrow the results by sender type, tags, source, sender email, channel, or date range.

• Action
  Update Article

  Update an existing FAQ article's content or status.

• Action
  Update Contact

  Update an existing contact's fields (name, email, tags, etc).

• Action
  Update Conversation

  Update a conversation's status, category, tags, or assignee.

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