Connect Vouchsafe to SQL Server

Both apps 21Vouchsafe 10SQL Server 11

• Trigger
  User Needs Review

  Triggers when a user could not be automatically verified, and needs your review.

• Trigger
  User Verified

  Triggers when a verification is automatically completed.

• Action
  Find addresses by postcode

  Search for addresses matching a given postcode. GET /api/v1/postcode-search (SearchPostcode).

• Action
  Get account detail

  Retrieve details for a specific monitored account (subject of an alert). GET /api/v1/accounts/{id} (GetAccountDetail).

• Action
  Get team

  Retrieve details for a Vouchsafe team/workspace by ID. GET /api/v1/teams/{id} (GetTeam).

• Action
  Get verification

  Retrieve a verification case's status and check results by ID. GET /api/v1/verifications/{id}.

• Action
  List verifications

  List verification cases for the team. GET /api/v1/verifications.

• Action
  Perform smart lookup

  Look up and enrich identity details (e.g. email/phone) via Vouchsafe's smart lookup service. POST /api/v1/smart-lookups (PerformSmartLookup).

• Action
  Request Verification

  Starts a verification session for an applicant, new user or customer.

• Action
  Toggle alerts

  Enable or disable proactive alert monitoring for an account. POST /api/v1/accounts/{id}/toggle-alerts (ToggleAlerts).

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