Hi Team ,
We have an requirement of converting HTML text (Preferably stored in a string) to pdf in salesforce using apex. I am looking for sample code to do so. Also in brief explain how this works with salesforce - is it a package ? or how?
You need use to the endpoints of aspose.cloud API via REST Client in Apex. First of all you need the sign up with aspose.cloud and get the credentials to authenticate your requests. Then make sure that you have api.aspose.cloud/v4.0 enabled under your Remote Site Settings. Later you can create a class for each API call as per your requirement.
You may please check the sample apex code from another thread for reference and change it as per ConvertDocument API method.
# First get Access Token
# Get Customer Key and Customer ID from https://dashboard.aspose.cloud/
curl -X POST "https://api.aspose.cloud/connect/token"
-d "grant_type=client_credentials&client_id=xxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxx&client_secret=xxxxxxxxxxxxxxxxxxxxxx"
-H "Content-Type: application/x-www-form-urlencoded"
-H "Accept: application/json"
# Convert HTML to PDF
curl -X PUT "https://api.aspose.cloud/v4.0/words/convert?format=pdf"
-H "accept: application/octet-stream"
-H "Authorization: Bearer [Access_Token]"
-H "Content-Type: multipart/form-data"
-F "document"="@C:/Temp/Test.html"
--output C:/Temp/Test.pdf
Thanks @tilal.ahmad. My question here was can we convert HTML which is not stored anywhere. This HTML comes as a input from an input field. This Input is in HTML field.
Salesforce has no way to convert HTML To PDF for languages other than english.? This is where we need aspose license.
So my second question was can we convert html having traditional Chinese text or Japanese text into pdf.?
Lastly, do we not have any ready apex sample to accomplish this? or specifically the class name and method name from your unmanaged package as installed from github.
The ConvertDocument API method converts the HTML file from the request body. It should work in your scenario. However. I will further look into it and will guide you.
Please check the available fonts list on our Cloud server. By default, the ConvertDocument API method uses these fonts for the conversion.
However, if you need some custom fonts for the conversion then you can upload your fonts to a cloud storage folder and pass the cloud storage folder path in API call using fontsLocation Parameter. So yes you can convert the HTML file with traditional Chinese text or Japanese text to PDF.
I am afraid currently the updated Apex sample code is not available. We will try to provide samples in the future. However, meanwhile as shared above you can convert the cURL commands to Apex code.
@tilal.ahmad
So you are saying it has double byte characters support. Nice.
I know i am troubling you on this, but this way to combine everything and put into a apex code is a complex task. I am not complaining/comparing but did go through other products they have samples uploaded on there support and so it becomes so easy for the user to use it. In salesforce we rarely use cURL and so i am also very less aware of it.
I just want to try this once at my end and i can than ask the team to go forward with the licenses.
And offcourse i see you support few other storage vendors also. In this case do you support cloudinary also.
Thanks for your feedback. Yes we are planning to update and upload the salesforce samples in near future.
We currently support Amazon S3, DropBox, Google Drive Storage, Google Cloud Storage, Windows Azure Storage, FTP Storage along with Aspose internal Storage. However, we do not support cloudinary yet as we have not received any requirement for it. So, we have logged a feature request(STORAGE-153) to investigate the requirement and implement it accordingly.
Thanks for taking the feedback , but I am still trying to put together the apex code. From your article I found the code to get the authentication token but still not aware of the exact method to convert the html text to pdf.
I am afraid I am not good at Apex. Howerver, please spare us some time, I will try to share sample Apex code for HTML to PFF conversion.
We have further investigated your requirement and would suggest using to MailMerge Word Document with your HTML/Rich text. Please follow this workflow for this purpose.
- Create JSON/XML string of your HTML/Rich Text
- Mail Merge JSON/XML in Word template, it will save the result on cloud storage
- Convert the resultant Word document to PDF
- Download the PDF file and get the file data in blob format
Please check the sample Apex code to MailMerge a Word template with HTML along with sample template and output. Hopefully, it will help you to accomplish the task.
template.zip (9.3 KB)
public String ExecuteMailMerege(String FileName, String htmlData, String outFormat) {
try {
//build URI to Mailmerge using data from cloud storage
//String strURl = Product.BaseProductUri + '/words/' + FileName + '/MailMerge?destFileName=MailMergeOut.doc&mailMergeDataFile=' + dataFile;
//build URI to Mailmerge data from string (json/xml)
String strURl = Product.BaseProductUri + '/words/' + FileName + '/MailMerge?destFileName=MailMergeOut.doc';
//Mailmerge from data file
//String strJSON = Utils.ProcessCommand(strURl, 'PUT', null, 'json');
//Mailmerge from data file
//XML
//String htmlData=’<?xml version="1.0" encoding="utf-8" ?><html><head><style type=“text/css”>h2{color:green} .color_red{color:red} .color_green{color:green} .color_magenta{color:magenta} .color_olive{color:olive} .color_teal{color:teal}</style></head><body><h2>Table</h2><table border=“2” cellspacing=“0” cellpadding=“4”><tr><th class=“color_red”>Column 1</th><th class=“color_green”>Column 2</th></tr><tr><td class=“color_magenta”>Value 1.1</td><td class=“color_olive”>Value 1.2</td></tr><tr><td class=“color_teal”>Value 2.1</td></tr></table><h2>Div</h2><div class=“color_olive”>Outer text<div class=“color_magenta”>Inner text</div>Outer text</div><h2>Image</h2><br/><img src=“data:image/gif;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAADUUlEQVR42lWTWUwTURSGaUtIKY5QweISTUzceDGu0Rj1xURjTNQEE+ODGn0hPhBEQdqZztahBbrAtFih1Fprh9IBiVLLErZSU7BUoS7VqNH44ovx0S0ovdfO4Ez04cw9Ofec7/5zzr15NEnkUxSVFx8ObZ1x7nzHN6z9nOhnzOFwWCnECcKoEFbBRrrp6iF/XRvD0BoplkdTuAiIhtt3P3Fu+jJlKlkM1WoXLFjVeSnpXrC94gV3ciJp1X0L1K7+NtDfvXdpj1TmmUwm8QTfLa867T+ceWTSwO5r5b87XNaDEoBrv3p2Ai+AU1Qh5OiDGS4UXi4roAisQHBiYfJS2obAVPMyELYcGxViOIaKcLaNLXzadej5nBUBPXW6hdYW0z4RQOYUXK2tUfr8QeXL0Kn4JKEBk7QWdtrrLggJJEmoCBxVCf50qIaaa0HABFkEPZaLNnGfwPNFGV0u05Y554bvMQoBPLbxs9t9QydJpHP/KayRbsf+pG1NdgTTgDuGXa8dbS41ZtArxaQYT1WlHVqYaloGOcvJIan4X2MdViTl3vExbS+GPfXlvzzutj1LPch9HrYea59t0YIRtAAO+PQuIWYwNKikYty41Iuk/3TvMzsCB9HcQR7msgzgjZs7Z5rLQPR6PojeJW2d3oDCoG/IlwAYqlexbp/i9eB19ziuBoMoAlrR03YZ0G8+0JFhS8EjuhD6zWfuCTEjppcBOKYX1bwaqA5MM2oYZ4pBy7XjrAyY7sPqU01FcNZW/jtwZeXXVpt5u1RM4JhYzHFBddqz5/28fUU2NwngtVUbZUCE79o6x67/MYiXLiSbS8D9xp1vI7znkLvDK07A5/MiT7mzdxMMAsdMqxaiWDHkgzePigBUXy9KTfdWeVKNSjjPrvv5uKkYxszlIHX7eDLeVfkgbt30bt5eAlOOtT9nLRrI03szrOumOtcb4SrTSj2KKfr4nuUZ7kR8HFPAYXLlYqxRl43TGjjTWAhHCC1MNK/+lWA0cJLRgfsh95G/N1H136z7+BCSuHMuMEGVLo4a1XCKKcuO0WXZBw1FcNighmPWbe8jIeeJpdFiCrkHguWUyM92NBKseBut8T92bfsw66z49IyrHH2T5CvlqeCYUvL/ANIZ7+ohXSdWAAAAAElFTkSuQmCC”></body></html>’;
//Json
//String htmlData=’{“root”:{“data”:{“format”:“html”,“htmlText”:"<html><head><style type=“text/css”>h2{color:green} .color_red{color:red} .color_green{color:green} .color_magenta{color:magenta} .color_olive{color:olive} .color_teal{color:teal}</style></head><body><h2>Table</h2><table border=“2” cellspacing=“0” cellpadding=“4”><tr><th class=“color_red”>Column 1</th><th class=“color_green”>Column 2</th></tr><tr><td class=“color_magenta”>Value 1.1</td><td class=“color_olive”>Value 1.2</td></tr><tr><td class=“color_teal”>Value 2.1</td></tr></table><h2>Div</h2><div class=“color_olive”>Outer text<div class=“color_magenta”>Inner text</div>Outer text</div><h2>Image</h2><br/><img src=“data:image/gif;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAADUUlEQVR42lWTWUwTURSGaUtIKY5QweISTUzceDGu0Rj1xURjTNQEE+ODGn0hPhBEQdqZztahBbrAtFih1Fprh9IBiVLLErZSU7BUoS7VqNH44ovx0S0ovdfO4Ez04cw9Ofec7/5zzr15NEnkUxSVFx8ObZ1x7nzHN6z9nOhnzOFwWCnECcKoEFbBRrrp6iF/XRvD0BoplkdTuAiIhtt3P3Fu+jJlKlkM1WoXLFjVeSnpXrC94gV3ciJp1X0L1K7+NtDfvXdpj1TmmUwm8QTfLa867T+ceWTSwO5r5b87XNaDEoBrv3p2Ai+AU1Qh5OiDGS4UXi4roAisQHBiYfJS2obAVPMyELYcGxViOIaKcLaNLXzadej5nBUBPXW6hdYW0z4RQOYUXK2tUfr8QeXL0Kn4JKEBk7QWdtrrLggJJEmoCBxVCf50qIaaa0HABFkEPZaLNnGfwPNFGV0u05Y554bvMQoBPLbxs9t9QydJpHP/KayRbsf+pG1NdgTTgDuGXa8dbS41ZtArxaQYT1WlHVqYaloGOcvJIan4X2MdViTl3vExbS+GPfXlvzzutj1LPch9HrYea59t0YIRtAAO+PQuIWYwNKikYty41Iuk/3TvMzsCB9HcQR7msgzgjZs7Z5rLQPR6PojeJW2d3oDCoG/IlwAYqlexbp/i9eB19ziuBoMoAlrR03YZ0G8+0JFhS8EjuhD6zWfuCTEjppcBOKYX1bwaqA5MM2oYZ4pBy7XjrAyY7sPqU01FcNZW/jtwZeXXVpt5u1RM4JhYzHFBddqz5/28fUU2NwngtVUbZUCE79o6x67/MYiXLiSbS8D9xp1vI7znkLvDK07A5/MiT7mzdxMMAsdMqxaiWDHkgzePigBUXy9KTfdWeVKNSjjPrvv5uKkYxszlIHX7eDLeVfkgbt30bt5eAlOOtT9nLRrI03szrOumOtcb4SrTSj2KKfr4nuUZ7kR8HFPAYXLlYqxRl43TGjjTWAhHCC1MNK/+lWA0cJLRgfsh95G/N1H136z7+BCSuHMuMEGVLo4a1XCKKcuO0WXZBw1FcNighmPWbe8jIeeJpdFiCrkHguWUyM92NBKseBut8T92bfsw66z49IyrHH2T5CvlqeCYUvL/ANIZ7+ohXSdWAAAAAElFTkSuQmCC”></body></html>"}}}’;
String strJSON = Utils.ProcessCommand(strURl, ‘PUT’, htmlData, ‘json’);
//this.apiResponse = strJSON;
system.debug(strJSON);
//prepare signed download link
String downloadURL = null;
Map<String, Object> params = (Map<String, Object>)JSON.deserializeUntyped(strJSON);
if(params.containsKey('Document')){
Map<String, Object> doc = (Map<String, Object>)params.get('Document');
String DocName = (String)doc.get('FileName');
strURl = Product.BaseProductUri + '/words/' + DocName + '?format=' + outFormat;
downloadURL = strURl;
}
return downloadURL;
}
catch (Exception ex) {
system.debug(ex);
return null;
}
}
@tilal.ahmad
Thanks for all your effort . I feel i am very close. I have two questions here.
- What is file name parameter.
- What is HtmlData Parameter here.
Now My Input is
String jsonData = ‘
秘密保持契約書 および売主またはそのいずれかは、本契約の日付の前後いずれに提供されたかを問わないすべての情報（以下
’ ;Output - Should be blob version or base64 encoded or UTF-8 encoded or at least an pdf url which i will convert to base64.
Request - System.HttpRequest[Endpoint=https://api.aspose.cloud/v4.0/words//MailMerge?destFileName=test.pdf, Method=PUT]
response: System.HttpResponse[Status=Not Found, StatusCode=404]
What am i missing here?
Below is my code.
public class asposeMailMerge {
public static string GetJWT(){
String grant_type = 'client_credentials';
String client_id= '1ddabfd7-82a1-421f-a051-1d39d487f6c0';
String client_secret= '7c0e602e6a5c346829e6ceae20070dc4';
HttpRequest request = new HttpRequest();
request.setEndpoint('https://api.aspose.cloud/connect/token');
request.setMethod('GET');
request.setHeader('Content-Type', 'application/x-www-form-urlencoded');
request.setHeader('Accept', 'application/json');
String body = 'grant_type=' + grant_type + '&client_id=' + client_id + '&client_secret='+ client_secret ;
request.setBody(body);
Http http = new Http();
HttpResponse res = http.send(request);
String jsonInput = res.getBody();
Map<String, Object> a =(Map<String, Object>)JSON.deserializeUntyped(jsonInput);
system.debug('JWT Token is: '+a.get('access_token'));
return a.get('access_token').ToString();
}
public static String ProcessCommand(String strURI, String strHttpCommand, String strContent, String ContentType, String accessToken) {
try {
HttpRequest request = new HttpRequest();
Integer len = 0;
if (strContent != null) {
request.setBody(strContent);
len = strContent.length();
}
system.debug('httpcommand: ' + strHttpCommand);
request.setEndpoint(strURI);
request.setMethod(strHttpCommand);
if (ContentType.toLowerCase() == 'xml')
request.setHeader('Content-Type', 'application/xml');
else
request.setHeader('Content-Type', 'application/json');
request.setHeader('Content-Length', String.valueOf(len));
request.setHeader('Accept', 'application/json');
request.setHeader('Authorization', accessToken);
request.setTimeout(120000);
Http http = new Http();
system.debug('request ' + request);
HttpResponse res = http.send(request);
system.debug('util response:' + res);
return res.getBody();
} catch (Exception ex) {
system.debug('HTTP ERROR' + ex.getMessage());
system.debug(ex.getStackTraceString());
return null;
}
}
public static String ExecuteMailMerege(String FileName, String htmlData, String outFormat) {
try {
String strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + FileName + '/MailMerge?destFileName=test.pdf';
//Json
//String htmlData='{root':{'data':{'format':'html','htmlText':'<html><head><style type=“text/css”>h2{color:green} .color_red{color:red} .color_green{color:green} .color_magenta{color:magenta} .color_olive{color:olive} .color_teal{color:teal}</style></head><body><h2>Table</h2><table border=“2” cellspacing=“0” cellpadding=“4”><tr><th class=“color_red”>Column 1</th><th class=“color_green”>Column 2</th></tr><tr><td class=“color_magenta”>Value 1.1</td><td class=“color_olive”>Value 1.2</td></tr><tr><td class=“color_teal”>Value 2.1</td></tr></table><h2>Div</h2><div class=“color_olive”>Outer text<div class=“color_magenta”>Inner text</div>Outer text</div><h2>Image</h2><br/><img src=“data:image/gif;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAADUUlEQVR42lWTWUwTURSGaUtIKY5QweISTUzceDGu0Rj1xURjTNQEE+ODGn0hPhBEQdqZztahBbrAtFih1Fprh9IBiVLLErZSU7BUoS7VqNH44ovx0S0ovdfO4Ez04cw9Ofec7/5zzr15NEnkUxSVFx8ObZ1x7nzHN6z9nOhnzOFwWCnECcKoEFbBRrrp6iF/XRvD0BoplkdTuAiIhtt3P3Fu+jJlKlkM1WoXLFjVeSnpXrC94gV3ciJp1X0L1K7+NtDfvXdpj1TmmUwm8QTfLa867T+ceWTSwO5r5b87XNaDEoBrv3p2Ai+AU1Qh5OiDGS4UXi4roAisQHBiYfJS2obAVPMyELYcGxViOIaKcLaNLXzadej5nBUBPXW6hdYW0z4RQOYUXK2tUfr8QeXL0Kn4JKEBk7QWdtrrLggJJEmoCBxVCf50qIaaa0HABFkEPZaLNnGfwPNFGV0u05Y554bvMQoBPLbxs9t9QydJpHP/KayRbsf+pG1NdgTTgDuGXa8dbS41ZtArxaQYT1WlHVqYaloGOcvJIan4X2MdViTl3vExbS+GPfXlvzzutj1LPch9HrYea59t0YIRtAAO+PQuIWYwNKikYty41Iuk/3TvMzsCB9HcQR7msgzgjZs7Z5rLQPR6PojeJW2d3oDCoG/IlwAYqlexbp/i9eB19ziuBoMoAlrR03YZ0G8+0JFhS8EjuhD6zWfuCTEjppcBOKYX1bwaqA5MM2oYZ4pBy7XjrAyY7sPqU01FcNZW/jtwZeXXVpt5u1RM4JhYzHFBddqz5/28fUU2NwngtVUbZUCE79o6x67/MYiXLiSbS8D9xp1vI7znkLvDK07A5/MiT7mzdxMMAsdMqxaiWDHkgzePigBUXy9KTfdWeVKNSjjPrvv5uKkYxszlIHX7eDLeVfkgbt30bt5eAlOOtT9nLRrI03szrOumOtcb4SrTSj2KKfr4nuUZ7kR8HFPAYXLlYqxRl43TGjjTWAhHCC1MNK/+lWA0cJLRgfsh95G/N1H136z7+BCSuHMuMEGVLo4a1XCKKcuO0WXZBw1FcNighmPWbe8jIeeJpdFiCrkHguWUyM92NBKseBut8T92bfsw66z49IyrHH2T5CvlqeCYUvL/ANIZ7+ohXSdWAAAAAElFTkSuQmCC”></body></html>"}}}’;
//String jsonData = JSON.serialize('<p style="text-align: center;"><b style="color: rgb(102, 102, 102); font-size: 9pt;">秘密保持契約書 および売主またはそのいずれかは、本契約の日付の前後いずれに提供されたかを問わないすべての情報（以下</b></p>');
String jsonData='{"root":{"data":{"format":"html","htmlText":"<html><head><style type="text/css">h2{color:green} .color_red{color:red} .color_green{color:green} .color_magenta{color:magenta} .color_olive{color:olive} .color_teal{color:teal}</style></head><body><h2>Table</h2><table border="2" cellspacing="0" cellpadding="4"><tr><th class="color_red">Column 1</th><th class="color_green">Column 2</th></tr><tr><td class="color_magenta">Value 1.1</td><td class="color_olive">Value 1.2</td></tr><tr><td class="color_teal">Value 2.1</td></tr></table><h2>Div</h2><div class="color_olive">Outer text<div class="color_magenta">Inner text</div>Outer text</div><h2>Image</h2><br/><img src="data:image/gif;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAADUUlEQVR42lWTWUwTURSGaUtIKY5QweISTUzceDGu0Rj1xURjTNQEE+ODGn0hPhBEQdqZztahBbrAtFih1Fprh9IBiVLLErZSU7BUoS7VqNH44ovx0S0ovdfO4Ez04cw9Ofec7/5zzr15NEnkUxSVFx8ObZ1x7nzHN6z9nOhnzOFwWCnECcKoEFbBRrrp6iF/XRvD0BoplkdTuAiIhtt3P3Fu+jJlKlkM1WoXLFjVeSnpXrC94gV3ciJp1X0L1K7+NtDfvXdpj1TmmUwm8QTfLa867T+ceWTSwO5r5b87XNaDEoBrv3p2Ai+AU1Qh5OiDGS4UXi4roAisQHBiYfJS2obAVPMyELYcGxViOIaKcLaNLXzadej5nBUBPXW6hdYW0z4RQOYUXK2tUfr8QeXL0Kn4JKEBk7QWdtrrLggJJEmoCBxVCf50qIaaa0HABFkEPZaLNnGfwPNFGV0u05Y554bvMQoBPLbxs9t9QydJpHP/KayRbsf+pG1NdgTTgDuGXa8dbS41ZtArxaQYT1WlHVqYaloGOcvJIan4X2MdViTl3vExbS+GPfXlvzzutj1LPch9HrYea59t0YIRtAAO+PQuIWYwNKikYty41Iuk/3TvMzsCB9HcQR7msgzgjZs7Z5rLQPR6PojeJW2d3oDCoG/IlwAYqlexbp/i9eB19ziuBoMoAlrR03YZ0G8+0JFhS8EjuhD6zWfuCTEjppcBOKYX1bwaqA5MM2oYZ4pBy7XjrAyY7sPqU01FcNZW/jtwZeXXVpt5u1RM4JhYzHFBddqz5/28fUU2NwngtVUbZUCE79o6x67/MYiXLiSbS8D9xp1vI7znkLvDK07A5/MiT7mzdxMMAsdMqxaiWDHkgzePigBUXy9KTfdWeVKNSjjPrvv5uKkYxszlIHX7eDLeVfkgbt30bt5eAlOOtT9nLRrI03szrOumOtcb4SrTSj2KKfr4nuUZ7kR8HFPAYXLlYqxRl43TGjjTWAhHCC1MNK/+lWA0cJLRgfsh95G/N1H136z7+BCSuHMuMEGVLo4a1XCKKcuO0WXZBw1FcNighmPWbe8jIeeJpdFiCrkHguWUyM92NBKseBut8T92bfsw66z49IyrHH2T5CvlqeCYUvL/ANIZ7+ohXSdWAAAAAElFTkSuQmCC"></body></html>"}}}';
system.debug('jsonData ' + jsonData );
String strJSON = ProcessCommand(strURl, 'PUT', jsonData, 'json', GetJWT());
system.debug('strJSON @@ ' + strJSON);
String downloadURL = null;
Map<String, Object> params = (Map<String, Object>)JSON.deserializeUntyped(strJSON);
if(params.containsKey('Document')){
Map<String, Object> doc = (Map<String, Object>)params.get('Document');
String DocName = (String)doc.get('FileName');
strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + DocName + '?format=' + outFormat;
downloadURL = strURl;
}
return downloadURL;
}
catch (Exception ex) {
system.debug(ex.getLineNumber() + '- ' + ex.getCause() + '- ' + ex.getMessage() + '- '+ ex.getStackTraceString());
return null;
}
}
}
It is MailMerge Template(DOC/DOCX) file name from the cloud storage that will be passed in the API call. First, you need to upload your Template to cloud storage. As suggested above you need to mail merge HTML/Rich Text in a Template and then convert it to PDF. I have also shared a sample MailMerge template in a zip file.
https://api.aspose.cloud/v4.0/words/template.doc/MailMerge?destFileName=test.doc
It is JSON/XML data to populate in MailMerge Template.
String inputText ='秘密保持契約書 および売主またはそのいずれかは、本契約の日付の前後いずれに提供されたかを問わないすべての情報（以下' ;
String jsonData= '{"root":{"data":{"format": "html","htmlText": "' + inputText + '"}}}';
In addition to the above reply, please note in the above examples we have used Aspose Cloud default storage so we have not used the storage parameter. If you want to use any other supported cloud storage(Amazon S3, DropBox, Google Drive Storage, Google Cloud Storage, Windows Azure Storage, FTP Storage) then you need to pass the storage name as well.
https://api.aspose.cloud/v4.0/words/template.doc/MailMerge?storage=myGoogleAspose&destFileName=Test.doc
@tilal.ahmad
“Error”: {
“Code”: “ErrorItemNotFound”,
“Message”: “Error while loading file ‘template.doc’ from storage: AmazonS3 Storage exception: The specified key does not exist. Bucket ‘aspose.cloud-filestorage-prod’, FilePath ‘848421/baabd63f-e70b-4077-a371-f9bcba28289d/template.doc’”,
“Description”: “Operation Failed. Item Not Found.”,
“InnerError”: {
“Code”: “errorAmazonS3Storage”,
“Message”: “AmazonS3 Storage exception: The specified key does not exist. Bucket ‘aspose.cloud-filestorage-prod’, FilePath ‘848421/baabd63f-e70b-4077-a371-f9bcba28289d/template.doc’”,
“Description”: “Operation Failed. The remote server returned an error: (404) Not Found.”
}
},
“RequestId”: “Root=1-602cb8b6-20df662b3fa7a51b77e522fc”
I am getting above response while doing mail merge.
It seems the API call is unable to find the target file(template.doc). Please double check that the template.doc is available in your default cloud storage from aspose.cloud dashboard.
@tilal.ahmad
I have put template file there and i am try to build URI to Mailmerge data from string (json/xml) and i am still getting below error.
Error": {
“Code”: “ErrorInvalidInputData”,
“Message”: “Mail merge data is required in request body or you should specify ‘mailMergeDataFile’ parameter.”,
“Description”: “Operation Failed. The input data is not valid.”
},
“RequestId”: “Root=1-602d008e-44a9590029da899b1e0cab49”
}
I am using below code-
String strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + 'template.doc' + '/MailMerge?destFileName=test.doc';
String strJSON = ProcessCommand(strURl, 'PUT', null, 'json', GetJWT());
It is getting difficult for me to execute this… Can you also see what wrong am I doing in the code which I shared above.
As stated in the error message, you are not passing the MailMerge data in the API call.
Please pass your JSON data(jsonData) to populate in the template. It should resolve the issue.
String strJSON = ProcessCommand(strURl, ‘PUT’, jsonData, ‘json’, GetJWT());
Ok and what would be this datafile? is it the input html.
String strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + 'template.doc' + '/MailMerge?destFileName=test.doc' + '&mailMergeDataFile=' + dataFile;
//String strJSON = ProcessCommand(strURl, 'PUT', null, 'json', GetJWT());
//system.debug('strJSON @@ ' + strJSON);
//Json
String inputText = '<p style="text-align: center;"><b style="color: rgb(102, 102, 102); font-size: 9pt;">秘密保持契約書 および売主またはそのいずれかは、本契約の日付の前後いずれに提供されたかを問わないすべての情報（以下</b></p>';
String jsonData= '{"root":{"data":{"format": "html","htmlText": "' + inputText + '"}}}';
system.debug('jsonData ' + jsonData );
String strJSON1 = ProcessCommand(strURl, 'PUT', jsonData, 'json', GetJWT());
system.debug('strJSON1 @@ ' + strJSON1);
String downloadURL = null;
Map<String, Object> params = (Map<String, Object>)JSON.deserializeUntyped(strJSON1);
if(params.containsKey('Document')){
Map<String, Object> doc = (Map<String, Object>)params.get('Document');
String DocName = (String)doc.get('FileName');
strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + DocName + '?format=' + outFormat;
downloadURL = strURl;
}
return downloadURL;
Please note the MailMerge API request supports passing Mailmerge data using a data file from cloud storage or JSON/XML data via request body. As per your requirement you need to convert HTML text(stored in a string) to PDF. So I have shared sample code using the request body.
Please pay attention to the sample code shared in my above post. You may amend it as per your need.
....
String strURl = Product.BaseProductUri + '/words/' + FileName + '/MailMerge?destFileName=MailMergeOut.doc';
....
//Json
//String htmlData=’{“root”:{“data”:{“format”:“html”,“htmlText”:"<html><head><style type=“text/css”>h2{color:green} .color_red{color:red} .color_green{color:green} .color_magenta{color:magenta} .color_olive{color:olive} .color_teal{color:teal}</style></head><body><h2>Table</h2><table border=“2” cellspacing=“0” cellpadding=“4”><tr><th class=“color_red”>Column 1</th><th class=“color_green”>Column 2</th></tr><tr><td class=“color_magenta”>Value 1.1</td><td class=“color_olive”>Value 1.2</td></tr><tr><td class=“color_teal”>Value 2.1</td></tr></table><h2>Div</h2><div class=“color_olive”>Outer text<div class=“color_magenta”>Inner text</div>Outer text</div><h2>Image</h2><br/><img src=“data:image/gif;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAACXBIWXMAAAsTAAALEwEAmpwYAAADUUlEQVR42lWTWUwTURSGaUtIKY5QweISTUzceDGu0Rj1xURjTNQEE+ODGn0hPhBEQdqZztahBbrAtFih1Fprh9IBiVLLErZSU7BUoS7VqNH44ovx0S0ovdfO4Ez04cw9Ofec7/5zzr15NEnkUxSVFx8ObZ1x7nzHN6z9nOhnzOFwWCnECcKoEFbBRrrp6iF/XRvD0BoplkdTuAiIhtt3P3Fu+jJlKlkM1WoXLFjVeSnpXrC94gV3ciJp1X0L1K7+NtDfvXdpj1TmmUwm8QTfLa867T+ceWTSwO5r5b87XNaDEoBrv3p2Ai+AU1Qh5OiDGS4UXi4roAisQHBiYfJS2obAVPMyELYcGxViOIaKcLaNLXzadej5nBUBPXW6hdYW0z4RQOYUXK2tUfr8QeXL0Kn4JKEBk7QWdtrrLggJJEmoCBxVCf50qIaaa0HABFkEPZaLNnGfwPNFGV0u05Y554bvMQoBPLbxs9t9QydJpHP/KayRbsf+pG1NdgTTgDuGXa8dbS41ZtArxaQYT1WlHVqYaloGOcvJIan4X2MdViTl3vExbS+GPfXlvzzutj1LPch9HrYea59t0YIRtAAO+PQuIWYwNKikYty41Iuk/3TvMzsCB9HcQR7msgzgjZs7Z5rLQPR6PojeJW2d3oDCoG/IlwAYqlexbp/i9eB19ziuBoMoAlrR03YZ0G8+0JFhS8EjuhD6zWfuCTEjppcBOKYX1bwaqA5MM2oYZ4pBy7XjrAyY7sPqU01FcNZW/jtwZeXXVpt5u1RM4JhYzHFBddqz5/28fUU2NwngtVUbZUCE79o6x67/MYiXLiSbS8D9xp1vI7znkLvDK07A5/MiT7mzdxMMAsdMqxaiWDHkgzePigBUXy9KTfdWeVKNSjjPrvv5uKkYxszlIHX7eDLeVfkgbt30bt5eAlOOtT9nLRrI03szrOumOtcb4SrTSj2KKfr4nuUZ7kR8HFPAYXLlYqxRl43TGjjTWAhHCC1MNK/+lWA0cJLRgfsh95G/N1H136z7+BCSuHMuMEGVLo4a1XCKKcuO0WXZBw1FcNighmPWbe8jIeeJpdFiCrkHguWUyM92NBKseBut8T92bfsw66z49IyrHH2T5CvlqeCYUvL/ANIZ7+ohXSdWAAAAAElFTkSuQmCC”></body></html>"}}}’;
String strJSON = Utils.ProcessCommand(strURl, ‘PUT’, htmlData, ‘json’);
....
In the above code, MailMerge is not passed in the uri.
String strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + 'template.doc' + '/MailMerge?destFileName=MailMergeOut(1).doc';
String inputText = '<p style="text-align: center;"><b style="color: rgb(102, 102, 102); font-size: 9pt;">秘密保持契約書 および売主またはそのいずれかは、本契約の日付の前後いずれに提供されたかを問わないすべての情報（以下</b></p>';
String jsonData= '{"root":{"data":{"format": "html","htmlText": "' + inputText + '"}}}';
system.debug('jsonData ' + jsonData );
String strJSON1 = ProcessCommand(strURl, 'PUT', jsonData, 'json', GetJWT());
system.debug('strJSON1 @@ ' + strJSON1);
String downloadURL = null;
Map<String, Object> params = (Map<String, Object>)JSON.deserializeUntyped(strJSON1);
if(params.containsKey('Document')){
Map<String, Object> doc = (Map<String, Object>)params.get('Document');
String DocName = (String)doc.get('FileName');
strURl = 'https://api.aspose.cloud/v4.0' + '/words/' + DocName + '?format=' + outFormat;
downloadURL = strURl;
}
return downloadURL;
Can you tell me what’s wrong in above code. I am getting below error -
“Message”: “After parsing a value an unexpected character was encountered: t. Path ‘root.data.htmlText’, line 1, position 57.”