Skip to main content

Exporting Sysids to a spreadsheet (CSV web service)

Exporting Sysids to a spreadsheet (CSV web service)

really useful post on how to get sysids added as a column to a CSV export (CSV web service)
https://developer.servicenow.com/blog.do?p=/post/exporting-data-with-sys-ids/


in a nutshell:

- edit the system property

SYSPARM_DEFAULT_EXPORT_FIELDS

to add in the sys id column, or just add as a parameter to the URL like so:
https://instance.service-now.com/incident_list.do?CSV&sysparm_default_export_fields=all

- fire the URL at the instance, e.g. 'active tickets where vendor = <a vendor>', examples:
https://instance.service-now.com/incident.do?CSV&sysparm_query=priority=1^active=true

https://instance.service-now.com/incident.do?CSV&sysparm_default_export_fields=all&sysparm_query=priority=1^active=true

 https://instance.service-now.com/incident.do?CSV&CSV&sysparm_default_export_fields=all&sysparm_query=active=true^u_vendor=91c6f451371e420041c5616043990eee
this format seems to work also without editing the sys properties:
https://<instance>.service-now.com/incident.do?CSV&sysparm_query=u_vendor=91c6f451371e420041c5616043990eee&sysparm_fields=number,sys_id,correlation_display,correlation_id,u_vendor,u_vendor_group,u_vendor_reference_number


example on sys_choice table:

https://<instance>.service-now.com/sys_choice.do?CSV&sysparm_query=name=problem^ORname=problem_task^element=state^inactive=false&sysparm_fields=name,sys_id,label,value




Labels:

Comments

  1. tradeimexinfo2 July 2021 at 04:46

    You have done good work by publishing this article here. I found this article too informative, and also it is beneficial to enhance our knowledge. Grateful to you for sharing an article like thischina export data

    ReplyDelete
  2. tradeimexinfo20 August 2021 at 21:58

    Excellent post. I really enjoy reading and also appreciate your work. This concept is a good way to enhance knowledge. Keep sharing this kind of articles, Mexico Export Data. Thank you.

    ReplyDelete
  3. tradeimexinfo29 November 2021 at 11:21

    This post is so useful and valuable to increase our knowledge. I am happy that you have shared great info with us. Grateful to you for sharing an article like this. Vietnam Export Data

    ReplyDelete
  4. fab21 June 2024 at 12:06

    do not work anymore

    ReplyDelete

Post a Comment

Popular posts from this blog

ServiceNow check for null or nil or empty (or not)

Haven't tested these all recently within global/local scopes, so feel free to have a play! option 1 use an encoded query embedded in the GlideRecord , e.g.  var grProf = new GlideRecord ( 'x_cls_clear_skye_i_profile' ); grProf . addQuery ( 'status=1^ owner=NULL ' ); grProf . query (); even better use the glideRecord  addNotNullQuery or addNullQuery option 2 JSUtil.nil / notNil (this might be the most powerful. See this link ) example: if ( current . operation () == 'insert' && JSUtil . notNil ( current . parent ) && ! current . work_effort . nil ())  option 3 there might be times when you need to get inside the GlideRecord and perform the check there, for example if the code goes down 2 optional routes depending on null / not null can use gs.nil : var grAppr = new GlideRecord ( 'sysapproval_approver' ); var grUser = new GlideRecord ( 'sys_user' ); if ( grUser . get ( 'sys_id' , current . approver )){...
Post a Comment
Read more

Code a pause/wait - gs.sleep or gs.wait alternative, pause script for specified seconds (timer)

Code a pause/wait - gs.sleep / gs.wait alternative, pause script for specified seconds (timer)  e.g. 10 seconds: do_sleep ( 10000 ); function do_sleep ( milliseconds ) { var start = new Date (). getTime (); for ( var i = 0 ; i < 1e7 ; i ++) { if (( new Date (). getTime () - start ) > milliseconds ){ gs . print ( 'waking up!' ); break ; } } }
Post a Comment
Read more