Data Models

The Looker PowerPoint CLI uses Pydantic models to validate and structure data for PowerPoint shape integration.

LookerReference

class looker_powerpoint.models.LookerReference

Bases: BaseModel

This model represents the input you can set in alternative text for a shape in PowerPoint. You can specify the different parameters to control how Looker data is fetched and displayed.

Fields:

• apply_formatting (bool)

• apply_vis (bool)

• column (int)

• filter (str)

• filter_overwrites (dict)

• headers (bool)

• id (str)

• id_type (str)

• image_height (int)

• image_width (int)

• label (str)

• meta (bool)

• meta_iterate (bool)

• meta_name (str)

• result_format (str)

• retries (int)

• row (int)

• server_table_calcs (bool)

• show_latest_chart_label (bool)

Validators:

• convert_int » id

field id: str [Required]

The ID of the Look or meta-look (meta_name) you want to reference.

field id_type: str = 'look'

The type of ID provided: ‘look’ or ‘meta’. Defaults to ‘look’. Setting to ‘meta’ indicates that the ID refers to a meta Look.

field meta: bool = False

Set this to true if the Look is a meta Look. A meta look is a look that you want to retrieve and reuse, but not display directly.

field meta_name: str = None

NOT actually working yet. If you are defining a meta look, you should provide a reference name here. This can then be used by other shapes to reference this meta look.

field meta_iterate: bool = False

If set to true, this meta look will be iterated over by other shapes referencing it. This is useful for creating dynamic content based on the results of the meta look.

field label: str = None

Setting a label here filters the results to the specified label. The label needs to match the specific column label from the look including any special characters.

field column: int = None

The specific column to retrieve from the Look results. 0-indexed.

field row: int = None

If you want to retrieve a specific row from the Look results, set the row number here (0-indexed).

field filter: str = None

Define a lookml.field_name used in the Look that you want to be able to filter on using the –filter cli argument. Inputting –filter <value> will filter the results to where <label>=<value>.

field filter_overwrites: dict = None

A dictionary of filter overwrites to apply to the Look. The keys are the filter lookml.field_names, and the values are the filter values. The filter values should not be enclosed in quotation marks. (unvalidated)

field result_format: str = 'json_bi'

The format to return the results in. Defaults to ‘json_bi’.

field show_latest_chart_label: bool = False

If set to true, modify chart series with labels to only show the latest label.

field apply_formatting: bool = False

Apply Looker-specified formatting to each result.

field apply_vis: bool = True

Apply Looker visualization options to results.

field server_table_calcs: bool = True

Whether to compute table calculations on the Looker server before returning results.

field headers: bool = True

Whether to overwrite headers in the result set with Looker-defined column labels.

field image_width: int = None

Width of the image in pixels. Used for setting image size when asking looker to return a look rendered as an image.

field image_height: int = None

Height of the image in pixels. Used for setting image size when asking looker to return a look rendered as an image.

field retries: int = 0

Number of retries for the Looker API request in case of failure. Defaults to 0.

validator convert_int  »  id

Validation: Convert integer values to strings.