---
title: "SGX REIT Screener"
method: GET
path: "/v2/sgx/reits/"
tags: ["SGX - REITs"]
---

# SGX REIT Screener

`GET /v2/sgx/reits/`

## Request

- Base URL: `https://api.sectors.app`
- URL: `https://api.sectors.app/v2/sgx/reits/`
- Auth: API key in header `Authorization`

Filter and sort SGX-listed REITs with a SQL-like `where` or a natural-language `q`. You get back the REITs that match; add `include_query_values=true` to also see the numbers each one was filtered and sorted on. To get REIT's full financials metrics, use [SGX REIT Performance](https://docs.sectors.app/api-references/v2/singapore/reits/reit-performance).

**Query modes** (`q` overrides `where` and `order_by`):
- `q`: natural language, e.g. `industrial REITs with gearing below 40%`
- `where` + `order_by`: SQL-like structured query

<Accordion title="Years and latest">
Every metric is kept per year. Ask for a specific year with `aggregate_leverage[2025]`, or use `aggregate_leverage[latest]` to get each REIT's most recent year, since REITs close their books in different months. With `include_query_values=true`, every `field[latest]` also comes with `field[latest]_year` so you can see which year was used. `acquisition_count` and `divestment_count` need an actual year.
</Accordion>

<Accordion title="List fields">
Some fields hold several names: `countries`, `property_categories`, `tenant_names`, `tenant_industries`, `trade_mix_categories` and the management fields (`sponsor`, `trustee`, ...). `countries[latest] = 'Japan'` finds REITs with a property in Japan, `in ['Japan', 'China']` finds either, and `sponsor like '%CapitaLand%'` matches part of a name.
</Accordion>

<Note>Money is in SGD, and ratios are fractions (0.4 means 40%). `market_cap`, `last_close_price`, `distribution_yield` and `price_to_nav` are today's numbers.</Note>

<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=distribution_yield > 0.07`
- `where=sub_sector = 'Industrial' and price_to_nav < 1`
</Accordion>

- **symbol**: SGX REIT symbol, e.g. `A17U`, `C38U` (optional `.SI` suffix).
- **company_name**: REIT name.
- **sub_sector**: REIT sub-sector: Data Centre, Diversified, Healthcare, Hospitality, Industrial, Office or Retail.
- **market_cap**: Market capitalisation in SGD.
- **last_close_price**: Latest closing price in SGD.
- **distribution_yield**: Latest-year distribution per unit / latest price (fraction).
- **price_to_nav**: Latest price / latest-year NAV per unit.
</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=sponsor like '%CapitaLand%'`
</Accordion>

- **sponsor**: Sponsor(s).
- **trustee**: Trustee(s).
- **reit_manager**: REIT manager(s).
- **property_manager**: Property manager(s).
- **master_lessee**: Master lessee(s), where the REIT has one.
- **operator**: Operator(s), where the REIT has one.
</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=aggregate_leverage[latest] < 0.4`
- `where=countries[latest] = 'Japan'`
- `where=top_country[latest] = 'United Kingdom' and top_country_share[latest] > 0.5`
- `where=divestment_count[2025] > 0`
</Accordion>

- **period_end**: Last day of the financial year.
- **portfolio_value**: Portfolio valuation in SGD.
- **gross_revenue**: Gross revenue in SGD.
- **net_property_income**: Net property income in SGD.
- **portfolio_occupancy**: Portfolio occupancy (fraction).
- **distribution_per_unit**: Distribution per unit in SGD.
- **distribution_paid**: Distributions paid in SGD.
- **distribution_declared**: Distributions declared in SGD.
- **distributable_income_opening**: Distributable income at the start of the year, SGD.
- **income_for_year**: Distributable income for the year, SGD.
- **other_additions**: Other additions to distributable income, SGD.
- **amount_retained**: Distributable income retained, SGD.
- **distributable_income_closing**: Distributable income at the end of the year, SGD.
- **net_asset_value_per_unit**: NAV per unit in SGD.
- **units_in_issue**: Units in issue.
- **units_to_be_issued**: Units owed for manager and property-manager fees paid in units.
- **number_of_unitholders**: Number of unitholders.
- **aggregate_leverage**: Aggregate leverage (fraction; 0.4 = 40%).
- **interest_coverage_ratio**: Interest coverage ratio (times).
- **cost_of_debt**: Average cost of debt (fraction).
- **weighted_average_debt_maturity**: Weighted average debt maturity in years.
- **weighted_average_lease_expiry**: Weighted average lease expiry (WALE) in years.
- **property_count**: Number of properties held.
- **countries**: Countries where the REIT holds a property.
- **property_categories**: Property categories held, e.g. `Data Centers`.
- **top_country**: Country holding the largest share of portfolio value.
- **top_country_share**: Share of portfolio value in top_country (fraction).
- **tenant_names**: Names of the top tenants.
- **tenant_industries**: Industries of the top tenants.
- **trade_mix_categories**: Tenant trade categories in the income mix.
- **acquisition_count**: Property acquisitions completed in the year.
- **divestment_count**: Property divestments completed in the year.
</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=board_member_name like '%Tan%'`
</Accordion>

- **board_member_name**: Name of a board member of the REIT manager.
- **board_member_position**: Position of a board member, e.g. `Chairman`.
</Accordion>

</AccordionGroup>
</Accordion>

<Info>Costs 1 API credit per page. A natural-language `q` costs 3.</Info>

## Query parameters

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

## Response `200`

Paginated REITs matching the query.

- SgxReitList
  - `results` SgxReitListItem[], required
    - `symbol` string, required
    - `company_name` string, nullable, required
    - `query_values` unknown
  - `pagination` SgxReitListPagination, 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.

## Other responses

- `400`: Invalid where, order_by or query parameter.
- `429`: Rate limit exceeded.

## Changes

- **2026-11-03** `88c3e55f60fc`: 1 info
  - endpoint added

[Operation history](https://skmtc.dev/sectors/apis/sectors-api/changes/v2/sgx/reits/get.md)

---

[API](https://skmtc.dev/sectors/apis/sectors-api.md) - [All operations](https://skmtc.dev/sectors/apis/sectors-api/llms.txt) - [OpenAPI document](https://skmtc.dev/sectors/apis/sectors-api/revisions/88c3e55f60fc?raw)