Lookup for vulnerable packages by Package URL.

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

{
    "url": "http://public2.vulnerablecode.io/api/packages/63294?format=api",
    "purl": "pkg:pypi/sqlalchemy@0.7.0b4",
    "type": "pypi",
    "namespace": "",
    "name": "sqlalchemy",
    "version": "0.7.0b4",
    "qualifiers": {},
    "subpath": "",
    "is_vulnerable": false,
    "next_non_vulnerable_version": "1.2.18",
    "latest_non_vulnerable_version": "1.3.0b3",
    "affected_by_vulnerabilities": [],
    "fixing_vulnerabilities": [
        {
            "url": "http://public2.vulnerablecode.io/api/vulnerabilities/34759?format=api",
            "vulnerability_id": "VCID-3q38-re5x-rbaj",
            "summary": "Multiple SQL injection vulnerabilities in SQLAlchemy before 0.7.0b4, as used in Keystone, allow remote attackers to execute arbitrary SQL commands via the (1) limit or (2) offset keyword to the select function, or unspecified vectors to the (3) select.limit or (4) select.offset function.",
            "references": [
                {
                    "reference_url": "http://rhn.redhat.com/errata/RHSA-2012-0369.html",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://rhn.redhat.com/errata/RHSA-2012-0369.html"
                },
                {
                    "reference_url": "https://bugs.launchpad.net/keystone/+bug/918608",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://bugs.launchpad.net/keystone/+bug/918608"
                },
                {
                    "reference_url": "http://secunia.com/advisories/48327",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://secunia.com/advisories/48327"
                },
                {
                    "reference_url": "http://secunia.com/advisories/48328",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://secunia.com/advisories/48328"
                },
                {
                    "reference_url": "http://secunia.com/advisories/48771",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://secunia.com/advisories/48771"
                },
                {
                    "reference_url": "https://exchange.xforce.ibmcloud.com/vulnerabilities/73756",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://exchange.xforce.ibmcloud.com/vulnerabilities/73756"
                },
                {
                    "reference_url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2012-9.yaml",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/pypa/advisory-database/tree/main/vulns/sqlalchemy/PYSEC-2012-9.yaml"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy"
                },
                {
                    "reference_url": "https://github.com/sqlalchemy/sqlalchemy/commit/51fea2e159ca93daa0bc8066a5c35d8436d99418",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/sqlalchemy/sqlalchemy/commit/51fea2e159ca93daa0bc8066a5c35d8436d99418"
                },
                {
                    "reference_url": "https://web.archive.org/web/20140721183117/http://secunia.com/advisories/48771",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://web.archive.org/web/20140721183117/http://secunia.com/advisories/48771"
                },
                {
                    "reference_url": "https://web.archive.org/web/20140802043526/http://secunia.com/advisories/48328",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://web.archive.org/web/20140802043526/http://secunia.com/advisories/48328"
                },
                {
                    "reference_url": "https://web.archive.org/web/20140802044957/http://secunia.com/advisories/48327",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://web.archive.org/web/20140802044957/http://secunia.com/advisories/48327"
                },
                {
                    "reference_url": "http://www.debian.org/security/2012/dsa-2449",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://www.debian.org/security/2012/dsa-2449"
                },
                {
                    "reference_url": "http://www.mandriva.com/security/advisories?name=MDVSA-2012:059",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://www.mandriva.com/security/advisories?name=MDVSA-2012:059"
                },
                {
                    "reference_url": "http://www.sqlalchemy.org/changelog/CHANGES_0_7_0",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://www.sqlalchemy.org/changelog/CHANGES_0_7_0"
                },
                {
                    "reference_url": "http://www.sqlalchemy.org/trac/changeset/852b6a1a87e7/",
                    "reference_id": "",
                    "reference_type": "",
                    "scores": [],
                    "url": "http://www.sqlalchemy.org/trac/changeset/852b6a1a87e7/"
                },
                {
                    "reference_url": "https://nvd.nist.gov/vuln/detail/CVE-2012-0805",
                    "reference_id": "CVE-2012-0805",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://nvd.nist.gov/vuln/detail/CVE-2012-0805"
                },
                {
                    "reference_url": "https://github.com/advisories/GHSA-hfg2-wf6j-x53p",
                    "reference_id": "GHSA-hfg2-wf6j-x53p",
                    "reference_type": "",
                    "scores": [],
                    "url": "https://github.com/advisories/GHSA-hfg2-wf6j-x53p"
                }
            ],
            "fixed_packages": [
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/63294?format=api",
                    "purl": "pkg:pypi/sqlalchemy@0.7.0b4",
                    "is_vulnerable": false,
                    "affected_by_vulnerabilities": [],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.7.0b4"
                },
                {
                    "url": "http://public2.vulnerablecode.io/api/packages/7300?format=api",
                    "purl": "pkg:pypi/sqlalchemy@0.7.0",
                    "is_vulnerable": true,
                    "affected_by_vulnerabilities": [
                        {
                            "vulnerability": "VCID-kbkh-bf1z-3kb4"
                        },
                        {
                            "vulnerability": "VCID-tt22-7cuc-gkfc"
                        }
                    ],
                    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.7.0"
                }
            ],
            "aliases": [
                "CVE-2012-0805",
                "GHSA-hfg2-wf6j-x53p",
                "PYSEC-2012-9"
            ],
            "risk_score": null,
            "exploitability": null,
            "weighted_severity": null,
            "resource_url": "http://public2.vulnerablecode.io/vulnerabilities/VCID-3q38-re5x-rbaj"
        }
    ],
    "risk_score": null,
    "resource_url": "http://public2.vulnerablecode.io/packages/pkg:pypi/sqlalchemy@0.7.0b4"
}