Connect Kit and SQL Server

Both apps 25Kit 14SQL Server 11

• Trigger
  New Form Subscriber

  Triggers when a subscription occurs on a specific form.

• Trigger
  New Purchase

  Triggers when a new purchase is added to your account.

• Trigger
  New Sequence Subscriber

  Triggers when a subscriber is added to a sequence.

• Trigger
  New Subscriber

  Triggers when a new subscriber is confirmed within your account (has completed any applicable double opt-ins).

• Trigger
  New Unsubscribe

  Triggers when a subscriber unsubscribes from your emails.

• Trigger
  Subscriber Added to Tag

  Triggers when a specific tag is added to a subscriber.

• Trigger
  Tag Removed From Subscriber

  Triggers when a specific tag is removed from a subscriber.

• Action
  Add Subscriber to Form

  Subscribe someone to a specific form.

• Action
  Add Tag to Subscriber

  Add a subscriber to a specific tag.

• Action
  Create or Update Subscriber

  Creates a Kit subscriber, or updates the first name and custom fields of an existing subscriber with the same email address. Returns the subscriber.

• Action
  Find Subscriber

  Finds an existing confirmed subscriber by email.

• Action
  Get Subscriber

  Returns one Kit subscriber by ID, with their name, email address, state and custom field values.

• Action
  List Tags for Subscriber

  Lists the tags on a Kit subscriber, with each tag's ID, name and the date it was applied.

• Action
  Remove Tag From Subscriber

  Remove a specific tag from a subscriber if they have it.

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