makegov / tango-public

Issue reporting for Tango.
2 stars 0 forks source link

Immediate Owner on Entity Endpoint Returns Null #6

Open Danlobaton opened 1 week ago

Danlobaton commented 1 week ago

Describe the bug The /entities/{uei} endpoint returns null for the immediate owner and highest level owner fields. I have tested this with VCH Partners whose highest level owner and immediate owner is Visual Connections (uei: P6C4HFH2RBB3)

To Reproduce Steps to reproduce the behavior:

  1. In production make a request to /entities/GL94VFFVFSG4
  2. The response will be
    {
    "uei": "GL94VFFVFSG4",
    "awards_summary": {
    "prime_awards": [
      {
        "agency_name": "Department of Veterans Affairs",
        "agency_id": "3600",
        "last_12_months": 1000,
        "last_36_months": 1000,
        "total": 1000,
        "naics": [
          541512
        ],
        "psc": [
          "DA01"
        ]
      },
      {
        "agency_name": "Federal Acquisition Service",
        "agency_id": "4732",
        "last_12_months": 0,
        "last_36_months": 0,
        "total": 0,
        "naics": [
          541511
        ],
        "psc": [
          "DA01"
        ]
      }
    ],
    "subawards": {
      "primes": [],
      "subs": []
    }
    },
    "registered": "NA",
    "cage_code": "7RDX2",
    "dodaac": "",
    "legal_business_name": "VCH PARTNERS LLC",
    "dba_name": "",
    "description": null,
    "capabilities": null,
    "keywords": null,
    "physical_address": {
    "city": "DENVER",
    "zip_code": "80210",
    "country_code": "USA",
    "address_line1": "2381 S JOSEPHINE ST",
    "address_line2": "",
    "zip_code_plus4": "5411",
    "state_or_province_code": "CO"
    },
    "mailing_address": {
    "city": "BLACKSBURG",
    "zip_code": "6568",
    "country_code": "VA",
    "address_line1": "2020 KRAFT DR STE 2400",
    "address_line2": "",
    "zip_code_plus4": "USA",
    "state_or_province_code": "24060"
    },
    "email_address": null,
    "purpose_of_registration_code": "Z2",
    "purpose_of_registration_desc": "All Awards",
    "registration_status": "Active",
    "evs_source": "E&Y",
    "sam_registration_date": "2016-11-10",
    "last_update_date": "2024-05-07",
    "sam_expiration_date": "2025-01-16",
    "sam_activation_date": "2024-01-19",
    "uei_status": "Active",
    "uei_expiration_date": null,
    "uei_creation_date": null,
    "public_display_flag": "",
    "exclusion_status_flag": "",
    "exclusion_url": null,
    "entity_url": "https://www.vchpartners.com/",
    "entity_division_name": "",
    "entity_division_number": "",
    "entity_start_date": "20161108",
    "fiscal_year_end_close_date": "1231",
    "submission_date": null,
    "congressional_district": "01",
    "entity_structure_code": "2L",
    "entity_structure_desc": "Corporate Entity (Not Tax Exempt)",
    "entity_type_code": null,
    "entity_type_desc": null,
    "profit_structure_code": "23",
    "profit_structure_desc": "Minority Owned Business",
    "organization_structure_code": null,
    "organization_structure_desc": null,
    "state_of_incorporation_code": "CO",
    "state_of_incorporation_desc": null,
    "country_of_incorporation_code": "USA",
    "country_of_incorporation_desc": null,
    "primary_naics": "541512",
    "naics_codes": [
    {
      "code": "541330",
      "sba_small_business": "E"
    },
    {
      "code": "541511",
      "sba_small_business": "Y"
    },
    {
      "code": "541512",
      "sba_small_business": "Y"
    },
    {
      "code": "541513",
      "sba_small_business": "Y"
    },
    {
      "code": "541519",
      "sba_small_business": "E"
    },
    {
      "code": "541611",
      "sba_small_business": "Y"
    },
    {
      "code": "561110",
      "sba_small_business": "Y"
    }
    ],
    "psc_codes": null,
    "business_types": [
    {
      "code": "23",
      "description": "Minority Owned Business"
    },
    {
      "code": "27",
      "description": "Self Certified Small Disadvantaged Business"
    },
    {
      "code": "2X",
      "description": "For Profit Organization"
    },
    {
      "code": "A5",
      "description": "Veteran Owned Business"
    },
    {
      "code": "JS",
      "description": "Small Business Joint Venture"
    },
    {
      "code": "JV",
      "description": "JV Service-Disabled Veteran-Owned Business Joint Venture"
    },
    {
      "code": "JX",
      "description": "Self-Certified HUBZone Joint Venture"
    },
    {
      "code": "LJ",
      "description": "Limited Liability Company"
    },
    {
      "code": "OY",
      "description": "Black American Owned"
    },
    {
      "code": "QF",
      "description": "Service Disabled Veteran Owned Business"
    }
    ],
    "sba_business_types": null,
    "highest_owner": null, # <------- Here as well
    "immediate_owner": null # <------ Here take a peep.
    }

Expected behavior I would expect Visual Connections to appear as both, the highest_owner and immediate_owner for VCH Partners.

I would expected the following pivots from each, the highest_owner and the immediate_owner.

{
    uei: x,
    cage: y,
    legal_name: z
}

Additional context Add any other context about the problem here.

Danlobaton commented 1 week ago

@infinityplusone tagged you directly on this again because I messed with the automatic assignment by accident.