Connect SmartMatchApp and SQL Server

Both apps 39SmartMatchApp 28SQL Server 11

• Trigger
  New Client

  Triggers when a new client is created.

• Trigger
  New Client Note

  Triggers when a note is added to a client.

• Trigger
  New Task

  Triggers when a new task is created.

• Action
  Create Client

  Creates a new client in your SmartMatchApp agency and returns its ID.

• Action
  Create Client Match

  Creates a match between a client and another client and returns the match ID.

• Action
  Create Client Note

  Adds a note to a client and returns the note ID.

• Action
  Create Email Draft

  Creates an email draft and returns its ID.

• Action
  Create Task

  Creates a task and returns its ID.

• Action
  Create Task Note

  Adds a note to a task and returns the note ID.

• Action
  Delete Client

  Deletes a client.

• Action
  Delete Client Match

  Deletes a client match.

• Action
  Delete Client Note

  Deletes a client note.

• Action
  Delete Email Draft

  Deletes an email draft.

• Action
  Delete Task

  Deletes a task.

• Action
  Find a Client

  Returns clients, newest first, with paging.

• Action
  Get Client

  Returns a client's type, status, created date and assigned users.

• Action
  Get Client Note

  Returns one note on a client.

• Action
  Get Email Draft

  Returns an email draft.

• Action
  Get Task

  Returns a task with its board, status and folder.

• Action
  List Client Matches

  Returns a client's matches.

• Action
  List Client Notes

  Returns a client's notes.

• Action
  List Email Drafts

  Returns email drafts.

• Action
  List Tasks

  Returns tasks, optionally filtered by board, status or assignee.

• Action
  Update Client

  Updates a client's type, status flags or assigned users.

• Action
  Update Client Match

  Updates a client match's group, priorities, due dates or statuses.

• Action
  Update Client Note

  Updates a client note's content or date.

• Action
  Update Email Draft

  Updates an email draft's subject, message or campaign.

• Action
  Update Task

  Updates a task.

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