queryMap = Map();
queryMap.put("select_query","SELECT TransUnion_Application_ID, TransUnion_Application_Number, Credit_Report, Eviction_Report, Criminal_Report FROM Tenant_Applications WHERE ((TransUnion_Application_ID != '' AND (TransUnion_Application_Number != '' AND (Criminal_Report = 'No' OR (Credit_Report = 'No' OR( Eviction_Report = 'No' or (Criminal_Report = null or(Credit_Report = null or(Eviction_Report = null))))))))) LIMIT 2");
response = invokeurl
[
url :"https://www.zohoapis.com/crm/v8/coql"
type :POST
body:queryMap.toString()
connection:"zoho_crm"
];
info response;