Connect Speak4 and SQL Server

Both apps 35Speak4 24SQL Server 11

• Trigger
  Pull Campaigns

  Triggers when a new campaign is created in Speak4.

• Trigger
  Pull Landing Pages

  Triggers when a new landing page is created in Speak4.

• Action
  Archive Campaign

  Archives or unarchives a Speak4 campaign.

• Action
  Archive Landing Page

  Archives or unarchives a Speak4 landing page.

• Action
  Create Campaign

  Creates a Speak4 advocacy campaign.

• Action
  Create Landing Page

  Creates a landing page (advocate form) on a Speak4 campaign.

• Action
  Create Recipient

  Creates a custom email recipient for Speak4 campaigns.

• Action
  Create Recipient Group

  Creates a named group of Speak4 recipients.

• Action
  Duplicate Campaign

  Creates a copy of a Speak4 campaign.

• Action
  Duplicate Landing Page

  Creates a copy of a Speak4 landing page.

• Action
  Get Campaign

  Returns one Speak4 campaign by ID.

• Action
  Get Landing Page

  Returns one Speak4 landing page by ID.

• Action
  Get Landing Page Requirements

  Returns the advocate fields a landing page requires.

• Action
  Get Stats

  Returns cumulative advocacy stats, optionally for one campaign or landing page.

• Action
  List Campaigns

  Returns a page of your Speak4 campaigns.

• Action
  List Landing Pages

  Returns a page of your Speak4 landing pages, optionally for one campaign.

• Action
  List Recipient Groups

  Returns your Speak4 recipient groups.

• Action
  List Topics

  Returns the Speak4 topics used to categorize federal campaigns.

• Action
  Lookup Regulation

  Looks up a Regulations.gov document by its ID.

• Action
  Pin Campaign

  Pins or unpins a Speak4 campaign.

• Action
  Search Recipients

  Searches Speak4 recipients (lawmakers and custom recipients) by name.

• Action
  Submit Advocate Action

  Submits an advocate action on a landing page; the message is queued to its recipients.

• Action
  Update Campaign

  Updates a Speak4 campaign.

• Action
  Update Landing Page

  Updates a Speak4 landing page title.

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