Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

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
Giga 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