Querying datasets - Felix

Core workflow

Most integrations follow this sequence:

GET /v1/datasets to find a dataset id
GET /v1/datasets/{dataset_id} to inspect schema-like metadata
GET /v1/datasets/{dataset_id}/query to retrieve rows

Common filters

Dataset queries can be shaped with parameters such as:

start_time
end_time
time
publish_time
columns
page
page_size
limit
order

Example: time-bounded query

curl -H "x-api-key: YOUR_API_KEY" \
  "https://api.felixfusion.ai/v1/datasets/ercot_load/query?start_time=2026-05-18T00:00:00Z&end_time=2026-05-18T06:00:00Z&order=asc"

Example: selected columns

curl -H "x-api-key: YOUR_API_KEY" \
  "https://api.felixfusion.ai/v1/datasets/ercot_lmp_real_time_5_min/query?columns=interval_start_utc,location,lmp&page_size=50"

Example: CSV export

curl -H "x-api-key: YOUR_API_KEY" \
  "https://api.felixfusion.ai/v1/datasets/ercot_fuel_mix/query?return_format=csv&download=true"

When to use path-based queries

The path-based route:

GET /v1/datasets/{dataset_id}/query/{filter_column_id}/{filter_value_path}

is useful when you want a simple stable filter encoded in the URL itself, such as a single location or category filter.

⌘I