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

Zapier · Public Records

How to Use Edmonton dataset record count in Zapier

Returns the number of records matching an Edmonton dataset query. Use it for a how-many question or to size a retrieval before fetching individual records.

Prompts to try with Edmonton dataset record count in Zapier

Copy an example into Zapier, or ask in your own words.

Every Friday, use Edmonton dataset record count to report how many Downtown development applications have approved, refused, or appealed status, using the dataset's verified definitions.

Edmonton dataset record countZapier
Try asking
  • Every Monday at 9am: use Edmonton dataset record count to look this up and give me the result as a table.

  • Pull the latest numbers from Edmonton dataset record count and tell me what changed since last week.

  • Check Edmonton dataset record count and summarize what you find in three bullet points.

  • Pull the newest data from Edmonton dataset record count and give me the result as a table.

How to set up Edmonton dataset record count in Zapier

Pick the way that suits you. Each takes about two minutes.

Use the Spiral skill

  1. Send Zapier this message

    Your agent reads Spiral's skill and sets itself up.

    set up https://spiral.ai/SKILL.md
  2. Sign in or paste a key

    Approve Spiral in the browser, or give the agent a key from the console.

Use Spiral's MCP server

  1. Add an MCP Client connection

    In Zapier open Apps, click Add connection and search for MCP Client. Fill in the form:

    https://api.spiral.ai/mcp
  2. Sign in to Spiral and approve

    Spiral opens: sign in, pick the organization and click Authorize. No API key. Spiral gives the connection its own key; Zapier never sees it, and you can remove it under Settings › Connected apps in the console.

  3. Run a Spiral tool in a Zap

    Add an MCP Client step to a Zap and choose the Run Tool action with your Spiral connection. Pick a tool: discover finds the right model for a task, estimate_cost prices it and run runs it. For example, run with:

    {
      "provider": "fal",
      "model": "fal-ai/flux/schnell",
      "input": { "prompt": "a lighthouse at dawn" },
      "wait": true
    }
  4. Run Edmonton dataset record count in a workflow step

    Give the step an instruction like the ones below and run it on your trigger or schedule. Spiral finds Edmonton dataset record count, prices it and runs it each time the step fires.

Use the Spiral CLI

  1. Install and sign in

    Installs the Spiral CLI, signs you in and adds its skill to your coding agents.

    npx -y spiral-cli@latest init

Call the Spiral API

  1. Create an API key

    In the console, under API keys.

  2. Run Edmonton dataset record count

    One request; the result comes back by polling or a webhook.

    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/row_count",
        "input": {
          "dataset_id": "<dataset_id>"
        }
      }'

Then paste one of the prompts above: Zapier finds Edmonton dataset record count on Spiral, shows the price and runs it.

Edmonton dataset record count providers and prices

Spiral runs Edmonton dataset record count through Alexandria. Open a card for today's price, with every fee included.

AlexandriaPublic Records
City of Edmonton Open Data · Row count
data-edmonton-ca/open-data/row_count

What can you do with Edmonton dataset record count in Zapier?

Produce a recurring Edmonton district briefing from the latest published municipal data. Track changes in records and dataset definitions while keeping business licence renewals separate from claims about new openings.

Downtown business district briefing

Prepare a Downtown briefing with commercial licence activity, issued construction work, and published property assessments. Find the relevant catalog subjects, inspect definitions, and count matching records before assembling the supporting tables.

Commercial corridor comparison

Compare Jasper Avenue and 124 Street using published assessments, commercial licences, and construction records. Discover the source datasets through their categories and tags, check column meanings, and calculate comparable record counts for each corridor.

Public commercial site background

Compile the available assessment, issued building permits, and commercial licence records for a proposed business location on Whyte Avenue. Use catalog labels to find related development data, inspect its definitions, and count and retrieve the matching records.

Municipal data source audit

Build a source inventory for an Edmonton commercial activity report. Document catalog categories, dataset definitions, assessment coverage, licence date meanings, permit scope, and matching record totals, then inspect sample records from each source.

Construction activity summary

Summarize issued building permits in McIntyre Industrial by building type and work description. Report units added separately from the number of permits.

Development application outcome report

Locate Edmonton's development permit data and summarize approved, refused, and appealed applications in Downtown. Keep these outcomes separate from issued building permit activity.

Questions about Edmonton dataset record count in Zapier

Can Zapier use Edmonton dataset record count?

Yes. Add Spiral to Zapier as an MCP server, and Zapier can find and run Edmonton dataset record count like any built-in tool.

How much does Edmonton dataset record count cost in Zapier?

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

Do I need an Alexandria account to use Edmonton dataset record count in Zapier?

No. Spiral runs Edmonton dataset record count on its own Alexandria account. You sign in to Spiral once and never paste a key.

How long does it take to set up Edmonton dataset record count in Zapier?

About two minutes: add an MCP Client connection, then sign in to Spiral and approve, then run a Spiral tool in a Zap.

Does Zapier wait while Edmonton dataset record count runs?

Edmonton dataset record count runs in the background. Zapier starts the run, checks on it and gives you the json when it's ready.

What geographic area do the property assessments cover?

The property assessment dataset covers properties within the City of Edmonton. It does not describe an assessment inventory for the entire Edmonton metropolitan region.

How often are property assessments refreshed?

The property assessment dataset lists automated weekly updates. Its coverage period is a calendar year, so a weekly refresh does not make the assessed value a weekly market valuation.

How far back do building permit records go?

Edmonton states that its published building permit records start on January 1, 2009. This source does not establish permit history before that date.

Does a recent business licence issue date mean a business just opened?

No. Edmonton defines the most recent issue date as the date a licence was most recently issued or renewed, so renewals can appear in a recent-date search.

Are all business addresses public?

No. Edmonton redacts business addresses for some licence types because of privacy.

Get started

Start using Edmonton dataset record count in Zapier

One Spiral account for every tool your agent needs. No subscription; you pay per run.

Paste this into Zapier:

Set up Zapier

set up https://spiral.ai/SKILL.md
Are you an AI agent? See setup options