• Vihar Somani
  • NEWBIE
  • 0 Points
  • Member since 2020

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies
Hi All,

I am exploring the possibilities with the reports and metadata. However I didn't find anything about deploy reports into salesforce
I have tried something similar to deploy apexclasses, although it doesn't work...

APEX CLASS:


MetadataService.MetadataPort service = createService();                               
 
 MetadataFiles = new List<MetadataFile>();
 MetadataFile metaDataFile = new MetadataFile();
        metaDataFile.fullName = 'MyReportFolder/MyNewReportMetadata';
        metaDataFile.content = '<?xml version="1.0" encoding="UTF-8"?>' +
        '<Report xmlns="http://soap.sforce.com/2006/04/metadata">' +
            '<chart>' +
                '<backgroundColor1>#FFFFFF</backgroundColor1>' +
                '<backgroundColor2>#FFFFFF</backgroundColor2>' +
                '<backgroundFadeDir>Diagonal</backgroundFadeDir>' +
                '<chartSummaries>' +
                    '<axisBinding>y</axisBinding>' +
                    '<column>RowCount</column>' +
                '</chartSummaries>' +
                '<chartType>HorizontalBar</chartType>' +
                '<enableHoverLabels>false</enableHoverLabels>' +
                '<expandOthers>true</expandOthers>' +
                '<groupingColumn>Contact$Id</groupingColumn>' +
                '<location>CHART_TOP</location>' +
                '<showAxisLabels>true</showAxisLabels>' +
                '<showPercentage>false</showPercentage>' +
                '<showTotal>false</showTotal>' +
                '<showValues>false</showValues>' +
                '<size>Medium</size>' +
                '<summaryAxisRange>Auto</summaryAxisRange>' +
                '<textColor>#000000</textColor>' +
                '<textSize>12</textSize>' +
                '<titleColor>#000000</titleColor>' +
                '<titleSize>18</titleSize>' +
            '</chart>' +
            '<columns>' +
                '<field>Contact$Id</field>' +
            '</columns>' +
            '<columns>' +
                '<field>Contact$Name</field>' +
            '</columns>' +
            '<columns>' +
                '<field>Contact$Email</field>' +
            '</columns>' +
            '<columns>' +
                '<field>Contact$Phone</field>' +
            '</columns>' +
            '<description>My test report metadata</description>' +
            '<filter>' +
                '<criteriaItems>' +
                    '<column>Contact$Name</column>' +
                    '<operator>start with</operator>' +
                    '<value>p</value>' +
                '</criteriaItems>' +
            '</filter>' +
            '<format>Summary</format>' +
            '<groupingsDown>' +
                '<dateGranularity>Day</dateGranularity>' +
                '<field>Contact$Id</field>' +
                '<sortOrder>Asc</sortOrder>' +
            '</groupingsDown>' +
            '<name>MyNewReportMetadata</name>' +
            '<params>' +
                '<name>co</name>' +
                '<value>1</value>' +
            '</params>' +
            '<reportType>Goals__c</reportType>' +
            '<scope>team</scope>' +
            '<showDetails>true</showDetails>' +
            '<timeFrameFilter>' +
                '<dateColumn>Contact$CreatedDate</dateColumn>' +
                '<interval>INTERVAL_CUSTOM</interval>' +
            '</timeFrameFilter>' +
        '</Report>';
  MetadataFiles.add(metaDataFile);
  metaDataFile = new MetadataFile();
        metaDataFile.fullName = 'package.xml';
  metaDataFile.content = '<?xml version="1.0" encoding="UTF-8"?>' +
        '<Package xmlns="http://soap.sforce.com/2006/04/metadata">' +
            '<types>' +
                '<members>MyReportFolder/MyNewReportMetadata</members>' +
                '<name>Report</name>' +
            '</types>' +
            '<version>29.0</version>' +
        '</Package>';
        MetadataFiles.add(metaDataFile);



Any idea?
Thanks in advance,
Pablo