looker-get-field-value-suggestions

kind: tool
name: get_field_value_suggestions
type: looker-get-field-value-suggestions
source: looker-source
description: |
  This tool retrieves distinct value suggestions for a field, facilitating accurate filtering in downstream queries.

  Required Parameters:
  - model: The name of the LookML model, obtained from `get_models`.
  - explore: The name of the explore containing the field, obtained from `get_explores`.
  - field: The name of the field to get suggestions for, obtained from `get_dimensions`.

  Optional Parameters:
  - term: Optional search term pattern to filter suggestions. Evaluated as `%term%`.
  - filters: Optional filters to enable conditional suggestions (restricting suggestions based on other field values), represented as a map of field names to filter expressions, e.g., `{"users.state": "CA", "users.age": ">=60"}`.

  Output:
  - A JSON object with a "suggestions" key containing an array of string values representing suggestions.

{
  "suggestions": ["CA", "NY", "TX", "WA"]
}