Connect MYSQL and Reckon One to Build Intelligent Automations

Choose a Trigger

MYSQL

When this happens...

Choose an Action

Reckon One

Automatically do this!

Ready to use MYSQL and Reckon One automations

Actions and Triggers

When this happensTriggers

A trigger is an event that starts a workflow.

New Invoice

New Invoice

Triggered when a new invoice is created in Reckon One.

New Payment

New Payment

Triggered when a new payment is recorded in Reckon.

New Receipt

New Receipt

Triggered when a new receipt created in Reckon One.

New Customer Adjustment Note

New Customer Adjustment Note

Triggers when a new customer adjustment note is created.

New Contact

New Contact

Triggers when new contact is created.

New Item

New Item

Triggers when new item is created in Reckon One.

Request a new Trigger for MYSQL

Do thisActions

Action is the task that follows automatically within your MYSQL integrations.

Find row(s) from a table

Find row(s) from a table

Find row(s) via a lookup column.

Execute a Query (advanced)

Execute a Query (advanced)

You can select, create, update or delete row(s) of table via custom SQL query.

Insert Row

Insert Row

Adds a new row into the table.

Update row(s) in a table

Update row(s) in a table

Update any existing row in the given table.

Delete row

Delete row

Deletes row from a table.

Update Item

Update Item

Updates an existing item.

Need help building your workflow?

Get instant answers from our AI assistant or connect with a support specialist anytime.

Frequently Asked Questions

How do I start an integration between MYSQL and Reckon One ?

To start, connect both your MYSQL and Reckon One accounts to viaSocket. Once connected, you can set up a workflow where an event in MYSQL triggers actions in Reckon One (or vice versa).

Can we customize how data from MYSQL is recorded in Reckon One ?

Absolutely. You can customize how MYSQL data is recorded in Reckon One . This includes choosing which data fields go into which fields of Reckon One , setting up custom formats, and filtering out unwanted information.

How often does the data sync between MYSQL and Reckon One ?

The data sync between MYSQL and Reckon One typically happens in real-time through instant triggers. And a maximum of 15 minutes in case of a scheduled trigger.

Can I filter or transform data before sending it from MYSQL to Reckon One ?

Yes, viaSocket allows you to add custom logic or use built-in filters to modify data according to your needs.

Is it possible to add conditions to the integration between MYSQL and Reckon One ?

Yes, you can set conditional logic to control the flow of data between MYSQL and Reckon One . For instance, you can specify that data should only be sent if certain conditions are met, or you can create if/else statements to manage different outcomes.

MYSQL

About MYSQL

MySQL is an open-source relational database management system (RDBMS) that uses Structured Query Language (SQL) for managing and querying data. It is widely used for its speed, reliability, and flexibility in handling large-scale database applications. MySQL is commonly employed in web development and is a key component of the popular LAMP stack (Linux, Apache, MySQL, PHP/Perl/Python).

Learn More
Reckon One

About Reckon One

Reckon One is a comprehensive accounting and bookkeeping software designed to streamline financial management for businesses of all sizes. It offers a range of features including invoicing, expense tracking, payroll management, and financial reporting to help businesses maintain accurate and up-to-date financial records.

Learn More