function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Amit Jain 109Amit Jain 109 

I need to send a Report output to users as a Text Message.

I need to send a Report output to users as a Text Message. I have a developer edition. Can someone please suggest me a solution
Raj VakatiRaj Vakati
You can do it in 
  1. Use salesforce apex reporting api 
https://developer.salesforce.com/docs/atlas.en-us.apexcode.meta/apexcode/apex_analytics_intro.htm
  
// Get the report ID
List <Report> reportList = [SELECT Id,DeveloperName FROM Report where 
    DeveloperName = 'Closed_Sales_This_Quarter'];
String reportId = (String)reportList.get(0).get('Id');

// Run the report
Reports.ReportResults results = Reports.ReportManager.runReport(reportId, true);
System.debug('Synchronous results: ' + results);
 2 . You can able to use the SOQL to query the data and make your code will filter as same as report and send from here