Transform Report Artifacts
transformUse after inspecting one or more existing artifacts to create a new artifact through a precise natural-language transformation. State the exact aliases, columns, joins, unions, grouping, calculations, filtering, sorting, deduplication, normalization, and output shape required. This does not refresh reporting sources.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| request | Yes | Complete transformation instructions. Example: `Group campaigns by Channel, sum Spend, and sort descending.` Rules: use 3–6000 characters and state exact aliases, columns, joins, calculations, filters, ordering, and output shape. | |
| brand_id | Yes | Accessible brand workspace. Example: `br_abc123`. Rules: copy an exact ID supplied by the host or list_brands and never infer it from a name. | |
| artifacts | Yes | Input tables available to the transformation. Example: [{ artifact_id: `ar_abc123`, as: `campaigns` }]. Rules: include 1–20 unexpired artifacts with unique aliases from the same brand. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rows | Yes | ||
| title | Yes | ||
| offset | Yes | ||
| columns | Yes | ||
| has_more | Yes | ||
| expires_at | Yes | ||
| total_rows | Yes | ||
| artifact_id | Yes | ||
| next_offset | No | ||
| returned_rows | Yes |