POST data

csv_filter

1 credit

Filter CSV rows where a column matches a condition. Supports equality, comparison, contains, and empty checks.

Endpoint

POST /api/v1/tools/data/csv_filter

Body Parameters

text string required

value string required

column string required

header boolean optional default: true

operator string optional default: "eq"

Options: eq ne contains not_contains gt gte lt lte empty not_empty

delimiter string optional default: ","

Example

input Request

{
    "text": "name,age\nAlice,30\nBob,25\nCharlie,35",
    "value": "30",
    "column": "age",
    "operator": "eq"
}

output Response

{
    "result": "name,age\nAlice,30\n",
    "rows_total": 3,
    "rows_matched": 1
}

Response Format

HTTP/1.1 200 OK SUCCESS

{
  "success": true,
  "data": {
    "result": "name,age\nAlice,30\n",
    "rows_total": 3,
    "rows_matched": 1
},
  "meta": {
    "tool": "csv_filter",
    "credits_consumed": 1
  }
}

HTTP/1.1 422 Unprocessable Entity ERROR

{
  "success": false,
  "data": null,
  "error": {
    "code": "validation_error",
    "message": "The given data was invalid."
  }
}

Code Examples

Request Example

lightbulb Developer Tip

Credits are deducted before execution. If the upstream tool fails, credits are automatically refunded to your account.