Connect PostgreSQL to Xero Accounting

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

Deletes a row or rows from a table. See the documentation

Finds a row in a table via a lookup column. See the documentation

Finds a row in a table via a custom query. See the documentation

Adds a new row. See the documentation

Retrieves available options for the Schema field.

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

Updates an existing row. See the documentation

Adds a new row or updates an existing row. See the documentation

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.