Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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
  • 3,218 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/