Exporting Sys id in place of reference field 'Display value'

Naresh27
Tera Guru

‎04-30-2018 01:56 PM

While exporting list of active incidents in excel, I need Caller sys_id in place of caller Display value. the use case is same with Assigned to and Assignment group.

Can we able to export reference fields with sys id's.

 

Thanks

Labels:
0 Helpfuls
  • 2,904 Views
5 REPLIES 5

Community Alums
Not applicable

‎09-01-2021 02:57 AM

Hi Naresh,

I'm not sure if you still need this 🙂 but I guess it might be able for the others.

Let's say you'd like to get report on incidents with sys_id of the locations they were reported on.

You'd add this line at the end of URL:

&sysparm_fields=sys_id,number,location,location.sys_id

You would get a list wit incident's sys_id, it's number, location's display name and location's sys_id.

 

For more info on the topic you can go here:

https://lemeaow.wordpress.com/2018/09/14/exporting-configuration-item-sys_id-and-reference-field-sys_id-in-servicenow-csv-export/