CSV export to show choice values instead of labels.

Rocky5
Kilo Sage

Hello Guys,

 

When I export an incident record in csv format, For choice fields the exported data is showing choice labels but I want to see choice values. For example, 'Category' field has a choice called 'Audio/Visual' as label and value as 'audio_visual'. So, when I export the incident record in csv format I am seeing as below but I want to see 'audio_visual' instead of 'Audio/Visual'. is it possible? If so how can I achieve that?

Rocky5_1-1687129545746.png

 

Thanks,

Rocky.

 

3 REPLIES 3

Prateek kumar
Mega Sage

Hi Prateek,

 

Sorry I did not get you. How can I make choice values instead of choice labels when I export data in csv format.?

 

Thanks,

Rocky.

You can export directly using URL. 

Please read thru the docs on how to build an encoded query apply to the below URL and you should have the CSV export ready

 

https://YourIntanceName.service-now.com/incident_list.do?CSV&sysparm_display_value=false

https://docs.servicenow.com/bundle/utah-platform-administration/page/administer/exporting-data/task/...


Please mark my response as correct and helpful if it helped solved your question.
-Thanks