Lookup for vulnerable packages by Package URL.

GET /api/packages/45901?format=api
HTTP 200 OK
Allow: GET, HEAD, OPTIONS
Content-Type: application/json
Vary: Accept

{
    "url": "http://public2.vulnerablecode.io/api/packages/45901?format=api",
    "purl": "pkg:pypi/apache-airflow-providers-snowflake@2.5.2rc1",
    "type": "pypi",
    "namespace": "",
    "name": "apache-airflow-providers-snowflake",
    "version": "2.5.2rc1",
    "qualifiers": {},
    "subpath": "",
    "is_vulnerable": true,
    "next_non_vulnerable_version": "6.4.0",
    "latest_non_vulnerable_version": "6.4.0",
    "affected_by_vulnerabilities": [
        {
            "url": "http://public2.vulnerablecode.io/api/vulnerabilities/37090?format=api",
            "vulnerability_id": "VCID-drm2-6udz-9ffq",
            "summary": "Failure to Sanitize Special Elements into a Different Plane (Special Element Injection) vulnerability in Apache Airflow Providers Snowflake.\n\nThis issue affects Apache Airflow Providers Snowflake: before 6.4.0.\n\nSanitation of table and stage parameters were added in CopyFromExternalStageToSnowflakeOperator to prevent SQL injection\nUsers are recommended to upgrade to version 6.4.0, which fixes the issue.",
            "references": [
                {
                    "reference_url": "https://github.com/apache/airflow/pull/51734",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/apache/airflow/pull/51734"
                },
                {
                    "reference_url": "https://lists.apache.org/thread/2kqfmyt2pghg5f6797g8hzvq331v8qx3",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://lists.apache.org/thread/2kqfmyt2pghg5f6797g8hzvq331v8qx3"
                }
            ],
            "fixed_packages": [
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/46004?format=api",
                    "purl": "pkg:pypi/apache-airflow-providers-snowflake@6.4.0",
                    "is_vulnerable": false,
                    "affected_by_vulnerabilities": [],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/apache-airflow-providers-snowflake@6.4.0"
                }
            ],
            "aliases": [
                "CVE-2025-50213",
                "PYSEC-2025-51"
            ],
            "risk_score": null,
            "exploitability": null,
            "weighted_severity": null,
            "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-drm2-6udz-9ffq"
        }
    ],
    "fixing_vulnerabilities": [],
    "risk_score": null,
    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/apache-airflow-providers-snowflake@2.5.2rc1"
}