This Choreo retrieves all of the companies that are "below" a given company which is listed as a "TopParent" (AKA the highest-level owning parent of a family of corporations). You do not need an API Key to run this Choreo. However, if you would like a much higher limit on the number of calls you can make each day, then registering with CorpWatch and obtaining an API Key is the way to go. More information on authentication and limits is available here. Detailed information about top parents is here.
The top_parent_id field in a company's CorpWatch record is the API's best guess at the ID of the highest-level owning parent of a family of corporations. Assuming that the guess is accurate, a query using this Choreo will return all of the companies that are "below" the given company in the hierarchy.
We can pull a listing of subsidiaries of Whole Foods with the following input:
CWID: cw_7324
ResponseType: json
The following is a partial sample of the output returned by this Choreo:
{
"meta": {
"success": 1,
"status": 200,
"status_string": "Success",
"total_results": "57",
"results_complete": 1,
"api_version": "0.04 (2012-02-03)",
"parameters": {
"top_parent_id": "cw_7324",
"limit": 100,
"index": 0,
"year": "most_recent"
}
},
"result": {
"companies": {
"cw_7324": {
"cw_id": "cw_7324",
"cik": "865436",
"company_name": "WHOLE FOODS MARKET INC",
"irs_number": "741989366",
"sic_code": "5411",
"industry_name": "Retail-grocery stores",
"sic_sector": "5400",
"sector_name": "Food stores",
"source_type": "filers",
"raw_address": "550 BOWIE STREET, AUSTIN TX 78703",
"country_code": "US",
"subdiv_code": "TX",
"top_parent_id": "cw_7324",
"num_parents": "0",
"num_children": "0",
"max_year": "2012",
"min_year": "2003"
},
"cw_213344": {
"cw_id": "cw_213344",
"cik": "0",
"company_name": "Allegro Coffee Co",
"irs_number": null,
"sic_code": null,
"industry_name": null,
"sic_sector": null,
"sector_name": null,
"source_type": "relationships",
"raw_address": "Colorado",
"country_code": "US",
"subdiv_code": "CO",
"top_parent_id": "cw_7324",
"num_parents": "1",
"num_children": "0",
"max_year": "2011",
"min_year": "2003"
},