{"uid":"cap_lTnsQ71lMDbcPRj4-50Fo","slug":"csv-unpivot-5a37ff01","name":"CSV Unpivot","description":"CSV Unpivot: CSV Unpivot converts selected wide CSV columns into name and value rows from bounded caller-supplied values without an external provider. Call CSV Unpivot before an agent hands structured data or a batch plan to a downstream tool with a stricter contract. Returns the bounded transformation or validation finding with counts, normalized values, and a versioned result contract for CSV Unpivot as versioned deterministic JSON. Price: $0.001 USDC via x402 on Base. First-party, stateless,…","url":"https://api.delx.ai/api/v1/x402/csv-unpivot","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"text":{"type":"string","maxLength":8192,"description":"Text supplied to CSV Unpivot; used only for this bounded calculation and processed in memory without retention."},"id_columns":{"type":"array","items":{"type":"string","maxLength":8192},"maxItems":256,"description":"Id Columns supplied to CSV Unpivot; used only for this bounded calculation and processed in memory without retention."},"value_columns":{"type":"array","items":{"type":"string","maxLength":8192},"maxItems":256,"description":"Value Columns supplied to CSV Unpivot; used only for this bounded calculation and processed in memory without retention."}}},"responseSchema":{"type":"json","example":{"result":{"csv":"id,variable,value\n1,q1,10\n1,q2,20","row_count":2},"schema":"delx/util-csv-unpivot/v1","status":"pass","evidence":{"retained":false,"input_sha256":"1664e3ca93eaf50bde3e9b8dfa73ca0237be72fb4f663837d3df1087aa684d02","external_calls":0},"operation":"data_batch:csv_unpivot"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.001","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.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_Mzt_bKDKydLBk1_jOZCPe","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Converts wide-format CSV columns into long-format name/value row pairs, returning normalized row counts and a versioned deterministic result.","exampleAgentPrompt":"Take this CSV text where 'region' and 'product' are the id columns and 'Q1', 'Q2', 'Q3', 'Q4' are the value columns, and unpivot it so each quarter becomes a separate name-value row.","exampleUseCases":[{"title":"Analytics pipeline data reshaping","prompt":"I have a wide CSV with columns 'user_id' and 'date' as identifiers, and then 'clicks', 'impressions', 'conversions' as metrics — can you unpivot it so each metric becomes its own row with a name and value column?"},{"title":"Database import normalization","prompt":"Before I load this survey CSV into our database, I need to reshape it — 'respondent_id' and 'age_group' should stay as id columns, and all the question columns like 'q1', 'q2', 'q3' should be unpivoted into name-value rows."},{"title":"Downstream tool contract preparation","prompt":"I need to send this sales CSV to a downstream tool that only accepts long-format data — keep 'store_id' and 'month' as id columns and melt 'north_sales', 'south_sales', 'east_sales', 'west_sales' into rows."}],"resultDescription":"A versioned deterministic JSON object containing the unpivoted rows as name-value pairs, counts of input and output rows, normalized values, and a result contract version identifier. No data is retained after processing.","failureModes":["Column names in id_columns or value_columns not found in the CSV header — returns validation error with unmatched column names","Malformed or unparseable CSV text — returns parsing error","Input exceeds 8192-character text limit — returns size limit error","Empty value_columns array — returns validation finding with zero unpivoted rows","Overlapping id_columns and value_columns — returns conflict error"],"whenToPreferThis":"Choose this endpoint when you have wide-format CSV data that needs to be reshaped into long/tall format before passing to a downstream tool with a strict row-level contract. It is stateless and deterministic, making it safe for idempotent pipelines. Prefer it over general-purpose code execution when you need a cheap, fast, versioned reshaping step without spinning up a compute environment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T19:09:22.089Z","isFirstParty":false}