Zoho Creator Integration

Zoho Creator data can be integrated and synchronized codeless with various external systems, on premises or in the cloud, using the Layer2 Cloud Connector.

Learn on this page how the data integration of Zoho Creator & SharePoint (as an example) is working with the Layer2 Cloud Connector by using the step-by-step screenshot tutorial and reading our important advice and frequently asked questions. Make use of the benefits and features of this data integration tool by trying it out yourself: Free Trial Registration

Zoho Creator step-by-step data integration via the Layer2 Cloud Connector

Use this step-by-step-introduction to get through the whole product and data integration configuration easily. Some steps require a copy-paste task of code snippets. Please follow the recommendations in this introduction closely.

Before you can proceed with the configuration, please be aware that

• You need to create the source connection to your Zoho Creator account. To do this, you will need an authentication token. You have two methods for this:If you are not logged in your ZOHO Creator account, go to the browser and type changing the bold parameters accordantly: https://accounts.zoho.com/apiauthtoken/nb/create?SCOPE=ZohoCreator/creatorapi&EMAIL_ID=Zoho CREATOR Username or Email ID&PASSWORD=Zoho CREATOR Password
  
  Or, if your are logged in, your ZOHO Creator account, go to the browser and paste the following URL in the field: https://accounts.zoho.com/apiauthtoken/create?SCOPE=ZohoCreator/creatorapi

Specific Connection String for your Zoho Creator integration

Please copy and paste the connection string and the "Select Statement" into the designated field like described in Step 2.5 of the step-by-introduction above.

URL=http://creator.zoho.com/api/xml/<your_app_name>/view/<your_view/?authtoken=<your_authentication_token>&scope=creatorapi&zc_ownername=<your_app_owner_name>&raw=true"

Please enter the following SQL query into the "Select Statement" as well and adjust the placeholder.

SELECT @id as “ID”, column[@name=”First_Name”] as “First Name”, column[@name=”Last_Name”] as “Last Name”, column[@name=”Email_ID”] as “Email”, column [@name=”Employee_ID”] as “Employee ID”, column [@name=”Date_of_joining”] as “Date of joining” FROM /response/records/record

Primary Key: ID

Benefits of using the Layer2 Cloud Connector for your Zoho Creator data integration

Find YOUR Destination pages here

Take your next steps