Zoho Flow Deluge Custom Function - Fetch Contact by Phone

Zoho_Flow_Fetch_Contact_By_Phone.deluge

map fetchCRMcontactByPhone(string phoneNumber)
{
// Initialize the return map with default values
resultMap = Map();
resultMap.put("found",0);
resultMap.put("Contact_ID","");
resultMap.put("First_Name","");
resultMap.put("Last_Name","");
resultMap.put("Mailing_Street","");
resultMap.put("Mailing_City","");
resultMap.put("Mailing_State","");
resultMap.put("Mailing_Zip","");
resultMap.put("Email","");
resultMap.put("Account_Name","");
resultMap.put("Account_ID","");
// Check if phoneNumber has at least 10 characters
if(phoneNumber.length() < 10)
{
	// Phone number is too short; return the default map
	return resultMap;
}
else
{
	// Take the rightmost 10 characters of the phone number
	queryPhone = phoneNumber.right(10);
	info queryPhone;
	// Construct the COQL query
	coqlQuery = "select id, First_Name, Last_Name, Mailing_Street, Mailing_City, Mailing_State, Mailing_Zip, Email, Account_Name from Contacts where ((Phone like '%" + queryPhone + "') or (Mobile like '%" + queryPhone + "')) limit 1";
	params = Map();
	params.put("select_query",coqlQuery);
	// Execute the COQL query using InvokeUrl
	response = invokeurl
	[
		url :"https://www.zohoapis.com/crm/v7/coql"
		type :POST
		parameters:params.toString()
		connection:"zoho_crm"
	];
	info response;
	// Check if the response contains data
	if(response.get("data") != null && response.get("data").size() > 0)
	{
		// Retrieve the first (and only) record
		record = response.get("data").get(0);
		// Populate the result map with retrieved data
		resultMap.put("found",1);
		resultMap.put("Contact_ID",record.get("id"));
		resultMap.put("First_Name",record.get("First_Name"));
		resultMap.put("Last_Name",record.get("Last_Name"));
		resultMap.put("Mailing_Street",record.get("Mailing_Street"));
		resultMap.put("Mailing_City",record.get("Mailing_City"));
		resultMap.put("Mailing_State",record.get("Mailing_State"));
		resultMap.put("Mailing_Zip",record.get("Mailing_Zip"));
		resultMap.put("Email",record.get("Email"));
		resultMap.put("Account_Name",record.get("Account_Name").get("name"));
		resultMap.put("Account_ID",record.get("Account_Name").get("id"));
	}
	// Return the result map
	return resultMap;
}
}