# Get loan sale summaries for loans available for sale

**GET** `/loans/sales/summaries/available`

Get loan sale summaries for loans available for sale. Data returned by this API are updated daily after `loan_daily_summary` reports are generated. [Read more](/lending/report).

### Query Parameters

- `date` `string` — Effective date of the loan daily summary report. Format: `YYYY-MM-DD`. If not specified, loan sale summaries from the latest `loan_daily_summary` report will be returned.
- `expand` `array of strings` — List of fields to be expanded. Format: `expand=field_1&expand=field_2`. Available values: `loans` (return list of loan sale details).
- `loan_program_id` `string` — Filter loan sale summaries by loan program ID.

**Request**

```shell
curl 'https://api.column.com/loans/sales/summaries/available' \
  -u :<YOUR API KEY>
```

**Response 200**

```json
{
  "currency_code": "USD",
  "effective_date": "2024-01-15",
  "loan_count": 0,
  "loans": [
    {
      "fee": "10000",
      "id": "item_2Q1ctiJm1NypVqCt8UBC8e4xTfH",
      "interest": "10000",
      "loan_program_id": "lpgm_2Q1ctiJm1NypVqCt8UBC8e4xTfH",
      "principal": "10000",
      "sale_price": "10000"
    }
  ],
  "total_fee": "10000",
  "total_interest": "10000",
  "total_principal": "10000",
  "total_sale_price": "10000"
}
```