Zoho Invoice

Zoho Invoice is a cloud invoicing and billing software for freelancers and small business owners developed by ZOHO Corporation.

Data Integration: Skyvia supports importing data to and from Zoho Invoice, exporting Zoho Invoice data to CSV files, replicating Zoho Invoice data to relational databases and synchronizing Zoho Invoice data with other cloud apps and relational databases.

Backup: Skyvia Backup supports Zoho Invoice.

Query: Skyvia Query supports Zoho Invoice.

Zoho Invoice-Specific Features and Limitations

Some of the Zoho Invoice tables store complex structured data. These are the following tables: Invoices, Estimates, Expenses, CreditNotes, RecurringInvoices, RecurringExpenses, RetainerInvoices. For example, an invoice or credit note can have several lines. Skyvia represents this information in such tables as a JSON field LineItems. Here is an example of the LineItems field value from the Invoice table:

[
  {
    "item_id": "1305024000000065053",
    "salesorder_item_id": "",
    "project_id": "",
    "time_entry_ids": [],
    "expense_id": "",
    "item_type": "sales",
    "expense_receipt_name": "",
    "name": "DGERH35435",
    "description": "sample description",
    "item_order": 0,
    "bcy_rate": 467,
    "rate": 467,
    "quantity": 7,
    "unit": "qty",
    "discount": 0,
    "tax_id": "1305024000000065051",
    "tax_name": "testtax",
    "tax_type": "tax",
    "tax_percentage": 2,
    "item_total": 3269,
    "documents": [],
    "item_custom_fields": []
  },
  {
    "item_id": "",
    "salesorder_item_id": "",
    "project_id": "1305024000000065096",
    "time_entry_ids": [],
    "expense_id": "",
    "item_type": "",
    "expense_receipt_name": "",
    "name": "TestProject",
    "description": "sample description 2",
    "item_order": 1,
    "bcy_rate": 123,
    "rate": 123,
    "quantity": 1,
    "unit": "",
    "discount": 0,
    "tax_id": "",
    "tax_name": "",
    "tax_type": "tax",
    "tax_percentage": 0,
    "item_total": 123,
    "documents": [],
    "item_custom_fields": []
  }
]

For user convenience, lines of these objects are also available as separate records via read-only tables with names containing LineItems suffix, like InvoiceLineItems, BillLineItems, etc. They allow you to view these lines in a tabular form with Query, export them to CSV with Export, import them from Zoho Invoice to another cloud application or database, where these lines should be stored in a separate table, etc.

Since these tables (that have the LineItems suffix in their name) are read-only, they are not available in Import packages as a target or in Synchronization packages. To modify lines of an invoice, expense, etc., you need to provide values in JSON format for the LineItems field of the corresponding main table - Invoices, Expenses, etc. For example, to import invoices from a CSV files to Zoho Invoice, you need to specify invoice lines in the JSON format, like in the example above, in one of the CSV file columns, and import this file to the Invoice table. You need to map the LineItems field of the Invoices table to this column of the CSV file.

The tables with the LineItems suffix in their name are available in backup packages, but you cannot restore data to these tables, because they are read-only. Since they store the same information as the LineItems field of the corresponding main tables, you don’t actually need to backup them. All the information in *LineItems tables is present in the corresponding main tables, and you can back up and restore data in the main table only.

Skyvia has the following limitations for Zoho Invoice:

  • The TaxGroups object is not supported in Skyvia.
  • Not all objects support all the DML operations for data import. CreditedInvoices, CreditNoteComments, Employees, ProjectComments objects support only INSERT and DELETE operations, and do not support the UPDATE operation.

By default, Zoho Invoice has a limit of 1000 API calls for a day and 60 calls for a minute. Performing backup, replication, or querying all the data from various objects may quickly use all the API calls available. For example, querying LineItems field values uses additional requests.

Zoho Invoice Connections

When creating a Zoho Invoice connection, simply log in with Zoho Invoice. The OAuth authentication token is stored on the Skyvia server. Your Zoho Invoice account login and password are not stored on the Skyvia server.

To create a Zoho Invoice connection, perform the following steps:

  1. Click +NEW in the top menu.
  2. Open the Select Connector page by clicking Connection in the menu on the left.
  3. In the opened pane, click Zoho Invoice.
  4. In the Connection Editor page, specify a connection name that will be used to identify the connection.
  5. In the Data Center list, select your Zoho Invoice data center location to connect to: US, Europe, India, China or Australia.

    Connection Editor window

  6. If you have multiple organizations in your Zoho Invoice account, enter the numeric id of the organization to connect to in the Organization Id box. See how to find it here.
  7. Optionally, you can select the Suppress Extended Requests checkbox to reduce the number of API calls. However, beforehand read more about this option below.
  8. Click Sign In with Zoho.
  9. In the opened window, enter your Zoho Invoice email and click the Next button.

    Zoho Sign In window

  10. Enter your Zoho Invoice password and click the Sign In button.

Zoho Sign In window

  1. Click Accept.
  2. The refresh token is generated.

    Connection Editor window 2

  3. Click the Create Connection button to create the connection.

Suppressing Extended Requests

For some objects, Zoho Invoice API returns only part of the fields when querying multiple records. In order to query values of additional fields, Skyvia performs additional extended requests. Such API requests can be performed for each record of such object. However, this can decrease performance and significantly increase the number of API calls used.

To reduce the number of API calls, you can select the Suppress Extended Requests checkbox. However, please note that some of the fields in such objects will not be available in Skyvia (will return empty values) even if they have values in Zoho Invoice because Zoho Invoice API does not return them without extended requests.

Supported Actions and Actions Specifics

Zoho Invoice connector supports the following actions: