Cochranville Ag Service
Cochranville Ag wanted to enable their users to generate Excel reports containing crop rotation information and customer data directly from the Salesforce interface. Given crop rotation reports from Salesforce, which contain huge volumes of complex information, they wanted to enable users to click a button and generate an informative and well-formatted Excel report.
They created an FME Workspace to query Salesforce based on given parameters, process the crop rotation data, and arrange the data in an informative Excel report. They then published this workspace to FME Cloud and used the FME Server REST API to connect it to a Salesforce workflow. Now, users can click a button to request an Excel report from Salesforce, and FME processes the job and delivers the report to them via email.