[SalesForce] custom direct link to download/export reports in one click in lightning

Is there a link that allows you to directly download a report in LEX (lightning experience) using a single link?

In classic, I would use https://org.my.salesforce.com/report_id?view=d&snip&export=1&enc=UTF-8&xf=csv, where the report_id would be the report ID.

For some context, I have a python script that looks through a list of report IDs to download on a monthly basis. However switching to LEX only opens the link and does not download it directly. I've tried manipulating the lightning URL but it still only opens up the page and doesn't download it.

(i.e. https://org.lightning.force.com/one/one.app#/sObject/report_id/view?export=1&enc=UTF-8&xf=csv)

Thanks for all your help everyone, it's greatly appreciated!

Best Answer

Try appending the isdtp=p1parameter to your URL.

We use a URL similar to the below one for extracting reports in CSV format:

/YOUR_REPORT_ID?csv=1&exp=1&enc=UTF-8&isdtp=p1

Before migrating to Lightning we used a similar link but we had the isdtp=mn set, which stopped working after the migration. Simply changing this parameter to isdtp=p1 made it work both in Classic and Lightning.

Related Solutions

[SalesForce] (Properly) Link to custom Lightning App from record detail page

This works in a URL button, although it sometime gives a warning "We'd like to open the Salesforce page https://[myDomain].lightning.force.com... in a new tab. Because of your browser settings, we need your permission first."

/c/OppAwesomizer.app#{!Opportunity.Id}

[SalesForce] Generating Custom Reports via Custom Link

You need to create a lightning controller with the component and use the force:navigateToURL event: https://developer.salesforce.com/docs/atlas.en-us.lightning.meta/lightning/ref_force_navigateToURL.htm

Say you have a component that has a link:

<a href="<some url>">My Report</a>

Drop the href and pass and onclick handler to it

<a href="" onclick="{!c.goToReport}">My Report</a>

Now handle the event in the controller and call the navigate to url event

goToReport: function(component, event, helper) {
    var urlEvent = $A.get("e.force:navigateToURL");
    urlEvent.setParams({
      "url": "<report url path with query params>"
    });
    urlEvent.fire();
}

Best Answer

Related Solutions

[SalesForce] (Properly) Link to custom Lightning App from record detail page

[SalesForce] Generating Custom Reports via Custom Link

Related Topic