{"uid":"cap_phmDLafEIp5HCBtL3ARtG","slug":"trixie-lasagne-tabular-data-pipeline-6d685b6f","name":"Trixie Lasagne Tabular Data Pipeline","description":"Deterministic tabular data pipeline: select/rename/filter/sort/limit/group/aggregate/dedupe/join/pivot/unpivot/calculated_field","url":"https://trixielasagne-api.purplewater-b02e2643.eastus.azurecontainerapps.io/data/process","method":"POST","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"properties":{}},"type":{"type":"string","const":"http"},"method":{"enum":["POST","PUT","PATCH"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_ScXbezKnMj2lmHdZN_er-","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Runs deterministic tabular data transformations including select, rename, filter, sort, limit, group, aggregate, deduplicate, join, pivot, unpivot, and calculated fields over caller-supplied data","exampleAgentPrompt":"Take my sales CSV data, filter to rows where region is 'EMEA', group by product category, sum up the revenue column, and sort the results descending by total revenue — give me the top 10 categories.","exampleUseCases":[{"title":"Monthly sales report by region","prompt":"I have a table of order transactions with columns order_id, region, product, amount, and date. Filter to last month's rows, group by region, sum the amount, and sort descending so I can see which regions sold the most."},{"title":"Joining customer and order tables","prompt":"I've got two datasets — one with customer records keyed on customer_id, and another with orders keyed on customer_id. Join them on that key, then select just the customer name, email, order date, and order total columns."},{"title":"Pivot survey responses wide to column format","prompt":"I have a long-format survey results table with columns respondent_id, question, and answer. Pivot it so each question becomes its own column and each row is one respondent."}],"resultDescription":"A transformed tabular dataset returned as structured data reflecting the applied operations (filters, aggregations, joins, pivots, etc.), with columns and rows matching the requested output shape","failureModes":["Missing or malformed 'input' body causes a 400 validation error","Referencing a column name that doesn't exist in the dataset returns an error indicating unknown field","Invalid operation type or unsupported combination of operations may return a 422 unprocessable entity","Join on keys not present in both datasets fails with a key mismatch error","Payload too large for the service limits may result in a timeout or 413 error","Malformed JSON body returns a parse error"],"whenToPreferThis":"Choose this endpoint when you need deterministic, reproducible tabular data transformations without spinning up a database or data warehouse. It is especially useful for chaining multiple operations (filter + group + aggregate + sort) in a single API call, or when you need to reshape data (pivot/unpivot) or merge datasets (join) programmatically inside an agent workflow. Prefer it over statistical analysis siblings when the goal is data shaping rather than descriptive statistics or technical indicators.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-16T00:44:31.042Z","isFirstParty":false}