Assuming searchname is required, the following 3 results were found.
method, you don't have to escape parentheses characters (): // initialize v_MatchedCount = 0; v_MatchedAccountID = 0; v_SearchName = "Father & Sons (Incorporated)"; // // replace apostrophes with double apostrophe for sql v_SearchName =...
more api calls if occurs more than once if(v_Frequency > 1) { // // replace apostrophes with double apostrophe for coql v_SearchName = v_ProductName.replaceAll("'","''",true); // v_KeepID = 0; // // get other products with the same name (set in order of...
one, delete the others) m_Params = {"select_query":"select id, Product_Name from Products where Product_Name = '" + v_SearchName + "' order by id limit " + v_PerPage}; r_CoqlSortedProducts = invokeUrl [ url :"https://www.zohoapis.eu/crm/v7/coql" type...