Connect Saasu and SQL Server

Both apps 33Saasu 22SQL Server 11

• Trigger
  New Contact

  Triggers when a new contact is added to your Saasu file.

• Action
  Add activity

  Creates an activity (task, call, meeting, note) in your Saasu file, optionally attached to a contact or transaction.

• Action
  Add company

  Creates a company record in Saasu.

• Action
  Add item

  Creates an inventory or combo item in Saasu.

• Action
  Add journal

  Creates a manual journal entry with debit and credit lines in a Saasu file.

• Action
  Create Contact

  Creates a new contact (person) in your Saasu file and returns its id.

• Action
  Create Item Invoice

  Creates an item-layout invoice, quote or order in Saasu with inventory item line items.

• Action
  Create Service Invoice

  Creates a service-layout sale or purchase invoice in Saasu, with line items described by account and amount.

• Action
  Delete contact

  Deletes a contact from your Saasu file.

• Action
  Delete invoice

  Deletes a sale or purchase invoice from the Saasu file.

• Action
  Delete item

  Deletes an inventory item from the Saasu file.

• Action
  Email invoice

  Emails a Saasu invoice to the email address you specify.

• Action
  Find accounts

  Returns the accounts in your Saasu chart of accounts, filtered by type, status, bank-account flag or header account.

• Action
  Find companies

  Returns the companies in your Saasu file whose name matches, optionally limited to a last-modified date range.

• Action
  Find Contact

  Finds Saasu contacts matching an email, name, company or other criteria and returns the matching contacts.

• Action
  Find items

  Returns the inventory and combo items whose code or description matches the search text.

• Action
  Get contact

  Returns a single Saasu contact by its ID.

• Action
  Get invoice

  Returns a single Saasu invoice (sale or purchase) by its ID, including line items and totals.

• Action
  Get journal

  Returns a single journal transaction, including its date, reference, summary and journal line items.

• Action
  Update contact

  Updates an existing contact in Saasu, such as their name, email, phone numbers, addresses and customer/supplier flags.

• Action
  Update invoice

  Updates an existing Saasu sale or purchase invoice, replacing its details and line items.

• Action
  Update item

  Updates an existing inventory or combo item in Saasu, such as its code, description, prices, accounts and tax codes.

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