I’m using the API to upload data into an existing database and I’m running into a problem with source data longer than 100 characters. When my python script hits one of these conditions it aborts. I can see that using the upload utility there are parameters that can be edited in the common_params.conf file to deal with these types of conditions

ZOHO_TRUNCATE_COLNAMES                 TRUE or FALSE

ZOHO_ON_IMPORT_ERROR                       ABORT  or SKIPROW  or SETCOLUMNEMPTY

I've tried using the above controls with the API but they have no effect. Are there similar controls that can be used with the API? Ideally I would like to truncate any data being imported to 100 characters or less. If that didn't work, I could live with  SETCOLUMNEMPTY functionality provided the import didn't abort.

Any ideas on how I can get past this issue?