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).

Example: sysparm_display_value

Example: sysparm_display_value = true
Example: sysparm_display_values = true
Example: sysparm_display_value = false

Example: sysparm_display_values = false

Example: displayvalue

Example: displayvalue = true

Example: displayvalue = true

Example: displayvalue = false

Example: displayvalue = false

Example: displayvalue = All

Example: displayvalue = all

Example: sysparm_export_column_header_label

Example: sysparm_export_column_header_label = true

Example: sysparm_export_column_header_label = true

Example: sysparm_export_column_header_label = false

Example: sysparm_export_column_header_label = false