Perfect, I was able to obtain product names, where productCateogury = Fruits.Example with equal(=)
Wiki says,
http://crm.zoho.com/crm/private/xml/Leads/getSearchRecords?apikey=APIKEY
&ticket=TICKET
&selectColumns=Leads(First Name,Last Name,Email,Company)&searchCondition=(Email|=|test@test.com)
But, we DONOT HAVE example for |doesn't contain| operator
Wiki says,Example with contains
http://crm.zoho.com/crm/private/xml/Leads/getSearchRecords?apikey=APIKEY
&ticket=TICKET
&selectColumns=Leads(First Name,Last Name,Email,Company)
&searchCondition=(Company|contains|*oho*)
But nevertheless, this worked
http://crm.zoho.com/crm/private/xml/Leads/getSearchRecords?apikey=APIKEY
&ticket=TICKET
&selectColumns=Leads(First Name,Last Name,Email,Company)
&searchCondition=(Company
|doesn't contain| *oho*)
But, I could not see how i can pass multiple values for the same search column.Company |doesn't contain | *oho*,
Finally, figured it as
http://crm.zoho.com/crm/private/xml/Leads/getSearchRecords?apikey=APIKEY
&ticket=TICKET
&selectColumns=Leads(First Name,Last Name,Email,Company)
&searchCondition=(Company
|doesn't contain| Company 1 |OR| Comapny 2 |OR| Company 3)