More than 10000 Excel exports

Potemi
Tera Contributor

I want to export a list of tables in Excel. ServiceNow has a limit of 10,000 items, but I want to export more than that. I would like to export Excel with a limit of 50,000 using JavaScript, not ServiceNow settings. Can you give me a script?

7 REPLIES 7

AndersBGS
Tera Patron
Tera Patron

Hi @Potemi ,

 

You still need to adjust the export limit in the properties settings according to product documentation: https://docs.servicenow.com/bundle/washingtondc-platform-administration/page/administer/exporting-da...

 

AndersBGS_0-1707902880800.png

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Potemi
Tera Contributor

@AndersBGS 

Thanks for the answer. Isn't it possible to leave the system properties unchanged and set an upper limit in Javascript? The CSV output was done in Javascript. The following settings have been made into UI actions.

 

 

Hi @Potemi ,

 

As far as I understand, you need to change the general property. Furthermore, why would you create a custom script instead of utilizing the OOTB functionalities for export/export limits. 

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders 

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Potemi
Tera Contributor

@AndersBGS 

ServiceNowのすべてのExcelのエクスポート制限を50,000にするのではなく、特定のテーブルに対して50,000のみにしたいと思います。また、現場での開発ルールとして、基本的には設定変更しないものなので、カスタムスクリプトで実装していきたいと思います。