Dataset Filter & Transform

{'type': 'object', 'properties': {}, 'additionalProperties': False}

{'type': 'object', 'required': ['rows'], 'properties': {'rows': {'type': 'array', 'items': {'type': 'object'}, 'description': 'The rows to process. Each row is a JSON object. Keys may differ between rows.'}, 'limit': {'type': 'integer', 'description': 'Return at most this many rows.'}, 'offset': {'type': 'integer', 'description': 'Skip this many rows after filtering and sorting.'}, 'sortBy': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Sort the kept rows, for example [{"field":"price","direction":"desc"}].'}, 'filters': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Conditions a row must satisfy to be kept, for example {"field":"country","operator":"equals","value":"UK"} or {"field":"price","operator":"greaterThan","value":100}. Dot paths like "address.city" work. Call list_capabilities for all 25 operators.'}, 'distinctBy': {'type': 'array', 'items': {'type': 'string'}, 'description': 'Keep only the first row for each combination of these fields. Applied after sorting, so sorting first lets you keep the newest row per key.'}, 'transforms': {'type': 'array', 'items': {'type': 'object'}, 'description': 'Transform steps applied to every row, in order. Each step is an object with an "op" key, for example {"op":"cast","field":"price","to":"number"} or {"op":"compute","field":"total","expression":"price * qty"} or {"op":"rename","from":"e_mail","to":"email"}. Call list_capabilities for all 26 operations.'}, 'lenientNumbers': {'type': 'boolean', 'description': 'On by default: values like "$1,234.50", "49 USD" and "12%" are read as numbers. Set false to require real numeric values.'}, 'filterCombineMode': {'enum': ['AND', 'OR'], 'type': 'string', 'description': 'Whether a row must match every filter (AND, the default) or any one of them (OR).'}, 'caseSensitiveFilters': {'type': 'boolean', 'description': 'Text comparisons are case-insensitive by default. Set true to make them exact.'}}, 'additionalProperties': False}