Querying MySQL database to update zoho crm records
Hi,
I am using Zoho crm for our customer interactions, but the latest product masters are still maintained in MySQL server.
So currently when ever we get a new lead the product information is manually entered by running simple query scripts. How do i automate the process.
Ideally, i want to write a custom function which runs on creation and retrieves the desired data and stored in one of the field of the lead record.
1. Is there something similar to the following Java script in deluge ?
var conn = Jdbc.getConnection(url, username, password);
var stmt = conn.createStatement();
var results =
stmt.
executeQuery(
'SELECT * FROM user_details');
2. If not, how else can i get the information into Zoho CRM.
Thanks in advance.
Regards
Anil