Extract/Export any # of records from ServiceNow Table w/o Increasing the limit in System Properties.

[AakashG1789]

Hi Folks,

Hope you are doing well.

Today, I came up with the solution on How one can Export/Extract any # of records from ServiceNow Table irrespective of increasing the limits under an Import Export System Properties as it is not considered the best practice and impact performance of the ServiceNow Instance and Platform.

Steps To Do:-

1. Open the Table in ServiceNow Instance from where you want to extract the records and then override the URL to export the records in any format by specifying your Instance Name, Table Name, and Format[CSV, XML, Excel, and JSON], Sort By Sys ID, and Defining the count of the records you want to get, but it should not exceed with the default/upper limit. https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_orderby=sys_id&sysparm_record_cou...
2. Wait for the export to get it complete. Meanwhile, you can go for a short walk or you can also listen your favorite songs.
3. Open the export and grab the last Sys ID from the last row/record.
4. Now, It's time to make a new URL https://<instance name>.service-now.com/syslog_list.do?XML&sysparm_query=sys_id><last_sys_id>&syspar...
5. Again Don't forget to modify the URL as per the details/info. you have and wait for the export to get it complete.
6. Repeat the Step 4 & 5 until you get the complete list of records.

This solution will help you to save your time a lot and you don't need to spend a lot of time just to export the large # of records from ServiceNow.

Hope this knowledge finds you helpful. Please mark this as helpful and Correct 🙂

Thanks

Aakash Garg

ServiceNow Developer