Zoho Books - Missing custom fields in SQL Replication

  • 20Views
  • Last Post 3 weeks ago
Ryan O'Connor posted this 3 weeks ago

Hi guys, 

please can you assist me with a query, I have created custom fields in Zoho Books "estimate' and others. When I try to pull the custom fields "customFieldHash" from the Estimate Module, I find a null result in the custom field, even though there is a record in Zoho. I have queried this with Zoho, but they say it must be Skyvia's side. Please can you Assist?

Yevheniia Bilotserkovska posted this 3 weeks ago

Hello Ryan, 

Thank you for contacting us.


Custom fields are not supported by regular Zoho Books connectors. It is possible to implement them via a custom REST connection. We can investigate your scenario and prepare all the necessary data to create it for you.

We will describe the type of authentication, and prepare metadata with custom fields. After that, based on this data, you will need to create a REST connection in Skyvia and use it in your package.

If such an option suits you, please send us the following information (you can send it to us directly):

- specify tables and API names of custom fields;

- fields data types (with maximum length if it's a string);

- an example of your data 

Thank you in advance and looking forward to hearing back from you.

Best regards,

Yevheniia Bilotserkovska.