---
title: "Companies Screener"
method: GET
path: "/v2/companies/"
tags: ["Company Screener"]
---

# Companies Screener

`GET /v2/companies/`

High-performance API for filtering and sorting IDX-listed companies. Supports both structured SQL-like queries (`where`, `order_by`) and natural language queries (`q`). Returns a paginated list of companies.

**Query modes** (mutually exclusive — `q` overrides all others):
- `q`: Natural language, e.g. `top 10 tech companies by revenue in 2023`
- `where` + `order_by`: SQL-like structured query

<Note>For the most precise natural language results, filter by sector/industry slugs. Retrieve the complete slug list from the [Subsectors](./helper-list/subsectors), [Industries](./helper-list/industries), or [Subindustries](./helper-list/subindustries) endpoints.</Note>

<Accordion title="Smart FY Handling">
To account for reporting lags, 'latest year' queries made between January and April default to the previous audited year (e.g. a query in early 2026 uses 2024 data).
</Accordion>

<Accordion title="Syntax and Operators">
**Operators:** `=`, `!=`, `>`, `>=`, `<`, `<=`, `like`, `in`

**Logic:** combine conditions with `and` and `or`

**String values:** use single or double quotes — `sector = 'Technology'`

**Lists (for `in`):** `tags in ['blue-chip', 'dividend']`
</Accordion>

<Accordion title="Yearly and Forecast Data">
Access historical or forecast data using bracket notation: `field[YYYY]`

Examples: `revenue[2023] > 100000000000` or `forecast_eps_growth[2025] > 0.15`
</Accordion>

<Accordion title="Arithmetic Expressions">
Perform calculations within your query on both sides of a condition.

Examples: `revenue[2024] / total_assets[2024] > 0.5` or `revenue[2024] > revenue[2023] * 1.2`
</Accordion>

<Accordion title="Available Fields">
<AccordionGroup>

<Accordion title="Direct Fields (Top-level columns)">
**How to Use:** Query these fields directly using standard operators (`=`, `!=`, `>`, `<`, `LIKE`, `IN`). String comparisons are case-insensitive.

<Accordion title="Examples">
- `where=market_cap > 500000000000000`
- `where=company_name like '%energi%'`
- `where=sector = 'Financials' and listing_date > '2005-01-01'`
</Accordion>

- **symbol**: IDX ticker symbol (e.g. BBCA, TLKM)
- **company_name**: Full registered company name
- **listing_board**: IDX board: Main, Development, or Acceleration
- **industry**: IDX industry classification
- **sub_industry**: IDX sub-industry classification
- **sector**: IDX sector classification (broader than industry)
- **sub_sector**: IDX sub-sector classification
- **market_cap**: Market capitalisation in IDR
- **market_cap_rank**: Rank by market cap among all IDX companies (1 = largest)
- **employee_num**: Total number of employees
- **employee_num_rank**: Rank by employee count among all IDX companies
- **listing_date**: Date the company was first listed on IDX
- **last_ex_dividend_date**: Most recent ex-dividend date
- **last_close_price**: Latest closing price in IDR
- **daily_close_change**: Day-over-day closing price change as a decimal
- **forward_pe**: Forward price-to-earnings ratio based on next year earnings estimate
- **intrinsic_value**: Estimated intrinsic value per share in IDR
- **esg_score**: ESG (Environmental, Social, Governance) composite score
- **yield_ttm**: Dividend yield over the trailing twelve months
- **dividend_ttm**: Total dividends paid per share over the trailing twelve months in IDR
- **payout_ratio**: Proportion of earnings paid out as dividends
- **cash_payout_ratio**: Proportion of free cash flow paid out as dividends
- **yoy_quarter_earnings_growth**: Year-over-year earnings growth based on the most recent quarter
- **yoy_quarter_revenue_growth**: Year-over-year revenue growth based on the most recent quarter
</Accordion>

<Accordion title="Array Fields">
**How to Use:** Query using the `in` operator to check if any of the provided values exist in the array.

<Accordion title="Examples">
- `where=indices in ['LQ45', 'IDX30']`
- `where=tags in ['52-w-high', 'public-float-under-25']`
</Accordion>

- **tags**: Analyst sentiment tags (e.g. 'bullish'). Filter with `in` operator.
- **indices**: IDX indices this stock belongs to (e.g. LQ45, IDX30). Filter with `in` operator.
- **affiliates**: Related company tickers (affiliates/group entities)
</Accordion>

<Accordion title="JSON Object Fields (Most Recent Data)">
**How to Use:** Query as if they were direct fields — the parser automatically extracts the value from the underlying JSON.

<Accordion title="Examples">
- `where=pe_ttm < 15 and roe_ttm > 0.1`
- `where=last_close_price < all_time_high_price`
- `where=ytd_low_date > '2025-03-01'`
</Accordion>

- **pe_ttm**: Price-to-earnings ratio (trailing twelve months)
- **pb_mrq**: Price-to-book ratio (most recent quarter)
- **ps_ttm**: Price-to-sales ratio (trailing twelve months)
- **dar_mrq**: Debt-to-assets ratio (most recent quarter)
- **der_mrq**: Debt-to-equity ratio (most recent quarter)
- **roa_ttm**: Return on assets (trailing twelve months)
- **roe_ttm**: Return on equity (trailing twelve months)
- **total_assets_mrq**: Total assets in IDR (most recent quarter)
- **total_equity_mrq**: Total shareholders equity in IDR (most recent quarter)
- **total_revenue_mrq**: Total revenue in IDR (most recent quarter)
- **earnings_mrq**: Net profit/loss in IDR (most recent quarter)
- **total_liabilities_mrq**: Total liabilities in IDR (most recent quarter)
- **yearly_mcap_change**: Year-over-year market cap change as a decimal
- **dividend_yield_avg_period**: Number of years used to compute average dividend yield
- **dividend_yield_avg**: Average annual dividend yield over the period
- **ytd_low_price**: Year-to-date lowest closing price in IDR
- **ytd_low_date**: Date of the year-to-date lowest closing price
- **ytd_high_price**: Year-to-date highest closing price in IDR
- **ytd_high_date**: Date of the year-to-date highest closing price
- **52_w_low_price**: 52-week lowest closing price in IDR
- **52_w_low_date**: Date of the 52-week lowest closing price
- **52_w_high_price**: 52-week highest closing price in IDR
- **52_w_high_date**: Date of the 52-week highest closing price
- **90_d_low_price**: 90-day lowest closing price in IDR
- **90_d_low_date**: Date of the 90-day lowest closing price
- **90_d_high_price**: 90-day highest closing price in IDR
- **90_d_high_date**: Date of the 90-day highest closing price
- **all_time_low_price**: All-time lowest closing price in IDR
- **all_time_low_date**: Date of the all-time lowest closing price
- **all_time_high_price**: All-time highest closing price in IDR
- **all_time_high_date**: Date of the all-time highest closing price
</Accordion>

<Accordion title="Yearly JSON Fields (Historical & Forecast Data)">
**How to Use:** Must use bracket notation `field[YYYY]` to access data for a specific year. Supports all numeric operators, field-to-field comparisons, and arithmetic expressions.

<Accordion title="Examples">
- `where=revenue[2023] > earnings[2023] * 5`
- `where=roe[2023] > 0.15 and roe[2022] > 0.15`
- `where=pe[2024] < pe_peer_avg[2024]`
</Accordion>

- **eps**: Earnings per share for the year. Use: `eps[2024]`.
- **eps_growth**: Year-over-year EPS growth rate. Use: `eps_growth[2024]`.
- **total_dividend**: Total dividends paid per share for the year. Use: `total_dividend[2024]`.
- **total_yield**: Total dividend yield for the year. Use: `total_yield[2024]`.
- **earnings**: Annual net profit/loss in IDR. Use: `earnings[2024]`.
- **allowance_for_loans**: Allowance for loan losses in IDR. Use: `allowance_for_loans[2024]`. (banking)
- **capital_expenditure**: Capital expenditure in IDR. Use: `capital_expenditure[2024]`.
- **cash_and_equivalents**: Cash and cash equivalents in IDR. Use: `cash_and_equivalents[2024]`.
- **cash_inflow**: Total cash inflow in IDR. Use: `cash_inflow[2024]`.
- **cash_only**: Cash excluding equivalents in IDR. Use: `cash_only[2024]`.
- **cash_outflow**: Total cash outflow in IDR. Use: `cash_outflow[2024]`.
- **core_capital_tier1**: Tier 1 core capital in IDR. Use: `core_capital_tier1[2024]`. (banking)
- **cost_of_revenue**: Cost of goods sold / cost of revenue in IDR. Use: `cost_of_revenue[2024]`.
- **credit_rwa**: Credit risk-weighted assets in IDR. Use: `credit_rwa[2024]`. (banking)
- **current_account**: Current account deposits in IDR. Use: `current_account[2024]`. (banking)
- **current_assets**: Total current assets in IDR. Use: `current_assets[2024]`.
- **current_liabilities**: Total current liabilities in IDR. Use: `current_liabilities[2024]`.
- **earnings_before_tax**: Earnings before income tax in IDR. Use: `earnings_before_tax[2024]`.
- **ebit**: Earnings before interest and tax in IDR. Use: `ebit[2024]`.
- **ebitda**: Earnings before interest, tax, depreciation and amortisation in IDR. Use: `ebitda[2024]`.
- **end_cash_position**: Ending cash position from the cash flow statement in IDR. Use: `end_cash_position[2024]`.
- **financing_cash_flow**: Net cash from financing activities in IDR. Use: `financing_cash_flow[2024]`.
- **fixed_assets**: Net property, plant and equipment in IDR. Use: `fixed_assets[2024]`.
- **free_cash_flow**: Operating cash flow minus capex in IDR. Use: `free_cash_flow[2024]`.
- **gross_loan**: Gross loan portfolio before allowances in IDR. Use: `gross_loan[2024]`. (banking)
- **gross_profit**: Revenue minus cost of revenue in IDR. Use: `gross_profit[2024]`.
- **high_quality_liquid_asset**: High-quality liquid assets (HQLA) held in IDR. Use: `high_quality_liquid_asset[2024]`. (banking)
- **interest_expense**: Total interest expense in IDR. Use: `interest_expense[2024]`.
- **interest_expense_non_operating**: Non-operating interest expense in IDR. Use: `interest_expense_non_operating[2024]`.
- **interest_income**: Total interest income in IDR. Use: `interest_income[2024]`.
- **inventories**: Inventories on the balance sheet in IDR. Use: `inventories[2024]`.
- **investing_cash_flow**: Net cash from investing activities in IDR. Use: `investing_cash_flow[2024]`.
- **market_rwa**: Market risk-weighted assets in IDR. Use: `market_rwa[2024]`. (banking)
- **net_cash_flow**: Net change in cash for the period in IDR. Use: `net_cash_flow[2024]`.
- **net_interest_income**: Interest income minus interest expense in IDR. Use: `net_interest_income[2024]`. (banking)
- **net_loan**: Net loans after allowances in IDR. Use: `net_loan[2024]`. (banking)
- **net_premium_income**: Net insurance premium income in IDR. Use: `net_premium_income[2024]`. (insurance)
- **non_current_liabilities**: Long-term liabilities in IDR. Use: `non_current_liabilities[2024]`.
- **non_interest_bearing_liabilities**: Liabilities that do not accrue interest in IDR. Use: `non_interest_bearing_liabilities[2024]`. (banking)
- **non_interest_income**: Fee and commission income outside of interest in IDR. Use: `non_interest_income[2024]`. (banking)
- **non_loan_assets**: Total assets excluding loans in IDR. Use: `non_loan_assets[2024]`. (banking)
- **non_loan_earning_assets**: Interest-earning assets excluding loans in IDR. Use: `non_loan_earning_assets[2024]`. (banking)
- **non_loan_non_earning_assets**: Non-earning assets excluding loans in IDR. Use: `non_loan_non_earning_assets[2024]`. (banking)
- **non_operating_income_or_loss**: Income or losses outside core operations in IDR. Use: `non_operating_income_or_loss[2024]`.
- **operating_cash_flow**: Net cash generated from core operations in IDR. Use: `operating_cash_flow[2024]`.
- **operating_expense**: Total operating expenses in IDR. Use: `operating_expense[2024]`.
- **operating_pnl**: Operating profit/loss (revenue minus operating expenses) in IDR. Use: `operating_pnl[2024]`.
- **operational_rwa**: Operational risk-weighted assets in IDR. Use: `operational_rwa[2024]`. (banking)
- **other_interest_bearing_liabilities**: Other interest-bearing liabilities excluding deposits in IDR. Use: `other_interest_bearing_liabilities[2024]`. (banking)
- **outstanding_shares**: Total shares outstanding. Use: `outstanding_shares[2024]`.
- **prepaid_assets**: Prepaid expenses and other current assets in IDR. Use: `prepaid_assets[2024]`.
- **premium_expense**: Insurance premium expenses in IDR. Use: `premium_expense[2024]`. (insurance)
- **premium_income**: Gross insurance premium income in IDR. Use: `premium_income[2024]`. (insurance)
- **provision**: Provision for loan losses or liabilities in IDR. Use: `provision[2024]`.
- **realized_capital_goods_investment**: Realised investment in capital goods in IDR. Use: `realized_capital_goods_investment[2024]`.
- **retained_earnings**: Cumulative retained earnings on balance sheet in IDR. Use: `retained_earnings[2024]`.
- **revenue**: Annual total revenue in IDR. Use: `revenue[2024]`.
- **savings_account**: Savings account deposits in IDR. Use: `savings_account[2024]`. (banking)
- **supplementary_capital_tier2**: Tier 2 supplementary capital in IDR. Use: `supplementary_capital_tier2[2024]`. (banking)
- **tax**: Income tax expense in IDR. Use: `tax[2024]`.
- **time_deposit**: Time deposit liabilities in IDR. Use: `time_deposit[2024]`. (banking)
- **total_assets**: Total assets on the balance sheet in IDR. Use: `total_assets[2024]`.
- **total_capital**: Total regulatory capital in IDR. Use: `total_capital[2024]`. (banking)
- **total_cash_and_due_from_banks**: Cash and amounts due from other banks in IDR. Use: `total_cash_and_due_from_banks[2024]`. (banking)
- **total_debt**: Total interest-bearing debt in IDR. Use: `total_debt[2024]`.
- **total_deposit**: Total customer deposits in IDR. Use: `total_deposit[2024]`. (banking)
- **total_equity**: Total shareholders equity in IDR. Use: `total_equity[2024]`.
- **total_liabilities**: Total liabilities on the balance sheet in IDR. Use: `total_liabilities[2024]`.
- **total_risk_weighted_asset**: Total risk-weighted assets in IDR. Use: `total_risk_weighted_asset[2024]`. (banking)
- **special_mention_loan**: Special mention (watch-list) loans in IDR. Use: `special_mention_loan[2024]`. (banking)
- **non_performing_loan**: Non-performing loans (NPL) in IDR. Use: `non_performing_loan[2024]`. (banking)
- **restructured_loan_current**: Restructured loans currently performing in IDR. Use: `restructured_loan_current[2024]`. (banking)
- **forecast_eps_growth**: Analyst consensus EPS growth forecast. Use: `forecast_eps_growth[2025]`.
- **forecast_revenue_growth**: Analyst consensus revenue growth forecast. Use: `forecast_revenue_growth[2025]`.
- **forecast_eps_estimate**: Analyst consensus EPS estimate in IDR. Use: `forecast_eps_estimate[2025]`.
- **forecast_revenue_estimate**: Analyst consensus revenue estimate in IDR. Use: `forecast_revenue_estimate[2025]`.
- **pe**: Price-to-earnings ratio for the year. Use: `pe[2024]`.
- **pb**: Price-to-book ratio for the year. Use: `pb[2024]`.
- **ps**: Price-to-sales ratio for the year. Use: `ps[2024]`.
- **pcf**: Price-to-cash-flow ratio for the year. Use: `pcf[2024]`.
- **peg**: Price/earnings-to-growth ratio for the year. Use: `peg[2024]`.
- **enterprise_to_ebitda**: Enterprise value to EBITDA for the year. Use: `enterprise_to_ebitda[2024]`.
- **enterprise_to_revenue**: Enterprise value to revenue for the year. Use: `enterprise_to_revenue[2024]`.
- **pb_peer_avg**: Peer average price-to-book ratio for the year. Use: `pb_peer_avg[2024]`.
- **pe_peer_avg**: Peer average price-to-earnings ratio for the year. Use: `pe_peer_avg[2024]`.
- **ps_peer_avg**: Peer average price-to-sales ratio for the year. Use: `ps_peer_avg[2024]`.
- **debt_to_asset_ratio**: Total debt divided by total assets. Use: `debt_to_asset_ratio[2024]`.
- **debt_to_equity_ratio**: Total debt divided by shareholders equity. Use: `debt_to_equity_ratio[2024]`.
- **cash_flow_to_debt_ratio**: Operating cash flow divided by total debt. Use: `cash_flow_to_debt_ratio[2024]`.
- **interest_coverage_ratio**: EBIT divided by interest expense. Use: `interest_coverage_ratio[2024]`.
- **current_ratio**: Current assets divided by current liabilities. Use: `current_ratio[2024]`.
- **operating_cash_flow_margin**: Operating cash flow as a percentage of revenue. Use: `operating_cash_flow_margin[2024]`.
- **fixed_asset_turnover**: Revenue divided by net fixed assets. Use: `fixed_asset_turnover[2024]`.
- **total_asset_turnover**: Revenue divided by total assets. Use: `total_asset_turnover[2024]`.
- **roa**: Return on assets for the year. Use: `roa[2024]`.
- **roe**: Return on equity for the year. Use: `roe[2024]`.
- **net_profit_margin**: Net profit as a percentage of revenue. Use: `net_profit_margin[2024]`.
- **gross_profit_margin**: Gross profit as a percentage of revenue. Use: `gross_profit_margin[2024]`.
- **operating_profit_margin**: Operating profit as a percentage of revenue. Use: `operating_profit_margin[2024]`.
- **capital_adequacy_ratio**: Regulatory capital as a percentage of risk-weighted assets. Use: `capital_adequacy_ratio[2024]`. (banking)
- **casa_ratio**: Current and savings account deposits as a share of total deposits. Use: `casa_ratio[2024]`. (banking)
- **leverage_ratio**: Tier 1 capital divided by total exposure. Use: `leverage_ratio[2024]`. (banking)
- **loan_to_deposit_ratio**: Net loans divided by total deposits. Use: `loan_to_deposit_ratio[2024]`. (banking)
- **liquidity_coverage_ratio**: HQLA divided by net cash outflows over 30 days. Use: `liquidity_coverage_ratio[2024]`. (banking)
- **efficiency_ratio**: Operating expenses divided by net revenue. Use: `efficiency_ratio[2024]`.
- **net_interest_margin**: Net interest income as a percentage of earning assets. Use: `net_interest_margin[2024]`. (banking)
- **cost_to_income_ratio**: Operating costs divided by operating income. Use: `cost_to_income_ratio[2024]`.
</Accordion>

<Accordion title="Quarterly Financial Data">
**How to Use:** Must use bracket notation `field[Qi-YYYY]` to access data for a specific quarter.

<Accordion title="Examples">
- `where=revenue_q[Q1-2024] > 1000000000`
- `where=earnings_q[Q4-2023] > earnings_q[Q3-2023]`
</Accordion>

- **revenue_q**: Quarterly revenue in IDR. Use: `revenue_q[Q1-2024]`.
- **earnings_q**: Quarterly net profit/loss in IDR. Use: `earnings_q[Q1-2024]`.
- **net_loan_q**: Quarterly net loans in IDR. Use: `net_loan_q[Q1-2024]`. (banking)
- **gross_profit_q**: Quarterly gross profit in IDR. Use: `gross_profit_q[Q1-2024]`.
- **time_deposit_q**: Quarterly time deposits in IDR. Use: `time_deposit_q[Q1-2024]`. (banking)
- **operating_pnl_q**: Quarterly operating profit/loss in IDR. Use: `operating_pnl_q[Q1-2024]`.
- **total_deposit_q**: Quarterly total deposits in IDR. Use: `total_deposit_q[Q1-2024]`. (banking)
- **ebit_q**: Quarterly EBIT in IDR. Use: `ebit_q[Q1-2024]`.
- **ebitda_q**: Quarterly EBITDA in IDR. Use: `ebitda_q[Q1-2024]`.
- **earnings_before_tax_q**: Quarterly earnings before tax in IDR. Use: `earnings_before_tax_q[Q1-2024]`.
- **tax_q**: Quarterly income tax expense in IDR. Use: `tax_q[Q1-2024]`.
- **cost_of_revenue_q**: Quarterly cost of revenue in IDR. Use: `cost_of_revenue_q[Q1-2024]`.
- **current_account_q**: Quarterly current account deposits in IDR. Use: `current_account_q[Q1-2024]`. (banking)
- **interest_income_q**: Quarterly interest income in IDR. Use: `interest_income_q[Q1-2024]`. (banking)
- **premium_expense_q**: Quarterly premium expenses in IDR. Use: `premium_expense_q[Q1-2024]`. (insurance)
- **savings_account_q**: Quarterly savings account deposits in IDR. Use: `savings_account_q[Q1-2024]`. (banking)
- **interest_expense_q**: Quarterly interest expense in IDR. Use: `interest_expense_q[Q1-2024]`.
- **operating_expense_q**: Quarterly operating expenses in IDR. Use: `operating_expense_q[Q1-2024]`.
- **non_operating_income_or_loss_q**: Quarterly non-operating income/loss in IDR. Use: `non_operating_income_or_loss_q[Q1-2024]`.
- **interest_expense_non_operating_q**: Quarterly non-operating interest expense in IDR. Use: `interest_expense_non_operating_q[Q1-2024]`.
- **non_interest_bearing_liabilities_q**: Quarterly non-interest-bearing liabilities in IDR. Use: `non_interest_bearing_liabilities_q[Q1-2024]`. (banking)
- **realized_capital_goods_investment_q**: Quarterly realised capital goods investment in IDR. Use: `realized_capital_goods_investment_q[Q1-2024]`.
- **other_interest_bearing_liabilities_q**: Quarterly other interest-bearing liabilities in IDR. Use: `other_interest_bearing_liabilities_q[Q1-2024]`. (banking)
- **total_assets_q**: Quarterly total assets in IDR. Use: `total_assets_q[Q1-2024]`.
- **current_assets_q**: Quarterly current assets in IDR. Use: `current_assets_q[Q1-2024]`.
- **total_liabilities_q**: Quarterly total liabilities in IDR. Use: `total_liabilities_q[Q1-2024]`.
- **net_premium_income_q**: Quarterly net premium income in IDR. Use: `net_premium_income_q[Q1-2024]`. (insurance)
- **allowance_for_loans_q**: Quarterly allowance for loan losses in IDR. Use: `allowance_for_loans_q[Q1-2024]`. (banking)
- **current_liabilities_q**: Quarterly current liabilities in IDR. Use: `current_liabilities_q[Q1-2024]`.
- **non_current_liabilities_q**: Quarterly non-current liabilities in IDR. Use: `non_current_liabilities_q[Q1-2024]`.
- **total_equity_q**: Quarterly total equity in IDR. Use: `total_equity_q[Q1-2024]`.
- **total_debt_q**: Quarterly total debt in IDR. Use: `total_debt_q[Q1-2024]`.
- **cash_only_q**: Quarterly cash (excluding equivalents) in IDR. Use: `cash_only_q[Q1-2024]`.
- **provision_q**: Quarterly provision for losses in IDR. Use: `provision_q[Q1-2024]`.
- **gross_loan_q**: Quarterly gross loans before allowances in IDR. Use: `gross_loan_q[Q1-2024]`. (banking)
- **total_cash_and_due_from_banks_q**: Quarterly cash and amounts due from banks in IDR. Use: `total_cash_and_due_from_banks_q[Q1-2024]`. (banking)
- **operating_cash_flow_q**: Quarterly operating cash flow in IDR. Use: `operating_cash_flow_q[Q1-2024]`.
- **investing_cash_flow_q**: Quarterly investing cash flow in IDR. Use: `investing_cash_flow_q[Q1-2024]`.
- **financing_cash_flow_q**: Quarterly financing cash flow in IDR. Use: `financing_cash_flow_q[Q1-2024]`.
- **net_interest_income_q**: Quarterly net interest income in IDR. Use: `net_interest_income_q[Q1-2024]`. (banking)
- **non_interest_income_q**: Quarterly non-interest income in IDR. Use: `non_interest_income_q[Q1-2024]`. (banking)
- **free_cash_flow_q**: Quarterly free cash flow in IDR. Use: `free_cash_flow_q[Q1-2024]`.
- **premium_income_q**: Quarterly gross premium income in IDR. Use: `premium_income_q[Q1-2024]`. (insurance)
- **capital_expenditure_q**: Quarterly capital expenditure in IDR. Use: `capital_expenditure_q[Q1-2024]`.
</Accordion>

<Accordion title="JSON List Fields">
**How to Use:** The query checks if **any** object in the list matches the condition. Use `=` or `like` for strings, numeric operators for numbers.

<Accordion title="Examples">
- `where=major_shareholders_name like 'PT%' and major_shareholders_share_percentage > 0.1`
- `where=key_executives_name = 'Prajogo Pangestu'`
</Accordion>

- **key_executives_name**: Filter by executive name in the key_executives list. Use `like` operator.
- **key_executives_position**: Filter by executive position/title in the key_executives list. Use `like` operator.
- **executives_shareholdings_name**: Filter by executive name in the shareholdings list.
- **executives_shareholdings_share_amount**: Filter by executive share amount (number of shares).
- **executives_shareholdings_share_percentage**: Filter by executive ownership percentage.
- **major_shareholders_name**: Filter by major shareholder name. Use `like` operator.
- **major_shareholders_share_value**: Filter by major shareholder share value in IDR.
- **major_shareholders_share_amount**: Filter by major shareholder number of shares.
- **major_shareholders_share_percentage**: Filter by major shareholder ownership percentage.
- **free_float**: Public (non-insider) ownership percentage from major_shareholders. Value is a decimal (0.45 = 45%).
</Accordion>

</AccordionGroup>
</Accordion>

<Info>Costs 1 API credit for structured queries. Using the natural-language `?q=` parameter costs 3 API credits.</Info>

## Query parameters

- `where` string
- `q` string
- `order_by` string
- `desc` boolean
- `limit` integer
- `offset` integer
- `include_query_values` boolean

## Response `200`

Paginated list of companies matching the query.

- CompanyScreenerResponse
  - `results` CompanyScreenerItem[], required
    - `symbol` string, required — Ticker symbol (e.g. BBCA.JK).
    - `company_name` string, required — Full registered company name.
    - `query_values` unknown
  - `pagination` CompanyScreenerPagination, required
    - `total_count` integer, required — Total number of matching results.
    - `showing` integer, required — Number of results in this page.
    - `limit` integer, required — Maximum results per page.
    - `offset` integer, required — Number of results skipped.
    - `has_next` boolean, required — Whether a next page exists.
    - `has_previous` boolean, required — Whether a previous page exists.
    - `next_offset` integer, nullable, required — Offset for the next page, or null.
    - `previous_offset` integer, nullable, required — Offset for the previous page, or null.
  - `llm_translation` LLMTranslation, required
    - `natural_query` string, required — The original natural language query.
    - `translated_params` object, required — Structured query params generated by the LLM.
    - `message` string, required — Explanation of the translation.

## Other responses

- `400` — Bad request — invalid parameters, field names, operators, or query syntax.
- `429` — Rate limit exceeded.

---

[API](https://skmtc.dev/sectors/apis/sectors-api.md) · [All operations](https://skmtc.dev/sectors/apis/sectors-api/llms.txt) · [OpenAPI document](https://skmtc-service-production.skmtc.workers.dev/v1/apis/sectors/sectors-api/revisions/49e492f19d77/schema)
