CSV export to show choice values instead of labels.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2023 04:05 PM
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?
Thanks,
Rocky.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2023 05:24 PM
Try below:
https://YourIntanceName.service-now.com/incident_list.do?CSV&sysparm_display_value=false
Please mark my response as correct and helpful if it helped solved your question.
-Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-18-2023 06:04 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-19-2023 07:31 AM
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
Please mark my response as correct and helpful if it helped solved your question.
-Thanks