FAPI, Microsoft SQL Server, AWeber, MySQL, Zoho Books, Xero Integrations

AWeber
FAPI
Microsoft SQL Server
MySQL
Zoho Books
Xero
Try Integromat for FREE
No credit card. You'll love it.

What is Integromat?

GmailWatch emailsGoogle SheetsAdd a rowGmailIterate attachmentsRouterFacebookCreate a postArchiveCreate an archiveDropboxUpload a fileDocuments onlyImages onlyWhen new email arrivesAdd a row to a sheetProcess attachmentsone by one ...Post images to pageZip all documentsUpload archive

Integromat will automate processes that you currently handle manually. It is not only capable of connecting apps but can also transfer and transform data. It works 24 hours a day, seven days a week and does not require your intervention. Simply set Integromat to do what you want and let it work for you. Save your time!

Triggers

FAPI

Sledovat notifikace INSTANT

Spustí se, když je ve FAPI spuštěna akce (např. vytvořena nová objednávka).

AWeber

Watch accounts

Triggers when a new account is added.

AWeber

Watch custom fields

Triggers when a new custom field is added to the list.

AWeber

Watch lists

Triggers when a new list is added.

AWeber

Watch subscribers

Triggers when a new subscriber is added to the list.

Xero

Watch receipts

Triggers when a new receipt is added or an existing receipt is updated.

Xero

Watch invoices

Triggers when a new invoice is added or an existing invoice is updated.

Xero

Watch credit notes

Triggers when a new credit note is added or an existing credit note is updated.

Xero

Watch bank transactions

Triggers when a new transaction is added or an existing transaction is updated.

Xero

Watch bank transfers

Triggers when a new bank transfer is created.

Xero

Watch employees

Triggers when a new employee is added or an existing employee is updated.

Xero

Watch purchase orders

Triggers when a new order is added or an existing order is updated.

Xero

Watch contacts

Triggers when a contact is created or updated.

Xero

Watch payments

Triggers when a payment is created or updated.

Actions

FAPI

Aktualizovat prodejní položku

Aktualizuje údaje o prodejní položce.

FAPI

Získat data faktury

Načte údaje z faktury, např. jméno klienta, název prodejní položky, cenu apod.

Microsoft SQL Server

Delete row(s) from a table

Microsoft SQL Server

Execute a query (advanced)

Microsoft SQL Server

Execute stored procedure

Microsoft SQL Server

Insert row into a table

Microsoft SQL Server

Update row(s) in a table

AWeber

Add a subscriber

Creates a new subscriber.

AWeber

Delete a custom field

Deletes a custom field.

AWeber

Delete a subscriber

Deletes a subscriber.

AWeber

Get a custom field

Gets info about a custom field.

AWeber

Get a list

Gets info about a specified list.

AWeber

Get a subscriber

Gets info about a subscriber.

AWeber

Get tags for list

Gets the most popular tags for a list. This will return an array containing up to 500 tags sorted by descending popularity.

AWeber

Move a subscriber

Moves a subscriber to a different list.

AWeber

Update a custom field

Updates a custom field.

AWeber

Update a subscriber

Updates a subscriber.

MySQL

Delete row(s) from a table

MySQL

Execute a query (advanced)

MySQL

Execute a stored procedure

MySQL

Insert row into a table

MySQL

Update row(s) in a table

Zoho Books

Create a Bill

Create a bill received from your vendor.

Zoho Books

Create a Contact

Create a contact with given information.

Zoho Books

Create a Contact Person

Create a contact person for a contact.

Zoho Books

Create an Employee

Create an employee for an expense.

Zoho Books

Create an Expense

Create a billable or non-billable expense.

Zoho Books

Create an Invoice

Create an invoice for your customer.

Zoho Books

Create a Payment

Create a new payment.

Zoho Books

Delete a Bill

Delete an existing bill. Bills which have payments applied cannot be deleted.

Zoho Books

Delete a Contact

Delete an existing contact.

Zoho Books

Delete a Contact Person

Delete an existing contact person.

Zoho Books

Delete an Employee

Delete an existing employee.

Zoho Books

Delete an Expense

Delete an existing expense.

Zoho Books

Delete an Invoice

Delete an existing invoice. Invoices which have payment or credits note applied cannot be deleted.

Zoho Books

Delete an Invoice Payment

Delete a payment made to an invoice.

Zoho Books

Delete a Payment

Delete an existing payment.

Zoho Books

Download an Invoice

Download the PDF file of an invoice.

Zoho Books

Email an Invoice

Email an invoice to the customer.

Zoho Books

Get a Bill

Get the details of a bill.

Zoho Books

Get a Contact

Get the details of a contact.

Zoho Books

Get a Contact Person

Get the details of a contact person.

Zoho Books

Get an Employee

Get the details of an employee.

Zoho Books

Get an Expense

Get the details of the Expense.

Zoho Books

Get an invoice

Get the details of an invoice.

Zoho Books

Get a Payment

Get the details of an existing payment.

Zoho Books

Make an API Call

Performs an arbitrary authorized API call.

Zoho Books

Mark an Invoice as Draft

Mark a voided invoice as draft.

Zoho Books

Remind Customer about an Unpaid Invoice

Remind your customer about an unpaid invoice by email. Reminder will be sent, only for the invoices which are in open or overdue status.

Zoho Books

Update a Bill

Update a bill. To delete a line item just remove it from the line_items list.

Zoho Books

Update a Contact

Update an existing contact. To delete a contact person remove it from the contact_persons list.

Zoho Books

Update a Contact Person

Update an existing contact person.

Zoho Books

Update an Expense

Update an existing Expense.

Zoho Books

Update an Invoice

Update an existing invoice.

Zoho Books

Update a Payment

Update an existing payment.

Zoho Books

Void an Invoice

Mark an invoice status as void. Upon voiding, the payments and credits associated with the invoices will be unassociated and will be under customer credits.

Xero

Create a receipt

Creates a new receipt.

Xero

Get a receipt

Returns information about a receipt with a given ID.

Xero

Create an invoice

Creates a new invoice.

Xero

Get an invoice

Returns information about an invoice with a given ID.

Xero

Create a credit note

Creates a new credit note.

Xero

Get a credit note

Returns information about a credit note with a specified ID.

Xero

Create a bank transaction

Creates a new bank transaction.

Xero

Get a bank transaction

Returns information about a transaction with a specified ID.

Xero

Create a bank transfer

Transfers a specified amount from one account to another.

Xero

Create an employee

Creates a new employee.

Xero

Create a purchase order

Creates a new purchase order.

Xero

Get a purchase order

Returns information about a purchase order with a specified ID.

Xero

Create a contact

Creates a new contact.

Xero

Update a contact

Updates a contact by ID.

Xero

Archive a contact

Archives a contact with a given ID.

Xero

Create a contact group

Creates a new contact group.

Xero

Add a contact to a contact group

Adds a contact to a specified contact group.

Xero

Remove a contact from a contact group

Removes a contact from a contact group.

Xero

Delete a contact group

Deletes a contact group with a specified ID.

Xero

Create a history note

Adds a note to a record.

Xero

Create an item

Creates a new item.

Xero

Get a contact

Retrieves contact information by ID.

Xero

Get an account

Returns information about an acccount with a specified ID.

Xero

Get an invoice URL

Retrieves Xero online invoice URL.

Xero

Get an item

Searches for an item by item ID or item code.

Xero

Get a payment

Retrieves information about a payment with a specified ID.

Xero

Get bank statements report

Returns bank statements for a selected bank account.

Xero

Get bank summary

Returns the balances and cash movements for each bank account.

Xero

Get history of changes

Retrieves the changes made to a given object.

Xero

Search for a contact

Searches for a contact by name or email.

Xero

Search for an account

Finds an account by ID, name, or code.

Xero

Search for an invoice

Searches for an invoice

Xero

Search for a tax rate

Finds a tax rate by name.

Xero

Send an invoice via email

The email will be sent to the primary email address of the contact on the invoice. The invoice must be of Type ACCREC and a valid Status for sending (SUMBITTED,AUTHORISED or PAID).

Xero

Update an employee

Updates an employee by ID.

Xero

Update an invoice

Updates an invoice with a given ID.

Xero

Update an item

Updates an item by ID.

Xero

Update a payment

Use this method to apply payments to approved AR and AP invoices or refund AR or AP credit notes.

Xero

Upload a file

Uploads a file to an invoice, receipt, contact or another item.

Iterators

Microsoft SQL Server

Iterate recordset

Iterates through received recordset.

MySQL

Iterate recordset of a stored procedure

Iterates through recordset received from a stored procedure.

Searches

Microsoft SQL Server

Select row(s) from a table

AWeber

Find a list

Finds a list by its name or unique list ID.

AWeber

Find subscribers for account

Finds the collection of subscribers that match a search criteria for the specified account across all lists.

AWeber

Find subscribers for list

Finds the collection of subscribers that match a search criteria for the specified account and list.

AWeber

Get accounts

Lists all available accounts.

AWeber

Get custom fields

Lists all available custom fields for a specified list.

AWeber

Get lists

Lists all available lists for a specified account.

AWeber

Get subscriber activity

Retrieves the analytics activity for a subscriber.

AWeber

Get subscribers

Lists all available subscribers.

MySQL

Select row(s) from a table

Zoho Books

List Bills

List all bills.

Zoho Books

List Contact Persons

List all contact persons.

Zoho Books

List Contacts

List all contacts.

Zoho Books

List Customer Payments

List all the payments made by your customer.

Zoho Books

List Employees

List employees with pagination.

Zoho Books

List Expenses

List all the Expenses.

Zoho Books

List Invoice Payments

Get the list of payments made for an invoice.

Zoho Books

List Invoices

List all invoices.

Zoho Books

List Items

Get the list of all active items.