Retrievers
CSV Document Search
Tool that allows searching within CSV documents using text search or pandas query expressions.
Category: Retrievers · Plans: Trial, Starter, Pro, Premium, Enterprise · Type: CSVDocument
Inputs#
| Field | Type | Required | Default | What it does |
|---|---|---|---|---|
| CSV File URL | Text | No | (empty) | The CSV file to load from URL. |
| CSV Document ID | Choice | No | — | The ID of the CSV document to search in. |
| Max Results | Number | Yes | 5000 | Maximum number of results to return. |
| Case Sensitive | Yes/No | No | Off | Whether the search should be case sensitive. |
| Delimiter | Text | No | , | The delimiter character used in the CSV file. |
| Cache TTL | Text | No | 2 weeks | Cache the content of the CSV file for defined amount of time. Options: No cache, 5 minutes, 30 minutes, 1 hour, 12 hours, 1 day, 1 week, 2 weeks, 1 month, 3 months, 6 months, 1 year |
| Search Query | Text | No | {input} | The search term to look for in the CSV document. |
| Search Column | Text | No | — | Optional column name to restrict search to a specific column. |
| Query Expression | Text | No | — | Pandas query expression (e.g., ‘Price > 100 and Category == “Electronics”’). |
| Sort By | Text | No | — | Column(s) to sort by. Use comma for multiple, minus (-) for descending (e.g., ‘Price,-Date’). |
| Group By | Text | No | — | Column(s) to group by. Requires Aggregate Function to be set. |
| Aggregate Function | Text | No | — | Aggregation functions (e.g., ‘Price:mean,Quantity:sum’). Supported: sum, mean, min, max, count, median, first, last. |
| Pivot Table | Text | No | — | Create pivot table. Format: ‘index,columns,values[:agg_func]’ (e.g., ‘Category,Region,Price:mean’). |
| Calculated Column | Text | No | — | Add a calculated column. Format: ’new_col:expression’ (e.g., ‘Discount:Price*0.1’). |
| String Filter | Text | No | — | Regex string filter. Format: ‘column:pattern[:case_sensitive]’ (e.g., ‘Name:john:false’). |
Outputs#
| Output | Type |
|---|---|
| Row Count | Any |
| Column Count | Any |
| Columns | Any |
| Matched Rows | Any |
| Search Results | Any |
| Operations Applied | Any |
Use as an agent tool#
Tool name: csvdocument
Tool that allows searching within CSV documents using text search or pandas query expressions.