Export All Data and All Fields From a Table

[jmiskey]

I thought I did this once a few years ago, but my searches have been fruitless thus far.  I wish to export an ENTIRE table from ServiceNow to Excel.  So I want ALL data records and ALL fields exported (including fields like sys_id) to Excel. 

All the instructions I find on-line show you how to export from a Report or a List View.  This is no good, as I want EVERY field in the table included in the data export.  I am pretty sure that there is a trick to doing this, and I did it some years ago, but I cannot remember how.  The number of records should not be an issue, as there are under 100 records in this table.  There is just a lot of fields in the table (128 to be exact).

Thanks

[Dr Atul G- LNG]

Hi @jmiskey 

May be this will helpful

https://www.servicenow.com/community/itsm-forum/how-to-export-table-columns-data-to-excel-or-csv/m-p...

https://www.servicenow.com/community/itsm-forum/exporting-all-fields-from-a-list/m-p/503745

[Amit Gujarathi · Accepted solution]

Hi @jmiskey ,
I trust you are doing great.

By the help of “sysparm_default_export_fields=all” parameter , Sys ID can be exported.
This parameter tells the web service to export all fields from the table including the Sys ID. Beware that this also brings every other field along with it.

Steps:

1. Navigate to the list of records.
https://<instance>.service-now.com/problem_list.do?

2. Build your filter (If required as per business need)

https://<instance>.service-now.com/incident_list.do?sysparm_query=active (I have applied filter as Active is TRUE)

3. Copy URL and place into new browser window and Add &CSV&sysparm_default_export_fields=all to the end of the URL
https://<instance>.service-now.com/incident_list.do?sysparm_query=active&CSV&sysparm_default_export_fields=all

4. Press Enter
5. A CSV file with all fields including sys_id will get exported.

[jmiskey]

Thank you all!  That works perfectly!