How to export reports directly from the URL

Yuki33
Tera Contributor

‎12-19-2019 07:17 PM

regarding Export directory from the URL, I am trying to download the report, but it does not work.

(blank csv file is downloaded)

https://<instance>/incident_list.do?CSV&sysparm_query=priority=1  - -> it works.

https://<instance>/sys_report_display.do?CSV&sysparm_report_id=<report id>  --> not work. blank csv

Is it possible to download reports via URL?

if yes, please share us how to enable it.

 

Thanks

 

0 Helpfuls
  • 4,587 Views
3 REPLIES 3

Mike Patel
Tera Sage

‎12-19-2019 07:23 PM

Yes, you can.

/sys_report_template.do?CSV&jvar_report_id=

Harsh Vardhan
Giga Patron

‎12-19-2019 07:31 PM

Yes , You can. 

 

try with below url. 

 

http://<Yourinstance id >.service-now.com/sys_report_template.do?CSV&jvar_report_id=your report id 

 

If i answered your query , kindly mark it as correct.

 

 

Christian Peder
Kilo Contributor
In response to Harsh Vardhan

‎03-10-2020 11:22 AM

This works great by the looks of it.

Was wondering... Is there a way to have Excel fetch this data automatically?
I tried via a webquery and no luck, I get stuck on the credentials part considering we are using SSO.

Was thinking I can code in that it downloads the file via a browser and pulls it in from the downloaded file but would of course be easier to just be able to fetch the data directly from that url.

Best regards

Christian

0 Helpfuls