function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
DuodouDuodou 

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!

 

 

Ispita_NavatarIspita_Navatar

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.