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(f"Table Name: {data.get('table_name')}")
23 print(f"Description: {data.get('description')}")

1 {
2   "success": true,
3   "data": {
4     "table_id": "sectors",
5     "rows": [
6       {
7         "code": "11",
8         "name": "Agriculture, Forestry, Fishing and Hunting"
9       },
10       {
11         "code": "21",
12         "name": "Mining, Quarrying, and Oil and Gas Extraction"
13       },
14       {
15         "code": "51",
16         "name": "Information"
17       },
18       {
19         "code": "52",
20         "name": "Finance and Insurance"
21       }
22     ],
23     "total": 4
24   }
25 }

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

Get Lookup Table Values

Authentication

Path parameters

Headers

Response

Errors