High-performance API for filtering and sorting companies with a SQL-like interface. Supports both structured queries (where, order_by) and natural language queries (q). Returns a paginated list of companies.
"top 10 tech companies by revenue in 2023").
When q is provided, all other query parameters (where, order_by, etc.)
are ignored, as the LLM will generate them.Query Capabilities & Logic
q
is present.Syntax and Operators
=, !=, >, >=, <, <=, like, in.and and or.sector = 'Technology'), numbers directly (e.g., market_cap > 1000000000000),
and lists for the in operator (e.g., tags in ['blue-chip', 'dividend']).Yearly and Forecast Data
field[YYYY].revenue[2023] > 100000000000 or forecast_eps_growth[2025] > 0.15.Arithmetic Expressions
revenue[2024] / total_assets[2024] > 0.5 or revenue[2024] > revenue[2023] * 1.2.Available Fields
Direct Fields (Top-level columns)
=, !=, >, <, LIKE, IN). For string fields, LIKE and = are case-insensitive.Examples
where=market_cap > 500000000000000where=company_name like '%energi%'where=sector = 'Financials' and listing_date > '2005-01-01'BBCA.JK).
Main).
Banks).
Financials).
YYYY-MM-DD).
YYYY-MM-DD).
Array Fields
in operator to check if any of the provided values exist in the array.Examples
where=indices in ['LQ45', 'IDX30']where=tags in ['52-w-high', 'public-float-under-25']insider-1-month-buy).KOMPAS100).JSON Object Fields (Most Recent Data)
Examples
where=pe_ttm < 15 and roe_ttm > 0.1where=last_close_price < all_time_high_pricewhere=ytd_low_date > '2025-03-01'Yearly JSON Fields (Historical & Forecast Data)
field[YYYY] to access data for a specific year. These fields support all numeric operators, field-to-field comparisons, and arithmetic expressions.Examples
where=revenue[2023] > earnings[2023] * 5where=roe[2023] > 0.15 and roe[2022] > 0.15where=pe[2024] < pe_peer_avg[2024]Quarterly Financial Data
field[Qi-YYYY] to access data for a specific quarter.Examples
where=revenue_q[Q1-2024] > 1000000000where=earnings_q[Q4-2023] > earnings_q[Q3-2023]Q1-2024).General JSON List Fields
= or like for string properties and numeric operators (>, <, etc.) for numeric properties.Examples
where=major_shareholders_name like 'PT%' and major_shareholders_share_percentage > 0.1where=key_executives_name = 'Prajogo Pangestu'where=executives_shareholdings_share_percentage > 0.01- prefix for descending order (e.g., order_by="-market_cap").order_by="-(earnings[2024]/earnings[2023])").q is present.q is present.q is present.true, the response will include a query_values object showing the
interpreted values used for the query (e.g., extracted year, country).q parameter). This
object shows how the natural language query was translated into structured API
parameters.