Filter Rows
filter_rowsFilter rows from a CSV, TSV, JSON, or NDJSON file or Apify dataset using conditions like 'country = US' or 'price > 100', and return every matching row with its original columns.
Instructions
Returns every row that matches the conditions, with all its original columns. Filters rows of a CSV, TSV, JSON or NDJSON file (by public URL) or an Apify dataset with simple conditions such as 'country = US' or 'price > 100'. Give at least one of: fileUrl or datasetId. Runs the Apify Actor ucchiii/filter-rows on YOUR Apify account (APIFY_TOKEN); you pay that Actor's pay-per-event price, see https://apify.com/ucchiii/filter-rows.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"conditions": "<conditions>"
},
"name": "filter_rows"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| match | No | Default: all conditions must match. | all |
| fileUrl | No | Public http(s) link to the file to filter (up to 500 MB; JSON arrays up to 150 MB, NDJSON has no extra limit). Use this OR an Apify dataset. | |
| encoding | No | Default auto: UTF-8, then Shift_JIS if kana are found, then Windows-1252. | auto |
| datasetId | No | Dataset to filter, for example the defaultDatasetId of a scraper run. You can paste a dataset URL from Apify Console too. | |
| delimiter | No | Default auto: guessed from the header line. | auto |
| conditions | Yes | One condition per line: column, operator, value. Operators: = != > >= < <= contains, not contains, starts with, ends with, in (comma list), not in, is empty, is not empty. Text is compared without case; numbers as numbers; ISO dates (2025-06-01) work with > and <. Nested fields: address.city. Put a column name with an operator inside it in quotes. | |
| inputFormat | No | Default auto: from the file extension, content type and content. Ignored for datasets. | auto |
| maxOutputRows | No | Optional. Empty = keep every matching row. Rows read until then are charged. |