Connect Previsto and SQL Server

Both apps 29Previsto 18SQL Server 11

• Trigger
  Completed Assignment

  Triggers when an assignment is marked as completed in Previsto.

• Trigger
  Created Agreement

  Triggers when a new service agreement is created in Previsto.

• Trigger
  Created Assignment

  Triggers when a new assignment is created in Previsto.

• Trigger
  Created Contact

  Triggers when a new contact is created in your Previsto account, and hands on that contact's details.

• Trigger
  Updated Contact

  Triggers when a contact is created or changed in your Previsto account, and hands on that contact's details.

• Action
  Create Agreement

  Creates a service agreement in Previsto for one of your contacts, setting the work description, expected duration, price and how often it repeats.

• Action
  Create Assignment

  Creates an assignment in Previsto for a customer and returns the created assignment.

• Action
  Create Contact

  Creates a contact in Previsto with the name, address and billing details you supply, and returns the new contact including its id.

• Action
  Delete agreement

  Deletes a service agreement from Previsto.

• Action
  Delete assignment

  Deletes an assignment from Previsto.

• Action
  Delete contact

  Deletes a contact from Previsto.

• Action
  Get account

  Returns a single Previsto account, including its contact details, roles and location.

• Action
  Get agreement

  Retrieves a single service agreement from Previsto, with its description, amount, schedule and linked contact.

• Action
  Get assignment

  Returns one assignment from Previsto, including its contact, status, planned time, address and the tasks it covers.

• Action
  Get contact

  Returns a single Previsto contact, including its address, billing settings and notification preferences.

• Action
  List contacts

  Returns the contacts in your Previsto account, optionally narrowed to a name, email address, reference number or archived state.

• Action
  Update agreement

  Updates a service agreement in Previsto and returns the updated agreement.

• Action
  Update contact

  Updates an existing Previsto contact — its name, address, contact details, billing settings and your own extra information.

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