GetCDSViewContents
Query CDS view data with filtering, pagination, parameters, and batch mode. Retrieve specific columns, apply WHERE conditions, sort results, and run up to five queries in a single call.
Instructions
Query CDS view data with filtering, pagination, parameter support, and batch queries. Either provide view_name for a single query, or provide queries array for batch mode.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| offset | No | Optional: Number of rows to skip for pagination (default: 0). Warning: CDS views recalculate on each query. | |
| columns | No | Optional: Specific columns to retrieve (default: all columns). Column names are validated against view metadata. | |
| queries | No | Optional: Batch mode - execute multiple queries in one call (max: 5 for CDS views, omit when using view_name). Each query supports all single-query parameters. | |
| max_rows | No | Optional: Maximum number of rows to retrieve (default: 100, max: 500) | |
| order_by | No | Optional: Column names for sorting results. Column names are validated against view metadata. | |
| view_name | No | Name of the CDS view (required for single query mode, omit when using queries array) | |
| parameters | No | Optional: CDS view parameters as key-value pairs (e.g., {"p_date": "2024-01-01"}) | |
| where_conditions | No | Optional: WHERE conditions for filtering. Simple: {"SalesOrderType": "OR"}. Advanced: {"SalesOrderType": {"eq": "OR"}}. Note: ADT Data Preview API only supports equality (=) operator. | |
| include_column_metadata | No | Optional: Include column type and description in response (default: false) |