Spiral gives your agent every tool with one account. Browse the tools →

AlexandriaPublic RecordsAvailable now

City of Edmonton Open Data · Rows

data-edmonton-ca/open-data/rows

Search public records with City of Edmonton Open Data · Rows from Alexandria through one Spiral API key. Any question that needs actual records from a Edmonton Open Data dataset. Get the 4x4 id from datasets and the column field names from dataset first. Use row_count to size a query before paging. It runs in the background and returns structured JSON. Pay as you go, with no subscription.

Pricing

$0.00873 per call.

Limits

Runs
In the background
Returns
json
Longest queue wait
1 hour
Run deadline
5 minutes
Longest run, end to end
225 minutes
Largest inline input
1 MB
Largest input file
2 GB
Largest output
5 GB

Input

FieldKindDefaultDescription
dataset_id requiredtext—

4x4 id (for example 24uj-dj8v) or a data.edmonton.ca URL containing it.

qtext—

SoQL $q full-text search across all text columns.

grouptext—

SoQL $group; pair with aggregates in select.

limitnumber
1 to 50000
100

Rows per page. The portal caps a request at 50000; wide datasets with geometry should use far less.

ordertext—

SoQL $order, for example issue_date DESC or count(*) DESC. Default :id when no group is given.

wheretext—

SoQL $where, for example address like '%86 STREET NW', issue_date between '2026-09-01T00:00:00' and '2026-09-30T23:59:59', within_circle(geometry_point,53.5449,-113.4885,200).

cursortext—

Row offset to start from: the next_cursor of the previous page. Pattern: ^[0-9]{1,12}$.

selecttext—

SoQL $select, for example address,construction_value or job_category,count(*). Default: all columns.

filtersJSON—

Bare equality filters sent as field=value query parameters (for example {"job_category": "Commercial Final"}); keys must be column field names, values strings.

Same request in code

curl https://api.spiral.ai/v1/runs \
  -H "Authorization: Bearer $SPIRAL_API_KEY" \
  -H "Content-Type: application/json" \
  -H "Idempotency-Key: $(uuidgen)" \
  -d '{
    "provider": "alexandria",
    "model": "data-edmonton-ca/open-data/rows",
    "input": {
      "dataset_id": "<dataset_id>"
    }
  }'

Frequently asked questions

How much does City of Edmonton Open Data · Rows cost?

$0.00873 per call. You pay as you go from one Spiral balance, with no subscription, and a failed run is not charged.

How do I use City of Edmonton Open Data · Rows through an API?

Send `POST /v1/runs` with `"provider": "alexandria"`, `"model": "data-edmonton-ca/open-data/rows"` and the input fields on this page, using one Spiral API key. It runs in the background: poll the run, or name a webhook to be told when it finishes.

Do I need an account with Alexandria to use City of Edmonton Open Data · Rows?

No. Spiral runs it on its own Alexandria account and charges your Spiral balance.

Can my AI agent use City of Edmonton Open Data · Rows?

Yes. Agents find and run it through Spiral's MCP server, CLI or agent skill, with the same API key.