Query a PSA OpenSTAT dataset
query_psa_datasetQuery Philippine Statistics Authority datasets by specifying explicit value codes for every dimension, preventing HTTP 403 errors from unselected dimensions.
Instructions
Run one bounded query against a PSA OpenSTAT dataset.
Every dimension needs an explicit list of value codes from describe_psa_dataset. That is a hard requirement, not a convention: PXWeb expands an unselected dimension to all of its values, and PSA answers the resulting full-cube request with an HTTP 403.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| max_rows | No | Cap on returned rows (1-5000, default 500). | |
| selections | Yes | Dimension code -> list of value codes, covering every dimension the dataset declares. "all" and "*" are rejected. Example: {"Year": ["2"], "Major Island Group": ["0", "2"], "Among Families/Population": ["0"]}. | |
| dataset_path | Yes | Relative `.px` path, e.g. "1F/FY/0241F3DF013.px". |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| note | No | ||
| rows | Yes | ||
| title | No | ||
| source | Yes | Upstream data source name. | |
| caveats | Yes | ||
| license | No | ||
| row_count | Yes | ||
| truncated | No | ||
| disclaimer | No | ||
| source_url | Yes | Canonical OpenSTAT URL used. | |
| dataset_path | Yes | ||
| upstream_error | No | True when OpenSTAT was unreachable. Not an empty result. | |
| requested_cells | No | ||
| reference_period | No | Data vintage read from the table's own time dimension. | |
| validation_error | No | True when the caller's arguments were rejected before any request. | |
| data_retrieved_at | Yes | ||
| total_rows_available | No |