Query CAP sample data (CSV mock)
query_cap_dataRun CQN-style queries against CAP sample data with filtering, sorting, pagination, and column projection.
Instructions
Executes a CQN-like query against the CAP sample data (CSV files in db/data following CAP conventions). Supports column projection, a WHERE-like filter (and/or, eq/ne/gt/ge/lt/le, contains), order by, skip/limit. Example filter: 'stock gt 10 and price le 50'.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| skip | No | Rows to skip | |
| limit | No | Max rows | |
| filter | No | WHERE-like filter, e.g. "stock > 0 and contains(title, 'Cat')" | |
| columns | No | Columns to project (default all) | |
| orderBy | No | Sort spec | |
| entityName | Yes | Entity name, e.g. 'Books' or 'my.bookshop.Books' | |
| projectPath | No | CAP project root |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file | Yes | ||
| rows | Yes | ||
| skip | Yes | ||
| count | Yes | Rows in this response | |
| limit | Yes | ||
| total | Yes | Rows matching the filter, before skip/limit | |
| columns | Yes | ||
| hasMore | Yes | ||
| nextSkip | Yes | Value to pass as skip on the next call, or null |