Apex Code Development You need to sign in to do that
Don't have an account?
Jane Liu scheduled report stopped sending report as .csv all of sudden, changed to _csv.html instead, no code/config change
We have a scheduled report from the following apex class, it has been sending .csv files everyday until Nov 29 that it suddenly changed to _csv.html. I can't figure out why the change. Any idea?
global class ReportExporter implements System.Schedulable {
global void execute(SchedulableContext sc) {
DoExport();
}
@future(callout=true)
public static void DoExport() {
ApexPages.PageReference report = new ApexPages.PageReference('/00OC0000006zAnv?csv=1&enc=UTF-8');
Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();
attachment.setFileName('All_PROB_AMOUNT.csv');
if(Test.isRunningTest()) {
attachment.setBody(blob.valueOf('Unit.Test'));
} else {
attachment.setBody(Blob.valueof(report.getContent().toString()));
}
attachment.setContentType('text/csv');
Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();
message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );
message.setSubject('Daily ALL PROB AMOUNT Report');
message.setPlainTextBody('The report is attached.');
message.setToAddresses( new String[] { 'test@test.com', 'test2@test.com' } );
Messaging.sendEmail( new Messaging.SingleEmailMessage[] { message } );
}
}
global class ReportExporter implements System.Schedulable {
global void execute(SchedulableContext sc) {
DoExport();
}
@future(callout=true)
public static void DoExport() {
ApexPages.PageReference report = new ApexPages.PageReference('/00OC0000006zAnv?csv=1&enc=UTF-8');
Messaging.EmailFileAttachment attachment = new Messaging.EmailFileAttachment();
attachment.setFileName('All_PROB_AMOUNT.csv');
if(Test.isRunningTest()) {
attachment.setBody(blob.valueOf('Unit.Test'));
} else {
attachment.setBody(Blob.valueof(report.getContent().toString()));
}
attachment.setContentType('text/csv');
Messaging.SingleEmailMessage message = new Messaging.SingleEmailMessage();
message.setFileAttachments(new Messaging.EmailFileAttachment[] { attachment } );
message.setSubject('Daily ALL PROB AMOUNT Report');
message.setPlainTextBody('The report is attached.');
message.setToAddresses( new String[] { 'test@test.com', 'test2@test.com' } );
Messaging.sendEmail( new Messaging.SingleEmailMessage[] { message } );
}
}
Before it's attached as .csv, not html.
<html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><meta http-equiv="Refresh" content="0; URL=https://c.na8.content.force.com/servlet/servlet.EmailAttachmentDownload?q=pj5jeYgvuTMUueO%2BV37YTijMPPdOgtJp%2FtSDV2Z%2FpCM%2FY%2Bp4%2BAGQVt9pord864bq2p4gRAKI4saX7Xd1lOBV2g%3D%3D"></head><body><div>Attachment not opening? Click this link: <a href="https://c.na8.content.force.com/servlet/servlet.EmailAttachmentDownload?q=pj5jeYgvuTMUueO%2BV37YTijMPPdOgtJp%2FtSDV2Z%2FpCM%2FY%2Bp4%2BAGQVt9pord864bq2p4gRAKI4saX7Xd1lOBV2g%3D%3D">All_PROB_AMOUNT.csv</a></div></html>