Query parameters for display value and header
Use query parameters to export the display value or raw value of fields and the field label or field name for headers.
Query parameters control the output for CSV, XLS, JSON, XLSX, and XML file formats. Query parameters, if present, override system properties.
The following table describes each of the query parameters that control display values and headers.
| Query parameter | Description |
|---|---|
| sysparm_display_value | Exports the display value (true) or raw value (false) for the CSV, XLS, XLSX, and XML file formats.See Field types affected by export controls for more information. |
| displayvalue | Exports the display value (true), raw value (false), or both (All) for the JSON file format.See Field types affected by export controls for more information. |
| sysparm_export_column_header_label | Exports the CSV, XLS, and XLSX file formats with the field label (true) or field name (false). |
sysparm_display_value
- Example: sysparm_display_value = true
Image omitted: XLSX-sysparm-display-value-true.png
Example: sysparm\_display\_values = true
Example: sysparm\_display\_values = true
- Example: sysparm_display_value = false
Image omitted: XLSX-sysparm-display-value-false.png
Example: sysparm\_display\_values = false
Example: sysparm\_display\_values = false
displayvalue
- Example: displayvalue = true
Image omitted: json-displayvalue-true.png
Example: displayvalue = true
Example: displayvalue = true
- Example: displayvalue = false
Image omitted: json-displayvalue-false.png
Example: displayvalue = false
Example: displayvalue = false
- Example: displayvalue = All
Image omitted: json-displayvalue-all.png
Example: displayvalue = all
Example: displayvalue = all
sysparm_export_column_header_label
- Example: sysparm_export_column_header_label = true
Image omitted: sysparm\_export\_column\_header\_label-true.png
Example: sysparm\_export\_column\_header\_label = true
Example: sysparm\_export\_column\_header\_label = true
- Example: sysparm_export_column_header_label = false
Image omitted: sysparm\_export\_column\_header\_label-false.png
Example: sysparm\_export\_column\_header\_label = false
Example: sysparm\_export\_column\_header\_label = false
Parent Topic:Data export reference