Zoho Creator

Zoho Creator is a low-code application development platform that allows users to create custom applications on their own, with minimal coding experience.

Data integration: Skyvia supports importing data to and from Zoho Creator, exporting Zoho Creator data to CSV files, replicating Zoho Creator data to relational databases.

Backup: Skyvia Backup does not support Zoho Creator.

Query: Skyvia Query supports Zoho Creator.

Establishing Connection

Creating Connection

To create a connection to Zoho Creator, do the following:

  1. Select a data center location from the Data Center dropdown.

    Connection Editor window

  2. Click Sign In with Zoho and fill out your Zoho login credentials.

  3. Choose the Application.

Additional Connection Parameters

Use Form Name As Table Prefix

When enabled, the report objects name is generated using the following rule: form name + separator + report name

If the form name is already part of the report name, the report object name is used as is.

Suppress Extended Requests

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

Metadata Cache

The period of time after which the Metadata Cache is considered expired.

Connector Specifics

Object Peculiarities

All the Zoho Creator objects are custom.

Forms and Reports

In Zoho Creator, a Form is the base object that defines the complete set of fields. A Report is a view or layout of the form data, where individual fields can be shown or hidden.

In Skyvia, objects represent reports. Object fields are retrieved from the underlying form, not from the report itself.

Example:

  • Form 1 has two fields: Field1 and Field2.
  • Report 1 includes both Field1 and Field2.
  • Report 2 includes only Field1 (Field2 is hidden in report settings).

In Skyvia, both Report 1 and Report 2 will show Field1 and Field2. When querying data from Report 2, Field2 will always return null.

DML Operations

DML Operations are performed on the form level. Each operation will impact all reports using this form.

Incremental Replication and Synchronization

Incremental Replication and Synchronization are not supported for Zoho Creator.

Supported Actions

Skyvia supports all the common actions for Zoho Creator.

On This Page