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;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter