Connect MySQL to Xero Accounting

Execute a custom MySQL query. See our docs to learn more about working with SQL in Mazaal AI.

Adds a new row. See the docs here

Delete an existing row. See the docs here

Find row(s) via a custom query. See the docs here

Execute Stored Procedure. See the docs here

Finds a row in a table via a lookup column. See the docs here

Retrieves available options for the Stored Procedure field.

Retrieves available options for the Table field.

Execute a SQL Query. See our docs to learn more about working with SQL in Mazaal AI.

Updates an existing row. See the docs here

Adds line items to an existing sales invoice. See the docs here

Gets bank statements for the specified bank account.

Create a new bank transaction See the documentation

Creates a new bill (Accounts Payable)See the docs here

Creates a new credit note.

Creates a new employee.

Creates a new note adding it to a document.

Creates a new item.

Creates a new contact or updates a contact if a contact already exists. See the docs here

Creates a new contact or updates if the contact exists.

Creates a new payment

Creates a new purchase bill.

Creates a new sales invoice. See the documentation

Create a new tracking category See the documentation.

Delete a tracking category by ID See the documentation.

Delete a tracking category option by ID See the documentation.

Downloads an invoice as pdf file. File will be placed at the action's associated workflow temporary folder.

Triggers the email of a sales invoice out of Xero.

Finds a contact by name or account number. Optionally, create one if none are found. See the docs here

Finds an invoice by number or reference.See the docs here

Finds a contact by name or email address. Optionally, create one if none are found. See the docs here

Gets the balances and cash movements for each bank account.

Gets details of a contact.

Gets the history of changes to a single existing document.