Download report via URL

NeXTer
Tera Contributor

Apologies if this has been answered before, but I couldn't find quite the scenario I have.

 

Before the introduction of the new Platform Analytics module I created several reports in the old module that I use with an integration solution. These reports could be very easily downloaded using curl with an URI formatted as https://<servicenow_instance>/sys_report_template.do?XLSX&jvar_report_id=<report_id>.

 

Now when I went to create additional reports, I ended up in the PA module where I after the initial surprise was able to easily create the new report that I needed, but I am completely stumped when it comes to downloading the report via an URI using curl.

 

I tried the old format which still works for the pre-PA reports, but I get a blank page when I try with the id of the new report.

 

How should I format the URL to directly download the content of PA reports?

1 REPLY 1

NeXTer
Tera Contributor

After several agonising months, it was revealed to me that the Report Admin privilege granted access to the old report creation tool. Creating a new report could be done by directly accessing https://<servicenow_instance>/sys_report_template.do?jvar_report_id=undefined.

 

Once created, opening the report from the PA workspace opened it in the old report tool.

 

In order to edit old reports that were automatically converted but hadn't been altered, they could be edited in the report tool by using https://<servicenow_instance>/now/nav/ui/classic/params/target/sys_report_template.do%3Fjvar_report_id%3D<reportid> (the escaped characters are needed).