Connect Sprig and SQL Server

Both apps 30Sprig 19SQL Server 11

• Trigger
  New Study

  Triggers when a new study (survey) is created in Sprig.

• Trigger
  New Survey Response

  Triggers when a new answer to a Sprig survey question is submitted.

• Action
  Create Invitations

  Creates a batch of single-use invitation links for a Sprig survey.

• Action
  Create Survey

  Creates a draft shareable Sprig survey. Questions are added separately.

• Action
  Delete Draft Study

  Deletes a draft Sprig study. Only draft studies can be deleted.

• Action
  Delete Question

  Deletes a question from a Sprig study. Needs the study's current version.

• Action
  Get Question

  Returns one question of a Sprig study, with its options.

• Action
  Get Study

  Returns one Sprig study by its ID, including its current version.

• Action
  Get User

  Returns a Sprig user by user ID, with attributes and tracked events.

• Action
  List Attributes

  Returns the user attributes defined in the Sprig environment.

• Action
  List Events

  Returns the tracked events defined in the Sprig environment.

• Action
  List Invitations

  Returns invitation links of a Sprig survey, filtered by status.

• Action
  List Questions

  Returns the questions of a Sprig study.

• Action
  List Studies

  Returns a page of Sprig studies (surveys), optionally filtered by status or type.

• Action
  List Survey Responses

  Returns exported Sprig survey responses, optionally for one survey.

• Action
  Purge Visitors

  Requests deletion of Sprig users and all their data, by email or user ID (up to 100).

• Action
  Update Study Name

  Renames a Sprig study. Needs the study's current version from Get Study.

• Action
  Upsert User

  Creates or updates a Sprig user by user ID, setting email and attributes.

• Action
  Validate Study

  Checks a Sprig study and returns any issues that would block it from launching.

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