get_facets
Retrieve facet values and record counts for a dataset's filterable fields to build accurate where/refine filters before querying records.
Instructions
Get facet values and their record counts for a dataset's filterable fields. Call this before query_records to discover valid values for where/refine filters instead of guessing.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| where | No | ODSQL boolean expression to narrow facet counts | |
| refine | No | Repeatable facet filters, each formatted as "field:value" | |
| datasetId | Yes | The dataset_id, e.g. "greenest-city-projects" |