query_relational_entity
Run OData queries on relational entities to extract ETL data, supporting large batch processing, filtering, column selection, and pagination for data warehouse loading.
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 |
|---|---|---|---|
| top | No | Maximum records to return (default: 1000, max: 50000 for ETL) | |
| skip | No | Number of records to skip for pagination | |
| filter | No | OData $filter. Operators: eq ne gt ge lt le, and/or/not, (). Partial text matching: startswith(Field,'v'), endswith(Field,'v'), contains(Field,'v') -- text columns only. Values must be single-quoted and are CASE-SENSITIVE ('us' does not match 'US'). A value containing a single quote cannot be filtered on at all. Example: startswith(Product,'TV') and Country eq 'US'. Assets whose lineage includes federated sources accept only eq/and/or/(). | |
| select | No | Comma-separated column list for $select (e.g., "customer_id,amount,date") | |
| orderby | No | OData $orderby expression (e.g., "amount desc, date asc") | |
| asset_id | Yes | Asset identifier - same as used in list_relational_entities (e.g., 'SAP_SC_FI_AM_FINTRANSACTIONS') | |
| space_id | Yes | Space identifier (e.g., 'SAP_CONTENT') | |
| 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. |