ferc1_purchased_power

Pack: ferc-form1 · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)

No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/ferc1_purchased_power for the schema, then POST the same URL with its arguments for the data.

FERC Form 1 purchased power and exchanges (Schedule 326) for one utility and report year, 1994 to date: each seller (counterparty), purchase type (RQ requirements, LF long-term firm, IF intermediate firm, SF short-term firm, LU long-term unit, OS other/non-firm, EX exchange, AD adjustment), MWh purchased and settlement dollars. Rows sorted by MWh, subtotal rows excluded and reported separately. Answers “who did PacifiCorp buy the most power from in 1994”. Source: FERC Form 1 as processed by Catalyst Cooperative PUDL.

Parameters

NameTypeRequiredDescription
purchase_typestringnoOptional purchase type code filter, e.g. OS, LF, LU, RQ.
limitintegernoMax rows to return (default 25, max 200).

Example call

Arguments

{
  "utility": "PacifiCorp",
  "year": 1994
}

curl

curl -X POST https://gateway.pipeworx.io/ferc-form1/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"ferc1_purchased_power","arguments":{"utility":"PacifiCorp","year":1994}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('ferc1_purchased_power', {
  "utility": "PacifiCorp",
  "year": 1994
});

Response shape

FieldTypeDescription
foundboolean
utilityobject | null
report_yearnumber | null
years_availablearray
currencystring
row_countnumber
detail_mwh_sumnumber
subtotals_excludedarray
rowsarray
top_counterparties_aggregatedarray
messagestring | null
notestring
sourcestring
data_as_ofstring
copy_refreshed_atstring
attributionstring
ambiguousboolean
candidatesarray
Full JSON Schema
{
  "type": "object",
  "properties": {
    "found": {
      "type": "boolean"
    },
    "utility": {
      "type": [
        "object",
        "null"
      ]
    },
    "report_year": {
      "type": [
        "number",
        "null"
      ]
    },
    "years_available": {
      "type": "array",
      "items": {
        "type": "number"
      }
    },
    "currency": {
      "type": "string"
    },
    "row_count": {
      "type": "number"
    },
    "detail_mwh_sum": {
      "type": "number"
    },
    "subtotals_excluded": {
      "type": "array",
      "items": {
        "type": "object"
      }
    },
    "rows": {
      "type": "array",
      "items": {
        "type": "object",
        "properties": {
          "seller": {
            "type": [
              "string",
              "null"
            ]
          },
          "purchase_type": {
            "type": [
              "string",
              "null"
            ]
          },
          "tariff": {
            "type": [
              "string",
              "null"
            ]
          },
          "purchased_mwh": {
            "type": [
              "number",
              "null"
            ]
          },
          "demand_charges": {
            "type": [
              "number",
              "null"
            ]
          },
          "energy_charges": {
            "type": [
              "number",
              "null"
            ]
          },
          "other_charges": {
            "type": [
              "number",
              "null"
            ]
          },
          "total_settlement": {
            "type": [
              "number",
              "null"
            ]
          }
        },
        "additionalProperties": true
      }
    },
    "top_counterparties_aggregated": {
      "type": "array",
      "items": {
        "type": "object"
      }
    },
    "message": {
      "type": [
        "string",
        "null"
      ]
    },
    "note": {
      "type": "string"
    },
    "source": {
      "type": "string"
    },
    "data_as_of": {
      "type": "string"
    },
    "copy_refreshed_at": {
      "type": "string"
    },
    "attribution": {
      "type": "string"
    },
    "ambiguous": {
      "type": "boolean"
    },
    "candidates": {
      "type": "array",
      "items": {
        "type": "object"
      }
    }
  },
  "additionalProperties": true
}

Connect

Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:

{
  "mcpServers": {
    "pipeworx": {
      "url": "https://pipeworx.io/mcp"
    }
  }
}
Connect to just the ferc-form1 pack
{
  "mcpServers": {
    "ferc-form1": {
      "url": "https://gateway.pipeworx.io/ferc-form1/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

Regenerated from source · build November 10, 2026