{"uid":"cap_FEOxB_t-Dtjwnm3YT-cg0","slug":"delx-commerce-csv-unpivot-3aa8d1d5","name":"Delx Commerce CSV Unpivot","description":"Pay-per-result APIs for agents. No signup. Exact price. Verifiable delivery. USDC on Base + Solana via x402.","url":"https://commerce.delx.ai/api/v1/x402/csv-unpivot?utm_source=zero.xyz","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_nrAi4ZXCyKnPgAyakdaTR","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":"Transforms wide-format CSV data into long/tidy format by unpivoting specified value columns into rows","exampleAgentPrompt":"Take this CSV and unpivot it — keep 'id' and 'region' as identifier columns, and turn all the quarter columns (q1, q2, q3, q4) into rows with a variable and value column.","exampleUseCases":[{"title":"Survey response data reshape","prompt":"I have a CSV with one row per respondent and columns for each survey question (q1 through q10). Can you unpivot it so each answer is its own row? Keep 'respondent_id' and 'age_group' as the identifier columns, and make 'question' and 'answer' the output columns."},{"title":"Sales data normalization for analytics","prompt":"Reshape this sales CSV — the columns 'jan_sales', 'feb_sales', 'mar_sales' need to become rows. Keep 'product_id' and 'region' as id columns and unpivot the monthly sales columns into a variable/value format so I can feed it into our BI tool."},{"title":"Financial report flattening","prompt":"I exported a wide-format financial report as CSV with columns for each department's budget. Unpivot it into long format using 'fiscal_year' and 'category' as the id columns, and turn all the department columns into rows."}],"resultDescription":"Returns a JSON object containing the unpivoted CSV as a string, the number of resulting rows, the operation schema identifier, a pass/fail status, and an evidence block with input SHA-256 hash, a flag confirming no data retention, and a count of external calls made (always 0).","failureModes":["Invalid or malformed CSV text returns an error status","Specified id_columns or value_columns not found in CSV header causes failure","Input text exceeding 8192 character limit is rejected","Empty CSV or CSV with no rows returns zero row_count","Payment failure via x402 prevents processing"],"whenToPreferThis":"Choose this endpoint when you need a quick, cheap ($0.001), stateless CSV unpivot with cryptographic proof of non-retention and no account setup required. Ideal for agents that process sensitive tabular data and need verifiable in-memory-only processing, or for pipelines requiring pay-per-call billing without subscription overhead.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-01T00:54:02.484Z","isFirstParty":false,"canonicalSlug":"delx-commerce-csv-unpivot-3aa8d1d5"}