How to export reports directly from the URL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-19-2019 07:23 PM
Yes, you can.
/sys_report_template.do?CSV&jvar_report_id=
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
