System properties for display value and header
Use system properties to export the display value or raw value of fields and the field label or field name for headers.
System properties control the output for the CSV, Excel, JSON, and XLSX file formats. System properties define default behavior if overrides such as query parameters are not specified. System properties apply to exported files downloaded with URL parameters, exported from list view, or generated by export sets.
The following table describes each of the system properties that control display values and headers.
| Format | Property | Default Value |
|---|---|---|
| CSV | glide.export.csv.raw.value | false Note: Setting the property as false also crops the value's string to 32000 characters. |
| glide.export.csv.column_header_label | false | |
| Excel | glide.export.excel.display_value | true |
| glide.export.excel.column_header_label | true | |
| JSON | glide.json.return_displayValue | false |
| XLSX | glide.export.xlsx.display_value | true |
| glide.export.xlsx.column_header_label | true |
CSV
Example:
glide.export.csv.raw.value = false (default)
glide.export.csv.column_header_label = false (default)
Example: glide.export.csv.raw.value = false and glide.export.csv.column\_header\_label = false
Example:
glide.export.csv.raw.value = true
glide.export.csv.column_header_label = true
Example: glide.export.csv.raw.value = true and glide.export.csv.column\_header\_label = true
Excel
Example:
glide.export.excel.display_value = true (default)
glide.export.excel.column_header_label = true (default)
Example: glide.export.excel.display\_value = true and glide.export.excel.column\_header\_label = true
Example:
glide.export.excel.display_value = false
glide.export.excel.column_header_label = false
Example: glide.export.excel.display\_value = false and glide.export.excel.column\_header\_label = false
JSON
Example:
glide.json.return_displayValue = false (default)
Example: glide.json.return\_displayValue = false
Example:
glide.json.return_displayValue = true
Example: glide.json.return\_displayValue = true
XLSX
Example:
glide.export.xlsx.display_value = true (default)
glide.export.xlsx.column_header_label = true (default)
Example: glide.export.xlsx.display\_value = true and glide.export.xlsx.column\_header\_label = true
Example:
glide.export.xlsx.display_value = false
glide.export.xlsx.column_header_label = false
Example: glide.export.xlsx.display\_value = false and glide.export.xlsx.column\_header\_label = false
Parent Topic:Data export reference