Quick and easy installation in just minutes. Combine your data automatically in the background and benefit of better insights and greater revenues.
Zoho Creator Integration
Zoho Creator data can be integrated and synchronized codeless with various external systems,
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
HOW IT WORKS
In fact, you only need to do the 5 following steps to get your Zoho Creator data integration started.
- Setup your connection as required: one-way (in this case)
- Setup your data source, in this case Zoho Creator database.
- Setup your target– for example a Microsoft SharePoint list or library.
- Setup your mapping.
- Start your project!
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
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