Screenshot_2_12_14_2_23_PM

I am so excited, that I am almost giddy. If you knew me well, you would know that this is not a very common state of mind for me. I am a pretty rational and calm guy. However, I overheard some chatter within the ServiceNow communities and learned that there is a new option with the ServiceNow export feature that allows you to get all field that I use with a CSV export.

For years, if you performed a CSV export you would only get fields that were exposed on the list view for that table. There were special parameters that allowed you to use a list view to get different fields than what existed on the default list view. However, there was no way to export the sys_id field off of that table. The community forest with lots of creative solutions to get the sys_id field, but no out-of-the-box solution allows you to get it from the table itself.

I have just learned that with the Dublin release you can now pull the sys_id field along with all the other fields by adding the following URL parameter: 

sysparm_default_export_fields=all

So, if I wanted to export incidents from my incident table, my Request URL might look like the following:

https://myinstance.service-now.com/incident.do?CSV&sysparm_default_export_fields=all

I have tried this out personally, and found it to work splendidly. It is exciting to finally see this simple enhancement request, to life! Many thanks to my ServiceNow colleagues who brought this to my attention. Many more things to the development team who got us into the product.