Get Lookup Tables

GET

https://api.runcaptain.com/v2/datasets/odyssey/fundamentals/lookup-tables

GET

/v2/datasets/odyssey/fundamentals/lookup-tables

1 import requests
2 import json
3 
4 BASE_URL = "https://api.runcaptain.com"
5 API_KEY = "your_api_key"
6 ORG_ID = "your_organization_id"
7 ENTITY_ID = "your_entity_id"  # Not needed for list endpoint
8 
9 headers = {
10     "Authorization": f"Bearer {API_KEY}",
11     "X-Organization-ID": ORG_ID
12 }
13 
14 # You can also pass a domain (e.g., "openai.com") or name instead of entity_id
15 response = requests.get(
16     f"{BASE_URL}/v2/datasets/odyssey/fundamentals/lookup-tables",
17     headers=headers,
18     timeout=30.0
19 )
20 
21 data = response.json()
22 print(f"Name: {data.get('name')}")
23 print(f"Id: {data.get('id')}")

1 {
2   "success": true,
3   "data": {
4     "tables": [
5       {
6         "table_id": "industries",
7         "name": "Industry Classifications",
8         "description": "NAICS and SIC industry codes",
9         "row_count": 1057
10       },
11       {
12         "table_id": "sectors",
13         "name": "Economic Sectors",
14         "description": "High-level sector classifications",
15         "row_count": 11
16       },
17       {
18         "table_id": "countries",
19         "name": "Country Codes",
20         "description": "ISO country codes and names",
21         "row_count": 249
22       },
23       {
24         "table_id": "currencies",
25         "name": "Currency Codes",
26         "description": "ISO currency codes",
27         "row_count": 180
28       }
29     ]
30   }
31 }

Get available reference lookup tables including industry codes, country codes, and entity type classifications. Returns list of available tables with descriptions.

Authentication

AuthorizationBearer

Bearer token authentication using API key

Response

Successful response

Get Lookup Tables

Authentication

Headers

Response

Errors