Community

Change in JSON Render Formatting (6.22+)

In Looker 6.22, Looker’s method for rendering values in some JSON formats for sending, scheduling, and downloading has changed. This change applies to deliveries and downloads through the Looker UI and the Looker API.

Pre-Looker 6.22

Looker uses a dimension or measure’s field name as its rendered value when sending, scheduling, or downloading in all JSON formats from the Looker UI Scheduler and the Looker API. The field names in a data visualization are displayed as they appear in the data table. iFor example:

{"view.field_name":"rendered_value"}

If you select Apply visualization options on the Looker Send or Schedule pop-up, any available JSON formats will render in the delivery like so:

JSON – Simple: {"rendered_label":"rendered_value"} (uses field name from data table)
JSON – Simple, Inline: {"rendered_label":"rendered_value"} (uses field name from data table)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

Looker 6.22 - 7.4

Looker introduces a new JSON format option for sending and scheduling Looks and Explores to some destinations. From the Send or Schedule pop-up, this option appears as JSON – Label. When scheduling and sending using the Looker API, this option is json_label.

Downloading uses the JSON – Label format by default: the field names shown in the downloaded data match the field names in the visualization.

When delivering Looks and Explores, the JSON formats available depend on the selected destination. The JSON – Label format option uses a dimension or measure’s label from the data visualization as its rendered value in its JSON output. For example:

{"rendered_label":"rendered_value"}

Other JSON format outputs render field names like so:
JSON – Simple: {"view.field_name":"rendered_value"} (uses field name from data table)
JSON – Simple, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

If you select Apply visualization options on the Looker Send or Schedule pop-up, any available JSON formats will render in the delivery like so:

JSON – Label: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Simple: {"rendered_label":"rendered_value"} (uses field name from data table)
JSON – Simple, Inline: {"rendered_label":"rendered_value"} (uses field name from data table)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

Looker 7.6 - 7.12

Downloading uses the JSON – Label format by default: the field names shown in the downloaded data match the field names in the visualization.

When delivering Looks and Explores, the JSON formats available depend on the selected destination. The JSON – Label format option uses a dimension or measure’s label from the data visualization as its rendered value in its JSON output. For example:

{"rendered_label":"rendered_value"}

Other JSON format outputs render field names like so:
JSON – Simple: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Simple, Inline: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

If you select Apply visualization options on the Looker Send or Schedule pop-up, any available JSON formats will render in the delivery like so:

JSON – Label: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Simple: {"rendered_label":"rendered_value"} (uses field name from data table)
JSON – Simple, Inline: {"rendered_label":"rendered_value"} (uses field name from data table)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

Looker 7.14+

Downloading uses the JSON – Label format by default: the field names shown in the downloaded data match the field names in the visualization.

When delivering Looks and Explores, the JSON formats available depend on the selected destination. The JSON – Label format option uses a dimension or measure’s label from the data visualization as its rendered value in its JSON output. For example:

{"rendered_label":"rendered_value"}

Other JSON format outputs render field names like so:
JSON – Label: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Simple: {"view.field_name":"rendered_value"} (uses field name from data table)
JSON – Simple, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

If you select Apply visualization options on the Looker Send or Schedule pop-up, any available JSON formats will render in the delivery like so:

JSON – Label: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Simple: {"rendered_label":"rendered_value"} (uses label from data visualization)
JSON – Simple, Inline: {"rendered_label":"rendered_value"} (uses label from visualization)
JSON – Detailed, Inline: {"view.field_name":"rendered_value"} (uses field name from data table)

1 Like