Zoho Creator is a low-code application development platform that allows users to create custom business applications without extensive programming knowledge. It is an online application builder featuring an intuitive drag-and-drop interface that allows you to create custom applications effortlessly. This cloud-based database solution empowers organizations to design tailored applications, automate workflows, and securely store application data. Zoho creator can be integrated with multiple third-party software such as Zoho Apps, Google Apps, QuickBooks, Paypal and Salesforce.

This article provides an overview to get started with the ZOHO Creator connector in Peliqan. Please contact support if you have any additional questions or remarks.

Content

• Content
• Zoho Creator Data Pipeline
• Connect Zoho Creator
• Zoho Creator data sync to Data Warehouse
• Custom Report list data sync
• Zoho Creator Data Activation
• Data API Endpoints
• Get all form Fields
• Get Records by Id
• Add Records in Zoho Creator
• Update Records in Zoho Creator
• Need further help

Zoho Creator Data Pipeline

Connect Zoho Creator

Connect Zoho Creator through the Peliqan Connectivity Module:

Configuration Options:

1. Account Owner Name : Owner name present in the URL after Domain.
2. Application Link Name : App name present at the end of App instance URL.

3. Domain : Country domain where the account instance has been created.
4. (Optional) Report Name : Comma-separated list if report name to data fetch for.
5. (Optional) table selection via ‘Advanced’

Once filled, Start the oAuth connection flow by selecting “Connect Zoho Creator” :

• Provide your username and password.
• Authorize Peliqan to access your data.

Zoho Creator data sync to Data Warehouse

Peliqan offers an out of the box data warehouse. Optionally the user can choose to sync Zoho Creator data to their own data warehouse such as Snowflake, Google BigQuery, MS SQL etc.

Data will be synced to the chosen data warehouse and made available through the Peliqan UI for exploration.

With the Peliqan federated query engine, queries on the Zoho Creator data can be written and data can be transformed and combined with other sources.

Custom Report list data sync

Peliqan allows users to provide comma separated list of reports to access data for.

Zoho Creator Data Activation

Data API Endpoints

Get all form Fields

• With “Get Form Fields” function under Zoho Creator, one can fetch fields related to form available in Zoho Creator. Form_link_name has to be provided.
• This function is useful for viewing all available fields when creating records in a Zoho Creator Form.

Get Records by Id

• With “Get Record” method provides details of record by id under any report. report_link_name and record_id has to be provided.
• This function is useful for viewing available record data when updating records in a Zoho Creator report.

Add Records in Zoho Creator

• “Add records” function allows to create records in Zoho Creator Instance.
• Simple process is to fetch all fields and create a object payload to be created.

Update Records in Zoho Creator

• “Update Records” function allows to update records in Zoho Creator Instance.

Need further help

Please contact our support for any further assistance via support@peliqan.io.