Zoho Writer supports only public image URL to perform merge operations. So to achieve this please add an image field in both your Creator app and Writer's merge template and use one of the two ways:
Publish your Creator's form report with these steps and get the published key. The published key will be in this format:
https://creatorapp.zohopublic.com/<AppOwnerName>/<AppName>/report-perma/<ReportLinkName>/qvGRXuEHg9AQT5CguhV27krp*****
The highlighted key will be used as 'PublishedLinkKey' in the Deluge script.
Create public links for your images in Deluge. Here's a sample code to create downloadable link of your images in the Creator form.
employeerecord = Employee_Timesheet_Form[ID==input.ID];
info employeerecord.Timer_Screenshot;
imageLink = employeerecord.Timer_Screenshot.getsuffix("image/");
imageLink = employeerecord.getPrefix("\"");
imageURL = "https://creatorexport.zoho.com/file/<AppOwnerName>/<AppName>/<ReportLinkName>/" + input.ID + "/<ImageFieldName>/image-download/<PublishedLinkKey>filepath=/" + imageLink;
info imageURL;
Here's a sample Creator imageURL:
https://creatorexport.zoho.com/file/go*****/employee_****/Employee_*****/1309016000000318035/Timer_Screenshot/image-download/qvGRXuEHg9AQT5CguhV27krp*****?filepath=/1656509699030.png
You can use this imageURL to merge the Creator image with Writer.
Upload your image and create an external download link in Zoho WorkDrive with these steps. Here's a sample WorkDrive URL:
https://workdrive.zohoexternal.com/external/b24042070f8fb42d******/download?directDownload=True
Pass this URL as imageURL in your Deluge script and perform your output operations via Zoho Writer's Deluge tasks or Zoho Writer's API.
Here's a sample Deluge code to merge and send the document as an email with Zoho Writer's API.
data= map();
data.put("employee_name",employeerecord.Employee_Name);
data.put (“employee_email”, employeerecord.Employee_email);
data.put("project_name", employeerecord.Project_Name);
data.put("date",employeerecord.Date_field);
data.put("total_hours_worked", employeerecord.Total_Hours_Worked);
data.put("timer_screenshot", imageURL);
data.put("task_details", employeerecord.Task_Details);
data.put("date", employeerecord.Subform_Date);
data.put("hours_worked", employeerecord.Hours_worked);
data.put("task_description", employeerecord.Task_Description);
param = Map();
param.put("message", "Please find your work details for the past week");
param.put("subject", "Work Details");
param.put("merge_data", {"data":data});
param.put("output_format", "inline");
param.put("recipient_email",employeerecord.Employee_email);
param.put("from_email", "paxyz@zylker.com");
invokeurl
[
url: "https://zohoapis.com/writer/api/v1/documents/eb4kob******/merge/email"
type: post
parameters: param
connection: ""
];
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.