Test

PHOTO EMBED

Thu Jul 03 2025 09:04:04 GMT+0000 (Coordinated Universal Time)

Saved by @Peaky ##pagination ##zoho ##zohocrm ##zoho_crm ##deluge 

string standalone.Test_Mail_Merge_2(String pop_id)
{
	pop_details = zoho.crm.getRecordById("POP_Requests",pop_id);
	info "pop_details ==>" + pop_details;
	Customer_Name = pop_details.get("Customer_Name");
	info "Customer_Name ==>" + Customer_Name;
	Payment_Date = pop_details.get("Payment_Date");
	info "Payment_Date ==>"+Payment_Date;
	Amount_Paid = pop_details.get("Amount_Paid");
	info "Amount_Paid ==>"+Amount_Paid;
	Unit = pop_details.get("Unit");
	info "Unit ==>"+Unit;
	EOI_owner = pop_details.get("EOI");
	info "EOI_owner ==>"+EOI_owner;
	EOI = EOI_owner.get("name");
	info "EOI ==>"+EOI;
	Payment_Mode = pop_details.get("Payment_Mode");
	info "Payment_Mode ==>"+Payment_Mode ;
	Project_owner = pop_details.get("Project");
	info "Project_owner ==>" + Project_owner;
	Project_name = Project_owner.get("name");
	info "Project_name ==>" + Project_name;
	merge_doc_details = invokeurl
	[
	url: "https://www.zohoapis.com/writer/api/v1/documents/kphns9739e715cf504f968324d0e7a0d362a7/fields"
	type: GET
	connection: "mail_merge"
	];
	info "merge_doc_details ==>"+merge_doc_details;
	merge = merge_doc_details.get("merge");
	info "merge ==>"+merge;
	for each my_merge in merge
	{
		info "my_merge ==>"+my_merge;
		}
		attachment_id = "kphns9739e715cf504f968324d0e7a0d362a7";
		emailData = Map();
		fromDetails = Map();
		fromDetails.put("email",zoho.loginuserid);
		emailData.put("from",fromDetails);
		toList = list();
		toUser = Map();
		toUser.put("email","muhammad.kaleem@leosops.com");
		toList.add(toUser);
		emailData.put("to",toList);
		emailData.put("subject","Proof of Payment - " + Customer_Name + " - " + Project_name);
		emailData.put("org_email",false);
		// Attachments
		attachmentList = list();
		attachment = Map();
		attachment.put("id",attachment_id);
		attachmentList.add(attachment);
		emailData.put("attachments",attachmentList);
		// Email Template (Optional)
		template = Map();
		template.put("id","5971686000095227019");
		emailData.put("template",template);
		// Final Payload
		emailDataList = list();
		emailDataList.add(emailData);
		emailRequest = Map();
		emailRequest.put("data",emailDataList);
		inner_data = map();
		inner_data.put("id", pop_id); 
		inner_data.put("Customer_Name", Customer_Name);
		inner_data.put("Payment_Date", Payment_Date);
		inner_data.put("Project", Project_name);
		inner_data.put("Amount_Paid", Amount_Paid);
		inner_data.put("Unit", Unit);
		inner_data.put("EOI", EOI);
		inner_data.put("Payment_Mode", Payment_Mode);
		data = map();
		data.put("data", inner_data);
		mergedata = Map();
		mergedata.put("merge_data", data);
		mergedata.put("subject","Proof of Payment - " + Customer_Name + " - " + Project_name);   
		
		////////////////////
		
		myfile_1 = zoho.writer.mergeAndDownload(attachment_id,"pdf",mergedata,"mail_merge");
		info "File ==> " +myfile_1;

// 		emailData = Map();
// 		fromDetails = Map();
// 		fromDetails.put("email",zoho.loginuserid);
// 		emailData.put("from",fromDetails);
// 		toList = list();
// 		toUser = Map();
// 		toUser.put("email","muhammad.kaleem@leosops.com");
// 		toList.add(toUser);
// 		emailData.put("to",toList);
// 		emailData.put("subject","Proof of Payment - " + Customer_Name + " - " + Project_name);
// 		emailData.put("org_email",false);
// 		// Attachments
// 		attachmentList = list();
// 		attachment = Map();
// 		attachment.put("name",file);
// 		attachment.put("id",attachment_id);
// 		attachmentList.add(attachment);
// 		emailData.put("attachments",attachmentList);
// 		// Email Template (Optional)
// 		template = Map();
// 		template.put("id","5971686000095227019");
// 		emailData.put("template",template);
// 		// Final Payload
// 		emailDataList = list();
// 		emailDataList.add(emailData);
// 		emailRequest = Map();
// 		emailRequest.put("data",emailDataList);
// 		// Send email
// 		send_mail_resp = invokeurl
// 		[
// 			url :"https://www.zohoapis.com/crm/v8/POP_Requests/" + pop_id + "/actions/send_mail"
// 			type :POST
// 			parameters:emailRequest.toString()
// 			connection:"mail_merge"
// 		];
// 		info send_mail_resp;

		
		//////////////////////////////////////////



		send_mail_merge = zoho.writer.mergeAndSend(attachment_id, "pdf", "muhammad.kaleem@leosops.com", mergedata, "mail_merge");
		info "send_mail_merge ==>"+send_mail_merge;
		
		
		records = send_mail_merge.get("records");
		record_1 = records.get(0);
		download_link = record_1.get("download_link");
		info "Download Link ==> " + download_link;

sendmail
[
	from: zoho.loginuserid
	to: "muhammad.kaleem@leosops.com"
	subject: "Test Subjectr"
	message: "Test Message"
	attachments: myfile_1 as PDF

]
info "Send Email ==>";
// 	attachments:<component> <name> as PDF
// 		pdf_file = invokeurl
// 		[
// 		url : download_link
// 		type : GET
// 		connection : "mail_merge"
// 		];
// 		info "Downloaded PDF ==> " + pdf_file;


// 		Send email
// 		send_mail_resp = invokeurl
// 		[
// 			url :"https://www.zohoapis.com/crm/v8/POP_Requests/" + pop_id + "/actions/send_mail"
// 			type :POST
// 			parameters:emailRequest.toString()
// 			connection:"mail_merge"
// 		];
// 		info send_mail_resp;

	return "";
}
content_copyCOPY