---
title: /wpda/table/select
description: "Returns dataset from table/view query ## Action Select ## Arguments **dbs***: Local database name or remote connection string (string) **tbl***: Table or view name (string) **col**: Table/view column names (object, value TRUE = queryable) **page_index**: Page number (integer, default=0, minimum=0)…"
url: "https://docs.legacy.wpdataaccess.com/docs/wpda-table-select/"
updated: "2025-11-20"
category: Data Explorer / REST API
---

# /wpda/table/select

Returns dataset from table/view query

## Action

Select

## Arguments

**dbs***: Local database name or remote connection string (string)
**tbl***: Table or view name (string)
**col**: Table/view column names (object, value TRUE = queryable)
**page_index**: Page number (integer, default=0, minimum=0)
**page_size**: Rows per page (0=all) (interger, default=10, minimum=1)
**search**: Global search filter (string)
**search_columns**: Column search filters (object)
**search_column_fns**: Column search filter modes (object)
**sorting**: Order by (array of { id and desc })
**row_count**: Row count (integer, minimum=0)
**row_count_estimate**: Calculate row count estimate (boolean)
**media**: For internal use only (object)
**client_side**: For internal use only (boolean)

## Column Filters

Column filters can be added using the **search_column** and **search_column_fns** parameters. You must provide both parameters! This feature requires a premium license.

#### Parameter search_columns format

```
[
    {
        "id": "book_id",
        "value": "8"
    }
]
```

#### Parameter search_column_fns format

```
{
    "book_id": "contains",
    "book_title": "contains",
    "book_author": "equals",
    "book_genre": "equals",
    "book_subgenre": "equals",
    "date_added": "contains"
}
```