Breaking up large files due to export limit
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2021 03:40 PM
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:
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2021 03:58 PM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-22-2021 04:15 PM
%3DXML&sysparm_orderby=sys_id&sysparm_record_count=10000
change to
%3FXML&sysparm_orderby=sys_id&sysparm_record_count=10000