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.

Breaking up large files due to export limit

Tanisha Hudson
ServiceNow Employee
ServiceNow Employee

I wish to export some data from an instance. The data that I search for returns about 13,000 rows. The .csv threshold limit is only 10,001. How could I extract all the data in chunks? I followed the tutorial, but do not have a solution as this is not working for me.

 

 

This is my output when I filter:

find_real_file.png

 

 

This is the url from that output:

 

https://capman.service-now.com/nav_to.do?uri=%2Fx_snc_instance_int_dc_cmdb_ci_file_system_snap_list.do%3Fsysparm_query%3Dimport_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()%5EnameSTARTSWITHfb%5EORname%3D%2Fdev%2Fmapper%2Fbackupvg-backuplv%5Emount_point!%3D%2Fbackup_rada%26sysparm_first_row%3D1%26sysparm_view%3DXML

 

This returns 13,169 rows.

According to the documentation, I can do this:

 

https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_orderby=sys_id&sysparm_record_count=10000

 

This is what I have done, I have included

 

 

https://capman.service-now.com/nav_to.do?uri=%2Fx_snc_instance_int_dc_cmdb_ci_file_system_snap_list.do%3Fsysparm_query%3Dimport_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()%5EnameSTARTSWITHfb%5EORname%3D%2Fdev%2Fmapper%2Fbackupvg-backuplv%5Emount_point!%3D%2Fbackup_rada%26sysparm_first_row%3D1%26sysparm_view%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000 

 

I have added: &sysparm_orderby=sys_id&sysparm_record_count=10000 to the end of my url, and hit enter. The  output remains the same.

 

Any suggestion is appreciated

 

 

 

6 REPLIES 6

Thank you, I was advised not to increase the limit.

How could I solve this without increasing limit please?

This is what I am doing to break this into chunks:

 

 

https://capman.service-now.com/nav_to.do?uri=%2Fx_snc_instance_int_dc_cmdb_ci_file_system_snap_list.do%3Fsysparm_query%3Dimport_dateONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()%5EnameSTARTSWITHfb%5EORname%3D%2Fdev%2Fmapper%2Fbackupvg-backuplv%5Emount_point!%3D%2Fbackup_rada%26sysparm_first_row%3D1%26sysparm_view%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000 

 

SNUG AM
Tera Guru

%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000 

 change to

%3FXML&sysparm_orderby=sys_id&sysparm_record_count=10000