Issue with Zoho CRM DELUGE Search – No Results Returned

Issue with Zoho CRM DELUGE Search – No Results Returned

Hi,

I’m trying to run the following code, but it returns nothing. I have 4 records where the Next_Date field has the value "OK".

I tried changing the date format to different types, like "2025-01-01", but I still get no results.

Can you help me understand what’s going wrong?

Here is my code:

  1. query = "Next_Date:less_than:" + "2025-04-04";//today ;
  2. info query;
  3. contact = zoho.crm.searchRecords("Obligations",query);
  4. api_domain = "https://www.zohoapis.com";
  5. url = api_domain+"/crm/v7/Obligations/search?criteria="+encodeUrl(query);
  6. info url;
  7. res = invokeurl
  8.         [
  9.         url: url
  10.         type: GET
  11. connection:"crm"
  12.         ];
  13. info "res: " + res;
  14. return res;
  15. }