query_relational_entity
Execute OData queries on relational entities to extract large batches of data for ETL pipelines. Supports filtering, column selection, and pagination.
Instructions
Execute OData queries on relational entities for ETL data extraction. Supports large batch processing (up to 50,000 records), advanced filtering, column selection, and pagination. Optimized for data warehouse loading and analytics pipelines. Use list_relational_entities to discover available entity names first.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| space_id | Yes | Space identifier (e.g., 'SAP_CONTENT') | |
| asset_id | Yes | Asset identifier - same as used in list_relational_entities (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS') | |
| entity_name | Yes | Entity name from the OData service (e.g., 'Results', 'Data'). Use list_relational_entities to get available entity names. If unsure, try using the asset_id as entity_name. | |
| filter | No | OData $filter expression (e.g., "amount gt 1000 and status eq 'ACTIVE'") | |
| select | No | Comma-separated column list for $select (e.g., "customer_id,amount,date") | |
| top | No | Maximum records to return (default: 1000, max: 50000 for ETL) | |
| skip | No | Number of records to skip for pagination | |
| orderby | No | OData $orderby expression (e.g., "amount desc, date asc") |