How to Downlaod large count of records in a single file
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Sunday
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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
This will download your records in large formats..
If my response helped mark as helpful and accept the solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
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 .
If this helps you then mark it as helpful and accept as solution.
Regards,
Aditya
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
3 weeks ago
Hi @Aditya_hublikar ,
I've tried this but I can be able to download only 10001 records though I have nearly 1m+ records.