Connect PartnerStack and SQL Server

Both apps 29PartnerStack 18SQL Server 11

• Trigger
  New Application Event

  Triggers when a partner application is submitted or changes (for example, approved or declined).

• Trigger
  New Customer Event

  Triggers when a customer is created or updated in your PartnerStack program.

• Trigger
  New Deal Event

  Triggers when a deal is created or updated (for example, its stage, amount or close date changes).

• Trigger
  New Lead Event

  Triggers when a lead is created or updated (for example, approved, declined or closed).

• Trigger
  New Partnership Event

  Triggers when a partnership is created or updated in your PartnerStack program.

• Trigger
  New Reward Event

  Triggers when a reward is created or changes (for example, declined, restored or updated).

• Trigger
  New Transaction Event

  Triggers when a transaction is recorded or changes.

• Action
  Create Action

  Records an action a partner or customer performed (for example, posted in a forum), creating any reward tied to that action.

• Action
  Create Deal

  Creates a new deal attributed to the partner who registered it.

• Action
  Create Lead

  Creates a new lead attributed to the partner who referred it.

• Action
  Create Partner

  Creates a new partner (partnership) in your PartnerStack program and optionally emails them an invitation.

• Action
  Create Transaction

  Records a customer payment transaction so the referring partner is rewarded.

• Action
  Find Customer

  Looks up a customer by their customer key (or email) and returns their details.

• Action
  Find Lead

  Looks up a lead by its lead key and returns its details.

• Action
  Find Partner

  Finds a partner by their email address and returns the matching partnership.

• Action
  Update Customer

  Updates an existing customer's details, such as their name, email, or payment provider key.

• Action
  Update Deal

  Updates an existing deal, such as its stage, amount, or close date.

• Action
  Update Lead

  Updates an existing lead, such as its status, approval, or amount.

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