Data types are not imported from Subforms
I have a subform in Zoho CRM Contacts. With Date type, Currency Type, and Text type. When i import to DataPrep, the Dataset shows all fields has TEXT. The same problem when trying to export data from DataPrep to that subform in Zoho Contacts. The system
Data Prep not loading
Problem is simple, it just fails to load. Peace Robin
URL import and APIs with pages/offset/limits
While the URL import allows to include parameters, how can we iterate through the page numbers or offset/limit until all data is imported?
dataprep connection with databridge
Hi i have tried con connet using you r data bridge before an database on analitycs and today im'trineg to confirgure anoter conenction trouht datbridge application . bu unfortunately i cant connect to anyting. i don't revice any errors or any infiormationa
Currency data type invalidates any value above 999.99
I imported sales data from Amazon via an XLSX file. The data type in Excel was "Currency". Data prep is showing any value of $1000 or over as invalid. I tried deleting the $ and any commas, removed whitespaces and still any value above that amount comes
Export / Import Issue - ZOHO_DDL_OPERATIONS is more than required length
Alert Message Data preparation failed. Reason: The length of the parameter ZOHO_DDL_OPERATIONS is more than required length Am I trying to transform to much data?
Zoho DataPrep doesn't import external data with DataBridge
In a new project we want to import data to CRM through DataPrep. for 25 days the system has worked. After some changes we have not been able to successfully import the data again. When we launch the import activity, no complaint from DataPrep (previously
help dataprep
Hello, I've started working with the "dataprep" tool from Zoho. The objective is to automate the import of customer data from our Sage ERP to Zoho CRM. The first step involves synchronizing the "ACCOUNT" data, followed by the "contact" data, and finally,
Cannot change datatype from Dataprep into Zoho Analytics
When importing data directly from DataPrep into Zoho Analytics, I am unable to change the datatype for a column to visualise as a geo-location. Zoho Analytics says it cant change the table as its a system table, while Dataprep only has a "map" datatype
How to Maintain Column Order When Exporting DataSets from DataPrep
I have a daily scheduled export of a Dataset that absolutely must maintain a consistent column order. However, I'm finding that the exported column order changes from time to time which breaks the pipeline upstream. Is there some method of ensuring that
Export to Snowflake Failing
I'm attempting to export data to snowflake, but it continues to fail and producing the following error message: Table creation in the cloud database has failed. Error details: net.snowflake.client.jdbc.SnowflakeSQLException: Cannot perform CREATE TABLE.
Dataprep Webhook Limits and Cannot update column with Dataprep
I have two problems : 1 - I am using Airflow to trigger my pipeline, and when I tested it, it worked fine a couple of times. However, after that, I received an error: {"code":429,"message":"Request rate limited"}. I didn’t send too many requests — maybe
Databridge issue
Hi I have installed Databridge into my PC and I have connected a MySQL that I use in Zoho Analytics. When I try to access the same connection through Zoho DataPrep the databridge is not available and the module requests me to download and install again
Can you edit individual fields data manually in dataprep?
I just need to affect a manual change in a number of fields. Can I do this in dataprep, ie is there a transformation that can do this or it is fixed only to the formulas available to the column? Peace A Human
Zoho DataPrep: Data Type Does Not Match Column in the Target - Dates
We are attempting to add a last order date to our customers in Zoho CRM that is pulled from a google spreadsheet. This is the test data fields we are using. When we import into Zoho Dataprep, we get this error. After checking the formatting, it appears
Sticky Posts
Announcement: Zoho DataPrep to Deprecate Password-Only Authentication for Snowflake Connections on July 31, 2025
As part of our ongoing commitment to security and in alignment with Snowflake's pledge to the Cybersecurity and Infrastructure Security Agency (CISA) Secure by Design initiative, Zoho DataPrep will no longer support single-factor password authentication.
Announcement: Zoho DataPrep 1.0 will be deprecated on January 31, 2026
We'd like to inform you that the Zoho DataPrep 1.0 version will be officially deprecated as of January 31, 2026. This aligns with our efforts to streamline and improve your overall experience with Zoho DataPrep 2.0 which was released in Sep 2024 . To
Announcement: Migrate your workspaces to Zoho DataPrep 2.0
Zoho DataPrep 2.0 was recently launched with exciting new updates to the platform. You can read more about the new updates in the previous announcement. To take full advantage of the new data pipeline features, migrate your existing workspaces from the
Announcing Zoho DataPrep 2.0: An AI-Powered Data Management Platform
Originally launched in 2021, Zoho DataPrep started as an efficient self-service data preparation solution. We are excited to launch our new version 2.0, with significant enhancements to our platform to help you manage your end-to-end data needs with the
Announcing DataPrep 2.0 Beta!
Being data-driven is an important end goal for all organizations, because when businesses can manage, analyze, and make actionable decisions based on data, they have a competitive advantage. With that said, how confident are you in making business decisions