Skip to content
Eden Engine
Get started

Edmonton Open Data Rows: Read a Dataset with SoQL Filters

edmontonopendata/dataset-rows

Reads rows from one City of Edmonton open dataset by its four-by-four id, with an optional SoQL where filter and sort, a row limit up to 50 and an offset for paging. Returns the rows with the dataset's own columns. Row shapes differ per dataset; use the dataset-metadata tool for field names. Data of the City of Edmonton, served by Eden Engine; not an official City of Edmonton product.

activeper callv1

Price

$0.0026 per call

You pay the price shown. If a call turns out to cost more than its quote, you pay the actual price, capped at twice the quote. No monthly minimum. Top-ups start at $0.50.

Data source

City of Edmonton Open Data Portal

Source: City of Edmonton Open Data Portal (data.edmonton.ca); the dataset attribution field reads 'City of Edmonton' and the portal licence is titled Open Government Licence - Edmonton. Served by Eden Engine; not an official City of Edmonton product.

Use it

Five steps: search, inspect, learn, run, settle. No per-tool setup; your agent reaches this tool through the meta-tools it already has.

Connect once and your AI can find and run this tool, and any other it needs.

Install itCreate an account
agent
// 1. search: find the tool
omnial_search({ query: "what you need" })

// 2. inspect: price and input schema
omnial_inspect({ tool: "edmontonopendata/dataset-rows" })

// 3. learn: read the usage guide at runtime
omnial_learn({ tool: "edmontonopendata/dataset-rows" })

// 4. run: price the exact call first, then run it
omnial_execute({ tool: "edmontonopendata/dataset-rows", input: { /* see input_schema */ }, dry_run: true })
omnial_execute({ tool: "edmontonopendata/dataset-rows", input: { /* ... */ } })

// 5. settle: the call is charged when it finishes, nothing to do

Not connected yet? Point your MCP client at https://mcp.eden-engine.com/mcp, then copy a config for your client.

Pricing

Every charge this tool can incur.

ChargePrice
Per call
$0.0026
Updated
Oct 24, 2026

Input and output schemas

Input schema
input_schema.json
{
  "type": "object",
  "required": [
    "dataset_id"
  ],
  "properties": {
    "limit": {
      "type": "integer",
      "default": 10,
      "maximum": 50,
      "minimum": 1,
      "description": "Rows to return, 1 to 50. Defaults to 10."
    },
    "order": {
      "type": "string",
      "maxLength": 100,
      "minLength": 1,
      "description": "SoQL sort, for example `start_date DESC`. Leave out for the portal's order."
    },
    "where": {
      "type": "string",
      "maxLength": 300,
      "minLength": 1,
      "description": "SoQL filter, for example status = 'Complete'. Leave out for all rows."
    },
    "offset": {
      "type": "integer",
      "minimum": 0,
      "description": "Rows to skip, for reading further pages."
    },
    "dataset_id": {
      "type": "string",
      "pattern": "^[a-z0-9]{4}-[a-z0-9]{4}$",
      "description": "Dataset id in Socrata four-by-four form, for example `k4tx-5k8p`. Find it with the search-datasets tool."
    }
  },
  "additionalProperties": false
}
Output schema
output_schema.json
{
  "type": "object",
  "required": [
    "results"
  ],
  "properties": {
    "results": {
      "type": "array",
      "items": {
        "type": "object",
        "additionalProperties": true
      },
      "description": "The rows, one object per row with the dataset's own columns; empty when the filter matches nothing."
    }
  },
  "description": "The rows the portal returned, in the portal's order.",
  "additionalProperties": true
}