+ Start a Discussion
GaneeeshGaneeesh 

how to retrieve all reports meta data using workbench..?

Can anybody help me how to retrieve all reports meta data using workbench..?. please send me xml code. Here I am using this xml code but its not working porperly.

<?xml version="1.0" encoding="UTF-8"?>
<Package xmlns="http://soap.sforce.com/2006/04/metadata">
<types>
<members>*</members>
  <members>Reportname</members>
<name>Report</name>
</types>
  <version>24.0</version>
</Package>
RamuRamu (Salesforce Developers) 
As per the below article, you can’t use the wildcard (*) symbol with reports in package.xml.

Follow the guidelines explained in the article below

https://www.salesforce.com/us/developer/docs/api_meta/Content/meta_report.htm
SAKTHIVEL MSAKTHIVEL M
Hi All,

Here is alternative way to retrieve all reports.

You can’t use the wildcard (*) symbol to retrieve all reports in package.xml,

query all your reports in your report object (SELECT Name, DeveloperName, FolderName FROM Report) using Workbench/Developer Console and form it in your package.xml

Refer:
http://theblogreaders.com/retrieve-unfiled-public-reports-using-salesforce-package-xml/


Thanks & Regards,
Sakthivel Madesh
Brian Watts 12Brian Watts 12
There seems to be a number of times when the wildcard is approved, and other times when it's non-functional. Is there an authoritative resource, or tooling available that can generate a perfect manifest?

I've had some success with Ben Edward's "toolkit for salesforce", but was wondering if there's official tooling
Rachel BeachRachel Beach
Sakthivel, that was a hugely helpful reference, thank you! I finally got to back up my reports. One question---do you know how to handle situations where the folder containing the report has an ampersand in it? I believe I got a failure when I left it in and got 0 results when I replaced it with &amp;

Thanks!
Stijn VermeulenStijn Vermeulen
@Rachel Beach, probably too late, but answering it for future readers.
You have to use the developer name to retrieve the reports, and the developer name should not contain an ampersand.
Rachel BeachRachel Beach
I actually ended up installing an extension in VS Code called Salesforce Package.xml Generator Extension for VS Code (https://marketplace.visualstudio.com/items?itemName=VignaeshRamA.sfdx-package-xml-generator) which has worked great. You can use it to generate package.xml from your metadata and you can choose which types of components to include. It generates a full list of corrrectly formatted reports and dashboards. It's been great!