====== 1.2 Query Parameters ======

Parameters for filtering, sorting, and paginating data.

===== OData-compatible Parameters =====

^ Parameter ^ Description ^ Example ^
| ''$select'' | Select columns | ''$select=Id,Name'' |
| ''$filter'' | Filter rows | ''$filter=Country eq 'DE''' |
| ''$orderby'' | Sorting | ''$orderby=Name desc'' |
| ''$top'' | Limit count | ''$top=10'' |
| ''$skip'' | Skip records | ''$skip=20'' |
| ''$count'' | Total count | ''$count=true'' |
| ''$search'' | Full-text search | ''$search=Berlin'' |

===== JSON Options =====

^ Parameter ^ Description ^
| ''$json'' | JSON structure (nested/flat) |
| ''$jsonRoot'' | Root element name |
| ''$jsonIncludeNulls'' | Include null values |

===== Example =====

<code>
GET /api/v1/dsn/demo/tables/Customers?$top=10&$filter=Country eq 'Germany'&$orderby=Name&$select=Id,Name,City
</code>