Export a list and include the URL to the record?

Jared Wason · ‎04-26-2022

Hello,

I am trying to export a list of incidents to excel and I would like for the export to have a link to the record. Currently, I am filtering my list and then adding '&EXCEL&sysparm_default_export_fields=all' to the URL to export. Then in Excel, I am able to craft a URL via the sys_id and a generic incident link, however, this is cumbersome. Is it possible to export a list with the URL already available? If that is not possible, is it possible to export the sys_id directly instead of using 'sysparm_defaul_export_fields=all'? That adds every column which makes the Excel page very cluttered and requires additional clean-up.

Thanks!

Filipe Cruz · ‎04-27-2022

Hi Jared,

I found this solution that will work better for you:

https://developer.servicenow.com/blog.do?p=/post/exporting-data-with-sys-ids/

For example, if you want to export all fields from your incident table, you can use the following url:

https://instance.service-now.com/incident_list.do?CSV&sysparm_default_export_fields=all

(replace instance by your instance name)

If you want to exporto only a couple of fields, replace the sysparm_default_export_fields=true by sysparm_fields=<comma-separated list of fields>.
As example, if you want to export sys_id, name and short description, you use the following url:

https://instance.service-now.com/incident_list.do?CSV&sysparm_fields=sys_id,number,short_description

And the result will be like this:

I think this is what you need!

Please, don't forget to mark my answer as correct if it solves your issue or mark it as helpful if it is relevant for you!

Best Regards,

Filipe Cruz

View solution in original post

GregJWillis · ‎05-03-2023

I tried creating a URL type field and made it Calculated with this script:

(function calculatedFieldValue(current) {

// Link back to this record
return 'https://'+gs.getProperty('instance_name')+'.service-now.com/nav_to.do?uri=' + current.sys_class_name + '.do?sys_id=' + current.sys_id+'';
})(current);

When this 'field' was exported it worked great. PDF liked it...clickable right away. XLS however needed to have the 'text' touched, and it then recognized it as a link that turned it blue to click. Maybe others with XLS KB could help here.