US Clean Energy & Commercial Solar Project Pipeline Intelligence (NYSERDA)

Find NYSERDA-supported New York solar projects from the official Solar Electric Programs Reported by NYSERDA: Beginning 2000 dataset. Despite the US product category, coverage is New York State only, not the entire US clean-energy market.

Default: 100 unique Pipeline / Non-Residential projects. Choose Complete explicitly for historical installation research. Complete records are never labelled as pipeline leads. This product supplies project intelligence, not verified contact or outreach lists.

Inputs

Use status: Pipeline, Complete, or All; sector: Non-Residential, Residential, or All. These are real source values; the source does not identify separate Commercial and Industrial sectors. counties accepts exact county names such as Albany or New York.

minCapacityKw / maxCapacityKw filter total nameplate kW DC. minCostUsd / maxCostUsd filter expected project installation cost in USD, not incentives. Missing costs do not match numeric cost filters. dateField is date_application_received (default) or date_install; dateFrom and dateTo are inclusive YYYY-MM-DD dates. Pipeline projects generally have no completion date. maxResults is 1–50,000 (default 100); pageSize is 1–1,000 (default 500).

{"status":"Pipeline","sector":"Non-Residential","maxResults":100}

For completed projects:

{"status":"Complete","sector":"Non-Residential","counties":["Albany"],"minCapacityKw":25,"maxResults":100}

Output and field mapping

Output	Official SODA field / meaning
project_number	project_number, preserved as text including leading zeros
city_county	city and county joined; separate city/county also included
sector_commercial_industrial	sector verbatim; no inferred Commercial/Industrial classification
project_status	project_status verbatim: Pipeline or Complete
contractor_developer_name	contractor for Complete; always null for Pipeline
system_size_kw	totalnameplatekwdc; kW DC
total_project_cost_usd	project_cost; expected installation cost reported by contractor
incentive_amount_usd	total_nyserda_incentive; program incentives, separate from cost

Also includes application/completion dates, reporting period, is_pipeline, source URL, dataset ID and actual source-data update timestamp. Missing values remain null; zero money values remain zero. Contractor is not necessarily the project owner or developer. Pipeline contractors are intentionally suppressed even where Community Distributed Generation exceptions provide them.

Freshness and limitations

At verification, source data was updated October 4, 2026; portal metadata was updated October 6, 2026. The reported period is September 30, 2026. The source is updated monthly. Each run fetches live metadata and records source_data_updated_at and RUN_INFO. Pipeline projects may change, be cancelled or never be installed. Blank cells mean unavailable or not required. Some legacy projects and contractor details are missing. No completeness, accuracy, future completion or opportunity availability is guaranteed. Check the official record before making a business decision. This Actor is independent and not endorsed by NYSERDA or New York State.

Clay, n8n, JSON and CSV

Results are stored in the run's default Apify Dataset. Use its Export button or authenticated API:

• JSON: https://api.apify.com/v2/datasets/DATASET_ID/items?format=json&clean=true
• CSV: https://api.apify.com/v2/datasets/DATASET_ID/items?format=csv&clean=true&bom=true

In n8n use Apify Run Actor followed by Get Dataset Items, or an HTTP Request with your Apify credential. In Clay import the CSV or fetch the JSON through an HTTP integration. Keep API tokens in your integration's credential store. RUN_INFO in the key-value store reports freshness and any detected mid-run source change.

Price

$0.0065 per successfully saved unique project ($6.50 per 1,000) using the apify-default-dataset-item Pay-per-Event event. No start fee and no additional run platform usage fee. Empty runs, missing project IDs and duplicate project numbers are not billed. Deduplication applies within a run, including resumed/resurrected runs using the same default Dataset; separate new runs are independently billed. Apify spending limits are respected. Post-run storage/export operations may incur Apify account charges under the platform's terms.

Reliability

Sequential SODA keyset pagination ordered by project number plus row ID; maximum 2 source requests per second. 30-second request timeout and up to four retries for timeouts, HTTP 408/429 and transient 5xx errors, exponential backoff and Retry-After (capped at 60 seconds). Other HTTP errors fail immediately. Project-number deduplication, bounded results and schema/vocabulary checks protect output quality. A source update during a run is flagged; rerun for a fresh extraction. This is not a transactional database snapshot.

Source and use terms

Official provider: New York State Energy Research and Development Authority Solar Electric Programs. SODA endpoint: https://data.ny.gov/resource/3x8r-34rs.json. Dataset-specific license is unspecified. The OPEN-NY Terms of Use permit lawful reuse, including private-sector projects, subject to their terms. Public developer APIs are used without circumventing access controls. No logos or endorsement claims are reused. The service charge covers filtering, normalization, delivery and operation; the underlying government data is publicly available.

Development

Version 1.0.0. Python 3.13; Apify SDK 3.4.1. pip install -r requirements.txt, then python -m src.main. Run python -m unittest discover -s tests. Container: docker build -t newapi40:1.0.0 .. Default examples should complete in less than five minutes under normal source availability.