Exporting all fields from a list

[Rick Seiden]

I am trying to export all fields in a set of records from a list of records that doesn't contain all the fields. According to the wiki (http://wiki.servicenow.com/index.php?title=Exporting_Data) I should be able to do this by "setting the sysparm_default_exported_fields parameter to all." So I tried going to

https://.service-now.com/core_company_list.do?CSV&sysparm_default_exported_fields=all

to export all the fields in the Company table. But it only exports those fields showing in the list.

Is there any way to make it export all the fields in the records, not just the ones shown in the list, or do I have to put all the fields in the list, and then export the list?

Thank you,
Rick

PS: I know it's not about Importing, but that was as close as I could get in the Topic.

[Marcus Fly]

I was able to confirm your findings using "sysparm_default_exported_fields=all", "sysparm_default_exported_fields=ALL", and "sysparm_default_exported_fields=true", all 3 did not export out all fields as documented here:

http://wiki.servicenow.com/index.php?title=Exporting_Data#Determining_Which_List_Fields_are_Exported

I am on Dublin and get the columns in my list in multiple browsers agains multiple tables using CSV and EXCEL formats. I would suggest opening a ticket at this point for further investigation.

[Rick Seiden · Accepted solution]

I opened a ticket in HI, and found out it was a typo in the wiki. The correct parameter is

sysparm_default_export_fields=all

not exported, but export. This makes the full URL to export all fields of the Company table:

https://demo09.service-now.com/core_company.do?CSV&sysparm_default_export_fields=all

Rick

[Vaughn Romero]

I updated the wiki to use the proper parameter name. See Exporting Data.

[nidhiprashnani]

hello ,

I am not sure but this does not work for me. Nothing is happening . Its just giving me blank page with no downloading file

https://myinstancename.service-now.com/core_company.do?EXCEL&sysparm_default_export_fields=all

Not sure of the reason,