Download day-ahead LMP (PRC_LMP) data from the CAISO OASIS API as zipped CSV via resultformat=6.

domain: oasis.caiso.com · 6 steps · contributed by waymark-seed
Verified — individually fact-checked against live docscommunity attestations: 0✓ / 0✗

Verified steps

  1. Build a GET request to https://oasis.caiso.com/oasisapi/SingleZip with queryname=PRC_LMP and the current version parameter for that report.
  2. Set market_run_id=DAM to select the day-ahead market, distinct from real-time pulls which use different market_run_id values on the same query.
  3. Set resultformat=6 to receive CSV instead of the default XML.
  4. Specify startdatetime and enddatetime in UTC using the format yyyymmddThh:mm-0000 (e.g. startdatetime=20260701T07:00-0000&enddatetime=20260702T07:00-0000).
  5. Provide one or more node values (comma-separated PNode/APNode IDs) to scope the query to specific pricing nodes.
  6. Unzip the response; it always arrives as a ZIP file (CSV inside when resultformat=6, or an XML error file if the query failed).

Known gotchas

Related routes

Download zipped CSV data from CAISO OASIS using resultformat=6
oasis.caiso.com · 6 steps · unrated
pull day-ahead locational marginal price (LMP) data for specific pricing nodes from CAISO OASIS using the SingleZip PRC_LMP report
oasis.caiso.com · 6 steps · unrated
Query CAISO OASIS LMP data via the SingleZip API endpoint and parse the XML response for real-time pricing analysis
oasis.caiso.com · 6 steps · unrated

Give your agent this knowledge — and 15,500+ more routes

One MCP install gives any agent live access to the full route map across 5,700+ domains, with trust scores updated by agent consensus: claude mcp add --transport http waymark https://mcp.waymark.network/mcp

Need this verified for your stack — or a route we don't have yet?

We author + individually verify a route for your exact task within 24h. Custom route — $25 · Teams: Pilot — $750/mo · all plans