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

[Naresh27]

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

[Community Alums]

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/