You need to sign in to do that
Don't have an account?
Duodou
How to to get report column API name?
Hi Simon,
I am wondering if you could me help out this one:
How to get report column's api name? From sample xml that the help doc provides(http://www.salesforce.com/us/developer/docs/api_meta), I can see the columns node contains actual field api name:
<columns>
<field>CRT_Object__c$Name</field>
</columns>
But from the zip file I retrieved following your ,net sample code http://www.pocketsoap.com/weblog/category/_net.htm l,, I don't see api name for the column. Here is sample of report meta data I got:
<?xml version="1.0" encoding="UTF-8"?>
<Report xmlns="http://soap.sforce.com/2006/04/metadata">
<columns>
<field>SALUTATION</field>
</columns>
<columns>
<field>FIRST_NAME</field>
</columns>
<columns>
<field>LAST_NAME</field>
</columns>
<columns>
<field>TITLE</field>
</columns>
<columns>
<field>ADDRESS2_STREET</field>
</columns>
<columns>
<field>ADDRESS2_CITY</field>
</columns>
<columns>
<field>ADDRESS2_STATE</field>
</columns>
<columns>
<field>ADDRESS2_ZIP</field>
</columns>
<columns>
<field>ADDRESS2_COUNTRY</field>
</columns>
<columns>
<field>PHONE1</field>
</columns>
<columns>
<field>PHONE3</field>
</columns>
<columns>
<field>PHONE2</field>
</columns>
<columns>
<field>EMAIL</field>
</columns>
<columns>
<field>OWNER_FULL_NAME</field>
</columns>
<columns>
<field>ACCOUNT.NAME</field>
</columns>
<description>This is just a test!</description>
<format>Summary</format>
<groupingsDown>
<dateGranularity>Day</dateGranularity>
<field>CONTACT_ID</field>
<sortOrder>Asc</sortOrder>
</groupingsDown>
<name>Test 2009</name>
<reportType>ContactList</reportType>
<scope>my</scope>
<showDetails>true</showDetails>
<timeFrameFilter>
<dateColumn>CREATED_DATE</dateColumn>
<interval>INTERVAL_CUSTOM</interval>
<startDate>2009-05-10</startDate>
</timeFrameFilter>
</Report>
Could you please point me out how to get column's API name? Thanks a lot!
We had developed an ORG comparison tool based on metadata API and there we were required to give a summary about reports in the org so for too we had use functions of metadata API, but it was a DOT net based third party tool.