Get Lookup Table Values

GET

https://api.captain.dev/v2/datasets/odyssey/fundamentals/lookup-tables/:tableId

Get values from a specific lookup table. Returns the rows of data for the specified table.

tableIdstringRequired

Successful Response

successbooleanOptional

dataobjectOptional

1	import requests
2
3	BASE_URL = "https://api.captain.dev"
4	API_KEY = "your_api_key"
5
6	headers = {"Authorization": f"Bearer {API_KEY}"}
7
8	response = requests.get(
9	f"{BASE_URL}/v2/datasets/odyssey/fundamentals/lookup-tables/sectors",
10	headers=headers,
11	timeout=60.0
12	)
13	print(response.json())

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	"total": 11
16	}
17	}