Connect Altoviz and MySQL

Both apps 34Altoviz 24MySQL 10

• Trigger
  Contact

  Triggers when a contact is created, updated or deleted.

• Trigger
  Customer

  Triggers when a customer is created, updated or deleted.

• Trigger
  Product

  Triggers when a product is created, updated or deleted.

• Action
  Create Contact

  Creates a new contact.

• Action
  Create Customer Family

  Creates a new customer family.

• Action
  Create Draft Sales Invoice

  Creates a new draft sales invoice.

• Action
  Create Product Family

  Creates a new product family.

• Action
  Create Receipt

  Creates a new receipt.

• Action
  Create Sales Credit

  Creates a new sales credit.

• Action
  Create Sales Quote

  Creates a new sales quote.

• Action
  Create Supplier

  Creates a new supplier.

• Action
  Delete Contact

  Delete an existing contact.

• Action
  Delete Customer

  Delete an existing customer.

• Action
  Delete Receipt

  Delete an existing receipt.

• Action
  Delete Sales Credit

  Delete an existing sales credit.

• Action
  Delete Sales Invoice

  Delete an existing draft sales invoice.

• Action
  Delete Sales Quote

  Delete an existing sales quote.

• Action
  Delete Supplier

  Delete an existing supplier.

• Action
  Download Purchase Invoice

  Download a purchase invoice.

• Action
  Get Settings

  Returns the Altoviz account's application settings (company, accounting, sales, VAT, e-invoicing, emailing, general and social settings).

• Action
  Update Customer

  Update an existing customer.

• Action
  Update Product

  Update an existing product.

• Action
  Update Receipt

  Update an existing receipt.

• Action
  Update Supplier

  Update an existing supplier.

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

• Trigger
  New Row

  Triggers when you add a new row.

• Trigger
  New Table

  Fires when a new table appears in the connected MySQL database.

• Action
  Add Row

  Adds a new row.

• Action
  Delete Row

  Delete the rows in a table whose chosen column equals a value.

• Action
  Find Row

  Finds a row in a table via a lookup column.

• Action
  Find Rows via Custom Query

  Run an author-written SELECT against the connected MySQL database and return every row it produced. Mirrors PostgreSQL 715ae2ac, SQL Server 8e0bbb5d and Oracle 2c308e4d; MySQL placeholder style is ?.

• Action
  Find Row via Custom Query

  Runs a SELECT statement you write against the connected MySQL database and returns the first row it matches.

• Action
  Update Row

  Updates an existing row.

No trigger or action matches that. Ask your agent to add it: it reads the API documentation and builds what you describe.