Hi,

We want to fetch standard report data in apex so we are using following approach but we are just getting 1st column of standard report data.
How can we get all standard report data in apex?

Our approach:

Step -1

<Salesforce instance>/servlet/servlet.ReportList

From above link we are getting list of all reports with their report id and url.

Step - 2
sample response:

<result>
<report foldername="My Personal Custom Reports" name="Contact-Account Report">
<id><ID></id>
<url>
<![CDATA[ <ID>?isExcel=1 ]]>
</url>
<isPublic>false</isPublic>
</report>
<report foldername="Administrative Reports" name="All Active Users">
<url>
<![CDATA[
/00O?rt=32&retURL=%2Fservlet%2Fservlet.ReportList&t=active&c=FN&c=LN&c=RO&c=PR&c=UN&c=LL&duel0=FN%2CLN%2CRO%2CPR%2CUN%2CLL&details=yes
]]>
</url>
<description>Who are the active salesforce.com users?</description>
</report>
</result>

From above response we are just fetching "All Active Users" report url i.e

/00O?rt=32&retURL=%2Fservlet%2Fservlet.ReportList&t=active&c=FN&c=LN&c=RO&c=PR&c=UN&c=LL&duel0=FN%2CLN%2CRO%2CPR%2CUN%2CLL&details=yes

This url we are appending with &export=1&enc=UTF-8&xf=csv, by using this we can download file in csv form.

step -3
We are using following code to fetch standard report("All Active Users") data.

PageReference page = new PageReference('/00O?rt=32&retURL=%2Fservlet%2Fservlet.ReportList&t=active&c=FN&c=LN&c=RO&c=PR&c=UN&c=LL&duel0=FN%2CLN%2CRO%2CPR%2CUN%2CLL&details=yes&export=1&enc=UTF-8&xf=csv'); 
system.debug('response data=='+page.getContent().toString());

When we are executing above code then in response we are just getting 1st column data.
You can see column names in above url whose parameter name is "&c". In above case 1st parameter column name is &c=FN so I am just getting "FN" data.

If we are trying above url directly in browser then we are getting csv file with all data but in pageReference we are just getting 1st column data.
If we are removing all column parameter i.e "&c" param then in pageReference code we are getting all data for all columns but We don't want that because we want selected column data.

Instead of pageReference we have also tried with Http callout but there we are getting authentication failure.
We have also added session Id but facing with authentication failure.

How can we fetch standard report data in apex?

Thanks,
Rupali