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.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]annual_dividend_total.annual_dividend_yield.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"market_cap" or "revenue[2024]"). Use a
comma-separated list for multi-level sorting. This parameter is ignored if
q is present.order_by. Use true for descending order. This
parameter is ignored if q is present.q is present.q is present.q parameter). This
object shows how the natural language query was translated into structured API
parameters.