How to Downlaod large count of records in a single file

SivaprasadV
Tera Expert

In servicenow I have created a custom table. User insterted more than 10 lakh line items. Now I want to download all the records in one file. How can I do that.

 

13 REPLIES 13

hey @SivaprasadV 

 

Hope you are doing well.

Did my previous reply answer your question?

If it was helpful, please mark it as correct ✓ and close the thread . This will help other readers find the solution more easily.

 

Thankyou & Regards

Vaishali Singh

Servicenow Developer
Linkedin - https://www.linkedin.com/in/vaishali-singh-2273361bb







yashkamde
Mega Sage

Hello @SivaprasadV ,

 

Navigate on List Layout set the filter you want and above in the url append this line at the LAST :

 

https://devxxxxxx.service-now.com/now/nav/ui/classic/params/target/incident_list.do%3Fsysparm_query%...&CSV&sysparm_default_export_fields_all=true

&CSV&sysparm_default_export_fields_all=true

 

Screenshot 2026-06-17 124841.png

 

This will download your records in large formats..

 

If my response helped mark as helpful and accept the solution.

Aditya_hublikar
Giga Sage

Hello @SivaprasadV ,

 

try this :

4)&CSV&sysparm_default_export_fields=all

When you try to export records at that time sys_id will not get export by default if we want to get that sys_id also at that time you can use above parameters 

steps: 1)navigate to target table

2)add filter to get only required records

3)simply add this &CSV&sysparm_default_export_fields=all in your url  , press enter ,   then records with their sys_id start downloading .

Aditya_hublikar_0-1781680993229.png

 

Aditya_hublikar_1-1781680993213.png

 

If this helps you then mark it as helpful and accept as solution.

Regards,

Aditya

Hello @SivaprasadV ,

 

By using this you can export all records with its all fields

 

Hi @Aditya_hublikar ,

 

I've tried this but I can be able to download only 10001 records though I have nearly 1m+ records.