Getting Reports From Salesforce to Custom Portal using php

Hey All,
I have been searching ways to get data of the reports from salesforce to a Custom Web portal developed using php. Found a way of doing this using CURL extention of php. So Below are the steps ..
1.) Enable PHP_CURL in your php instalations.
2.) Create code for connecting to your instance as per my previous blog.
$result = $client->login($username, $password);$client->sessionId = $result[‘sessionId’]; 
3.) Get the report ID from your instance using a webservice method in APEx
WebService string FindReport(string ReportName)
{
List reports = [Select Id, Name from Report Where Name = :ReportName];
if (reports == null || reports.size() == 0) return null;
PageReference pageRef = new PageReference(‘/’ + reports[0].Id);
Blob ReportBlob = pageRef.getContent();
return ReportBlob.toString();
}Thanks to David

4.)Define the URL to hit
$url = “https://na1.salesforce.com“;
$reportUrl = $url.”/”.$reportId.”?export=1&enc=UTF-8&xf=csv”;
5.) Initialize CURL
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, $reportUrl);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
// Not doing any verification of SSL certificates
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);
curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, 0);
curl_setopt($ch, CURLOPT_COOKIE, ‘sid=’.$client->sessionId);
setcookie(“sid”, $client->sessionId, 0, “/”, “.salesforce.com”, 0);
curl_setopt($ch, CURLOPT_TIMEOUT, 30);
$result = curl_exec ($ch);
curl_close ($ch);
$result is a XML of data now you can parse it using SimpleXMl library of php


Source : http://www.saasanalogy.com/getting-reports-from-salesforce-to-custom-portal-using-php/

Comments

Post a Comment

Popular posts from this blog

Salesforce.com: Expression Operators in Salesforce lightning Components

Image
Generally In every component implementation we have a need to  change the UI conditionally, or show/hide a section/column based on certain conditions. We need simple ways to do this instead of having every handler in code. Below are key operators and their syntax to handle any such situation Ternary Operator This expression uses the ternary operator to conditionally output one of two values dependent on a condition. 1 <a class="{!v.location == '/active' ? 'selected' : ''}" href="#/active">Active</a> The {!v.location == ‘/active’ ? ‘selected’ : ”} expression conditionally sets the class attribute of an HTML <a> tag, by checking whether the location attribute is set to /active . If true, the expression sets class to selected . Using <aura:if> for Conditional Markup <aura:attribute name="edit" type="Boolean" default="true"/> <aura:if isTrue=&qu
Read more

Custom Calendar on VisualForce Page

Image
There has always been a need to have a calendar component for visualforce page this kind of component can be used in events booking,events calendar,scheduling requirements and all the places where we need to show events by dates. This can be easily implemented using jquery,fullcalendar plugin and json in apex. So what we need here is 1.) Fullcalandar plugin  Download 2.) A custom object with start dates and end dates for events 3.) Apex class to pull data from object and convert that into json using json.serailze First we have to upload the fullcalendar lib to static resource and then we have to create a visualforce page with below code. The important thing is "JSONOFLIST" which is just json created from list of records by using JSONOFLIST = JSON.serialize(LIST OF SOBJECT); It will give you a calendar with items highlited on page Source : http://www.saasanalogy.com/custom-calendar-on-visualforce-page/
Read more

Salesforce.com: Scheduled Apex

The Apex Scheduler lets you delay execution so that you can run Apex classes at a specified time. This is ideal for daily or weekly maintenance tasks using Batch Apex. To take advantage of the scheduler, write an Apex class that implements the Schedulable interface, and then schedule it for execution on a specific schedule. Scheduled Apex Syntax To invoke Apex classes to run at specific times, first implement the Schedulable interface for the class. Then, schedule an instance of the class to run at a specific time using the System.schedule method. global class SomeClass implements Schedulable { global void execute(SchedulableContext ctx) { // awesome code here } } The class implements the Schedulable interface and must implement the only method that this interface contains, which is the execute method. The parameter of this method is a SchedulableContext object. After a class has been scheduled, a CronTrigger object is created that represents the scheduled job. It p
Read more