Get Lookup Table Values

GET

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

GET

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

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 TABLE_ID = "your_entity_id"  # Get this from /lookup-tables
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/{TABLE_ID}",
17     headers=headers,
18     timeout=30.0
19 )
20 
21 data = response.json()
22 print(json.dumps(data, indent=2))

1 {
2   "table_id": "deal_types",
3   "name": "Deal Types",
4   "values": [
5     {
6       "code": "seed",
7       "label": "Seed Round"
8     },
9     {
10       "code": "series_a",
11       "label": "Series A"
12     },
13     {
14       "code": "series_b",
15       "label": "Series B"
16     },
17     {
18       "code": "series_c",
19       "label": "Series C"
20     },
21     {
22       "code": "series_d",
23       "label": "Series D"
24     },
25     {
26       "code": "ipo",
27       "label": "IPO"
28     },
29     {
30       "code": "acquisition",
31       "label": "Acquisition"
32     },
33     {
34       "code": "debt",
35       "label": "Debt Financing"
36     }
37   ]
38 }

Get values from a specific lookup table. Returns table data with codes, descriptions, and hierarchical relationships for reference data.

Authentication

AuthorizationBearer

Bearer token authentication using API key

Path parameters

tableIdstringRequired

Response

Successful response

table_idstring

Lookup table identifier

namestring

Table name

valueslist of objects

Table values

Errors

401

Unauthorized Error

404

Not Found Error

Authentication

Path parameters

Headers

Response

Errors