logo

NJP

← Back to News

How to export filtered list view with all fields including sys_id to EXCEL

Import · Nov 06, 2020 · article

To export data we need to build url

1) Just use Filter menu to Copy URL

- example URL

https://devxxx.service-now.com/cmdb\_ci\_list.do?sysparm\_query=manufacturer%3Daa0a6df8c611227601cd2ed45989e0ac&sysparm\_view=

2) Modify URL with export parameters:

https://devxxx.service-now.com/cmdb\_ci\_list.do?**EXCEL&**sysparm\_query=manufacturer%3Daa0a6df8c611227601cd2ed45989e0ac&sysparm\_view=**&sysparm\_default\_export\_fields=all**

Done

Just keep in mind that typically there are properties in ServiceNow which don't allow to export for example more than 10 000 records.

View original source

https://www.servicenow.com/community/now-platform-articles/how-to-export-filtered-list-view-with-all-fields-including-sys/ta-p/2314960