are export sets subject to the limit set by glide.xlsx.export.limit?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-07-2024 06:34 AM
we have set the glide.xlsx.export.limit property to 100,000 to restrict any random user from exporting more than this limit while using r-click export in a servicenow list.
but there are a few individuals in my organization who have a legitimate reason to export more than 100,000 records. I would like to use the export set feature available only to certain roles to allow these few employees to export more than this limit.
So can anyone confirm that export sets are also limited by this property? if so, is there any way to set up some kind of exception to allow some users (admins only for example) to export larger data sets?
btw, I am open to using any other feature that will allow me to setup an exception to the record limit.
thank you in advance for your responses!
Efra
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-07-2024 07:18 AM
thank you for your reply. I am aware of doing larger exports by splitting them into smaller batches.
I take that your response means that the property in question has an effect on the entire platform and there is no way to set up an exception. whether the export is done using r-click export, export sets, or even API queries, the limit is set by this property.
would you please confirm?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā08-07-2024 11:09 AM
thank you, I am aware about the recommendation to split one large export into smaller batches.
what I am more interested in is knowing if the glide.xlsx.export.limit property restricts every single way to export data. that is using r-click/export on a list, or export sets, or whatever other way might be? can you or someone confirm that there is no way around the limit set on this property?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā11-12-2024 01:43 AM
Export limits are enforced differently depending on whether or not the Export Set feature is used:
The Export limits mentioned above are not for export set feature, such as right-clicking and selecting Export from a list, or URL export.
When using the Export Set feature, the 'Maximum Rows' value set in the Export Set record determines the row limit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā11-12-2024 07:13 AM
Thank you for your response.
Let me rephrase it to make sure I understand your statement.
"the export limits described here are only relevant to export-related right-click options from list headers. but they are irrelevant when using the OOB Export Set feature (All/System Export Sets/Export Sets). For the latter functionality, there is a separate field in the export set definition record, this field is called Maximun rows. the number in this field dictates the maximum rows that this export feature will generate"
Please check the statement above and let me know if it is accurate. if so, I would recommend a note in your documentation clarifying this.