The Art of URL Hacking in Salesforce : Part V — Report Export/Download
In my previous article I had explained how one can use Salesforce URL Hacks to Preview & Download Files.
If you haven’t read that yet, I would really encourage you to take the time to read once.
In this Article, I’ll explain how you can use URL Hacks to directly Download Reports in both Formatted Report Format & Details only Format.
For those of you, who are new to Salesforce Reports, here’s a bit of introductory information.
Salesforce offers two ways to Export your Reports
- Formatted Report Format : exports the report as it appears in Salesforce, with the report header, groupings, and filter details. Because formatting is retained, you can’t choose an encoding and the only supported formatted export file type is
.xlsx. - Details only Format : exports each detail row without formatting and is useful for doing further calculations in a spreadsheet.
You can go ahead and read more about Report Exporting & related Limitations on the Salesforce Docs using the link mentioned below.
A] Downloading Reports in Formatted Report Format — XLSX Document
You can use the following URL Hack to Download Reports directly in Formatted XLSX Format.
/servlet/PrintableViewDownloadServlet?isdtp=p1&reportId=<ReportId>For E.g.
/servlet/PrintableViewDownloadServlet?isdtp=p1&reportId=00O2x000004Ee6rEAC
B] Downloading Reports in Details Only Format — CSV Document
You can use the following URL Hack to Download Reports directly in Details Only CSV Format.
/<ReportId>?isdtp=p1&csv=1For E.g.
/00O2x000004Ee6rEAC?isdtp=p1&csv=1
I hope you enjoyed this article 📖 & found it insightful! 🔍!
Do hit the clap button👏 if you liked the article & leave a comment✍ if you have any queries/suggestions.
Enjoying the content? Don’t miss out on my future posts! Hit ‘Follow’ button to be the first to know about my new publications 🔔. Can’t wait to share more! 🚀🎉
Thanks for reading!
