MySQL AppiWorks

Interact with MySQL directly from Zoho Books

What is MySQL AppiWorks?

MySQL AppiWorks for Zoho Books is a Zoho Books extension that integrates Zoho Books and MySQL database. It helps users to export data from Zoho Books to MySQL, import data from MySQL to Zoho Books and show contextual data from MySQL inside Zoho Books.

Why do you need?

If you are looking at integrating Zoho Books with MySQL and getting your processes automated, look no further. MySQL AppiWorks for Zoho Books covers you fully.

How does it work?

See the demo video on how to use MySQL AppiWorks for Zoho Books

Key Features

✅ Auto Interaction: Automatically insert a record into MySQL when a new Customer/ Estimate or any record in a Zoho Books module is created.

✅ On Demand Interaction: Insert records into MySQL on selected Customer/ Estimate or any records in a Zoho Books module.

✅ Bulk Import: Import data from MySQL tables/view into Zoho Books with a guided setup.

View Contextual data: Show related data from MySQL table/view inside Zoho Books module GUI

Configurable Services: A fully configurable automation that lets you take control of your integration and automation needs between Zoho Books and MySQL.

Sample Use Cases

► Insert new record into MySQL database table when a new lead is created on Zoho Books 

► Export 200 selected invoices from Zoho Books into MySQL database table

► Import Customers from MySQL database table into Zoho Books Customers.

► View related invoices or payments data from home grown system (that runs on MySQL)



How to create an Export service?


How to execute export service manually?

In manual execution, you can execute services for multiple records (Currently, supported only in invoices module of Zoho Books)

How to create an Import service?

How to create a View service?