Generate Wrangles
Generate wrangles, with recipe examples, parameters, and behavior.
Ai
Generate structured AI output for each recipe row.
Parameters
| Name | Description | Accepted Values | Default | Required |
|---|---|---|---|---|
| I/O | ||||
output | Target schema; string/array shorthands are expanded automatically. | string, array, object | — | Yes |
input | Column(s) to concatenate into the prompt (defaults to all columns). | string, array, null | null | No |
| Options | ||||
messages | Optional extra messages forwarded to the inner generate helper. | array, object, null | null | No |
web_search | Enable DuckDuckGo context lookup per row. | boolean | false | No |
summary | Request summary text to be merged into the output. | boolean | false | No |
| Conditions | ||||
if | Condition that determines whether the wrangle runs as a whole. Recipe variables may be referenced with ${variable}. | string | — | No |
where | Filter rows before applying the wrangle using SQL-like criteria, such as column1 = 123 OR column2 = 'abc'. | string | — | No |
where_params | Values used with where for parameterized criteria. Uses SQLite placeholder syntax such as ? or :name. | array, object | — | No |
| Execution | ||||
threads | Maximum concurrent requests (default 20). | integer | 20 | No |
timeout | Per-request timeout in seconds. | integer | 90 | No |
| Errors | ||||
retries | Number of retry attempts on failure. | integer | 0 | No |
| Details | ||||
api_key | OpenAI-compatible API key. | string | — | Yes |
model | Responses model name (e.g. gpt-5-mini). | string | "gpt-5" | No |
url | Override for the OpenAI-compatible endpoint. | string | "https://api.openai.com/v1/responses" | No |
strict | Enforce JSON-schema validation on the response. | boolean | false | No |
reasoning | Responses API reasoning options (forwarded verbatim). | string, object | {"effort":"low"} | No |
previous_response | Chain responses by reusing previous_response_id for field-by-field calls. | boolean | false | No |
Examples
This template generates a category from a product description. AI-generated values can vary by model and request.
wrangles:
- generate.ai:
input:
- Product Description
output:
Category:
type: string
description: Broad product category
api_key: Your OpenAI-compatible API key
model: gpt-5-mini
| Product Description |
|---|
| Stainless steel insulated water bottle, 750 ml |
| Category |
|---|
| Drinkware |
Template based on the documented parameters; no published source example is currently available.
Access
| Requirement | Value |
|---|---|
| AI-powered | No |
| Requires WrangleWorks account | No |
| Requires subscription | No |
| Requires external API key | No |
Technical details
| Field | Value |
|---|---|
| Catalog ID | 39 |
| Catalog key | generate.ai |
| Recipe key | generate.ai |
| Catalog status | active |
| Lifecycle status | active |
| Recipe Writer eligible | Yes |
| Namespace | generate |
| Documentation group | generate |
| Aliases | None |
| Runtime symbol | wrangles.recipe_wrangles.generate.ai |
| Legacy UUID | 12c31c6c-cade-484d-84ba-7f302bf6af52 |
Sources