{"uid":"cap_QzrrerwSqQ_PkIFXlu-Ap","slug":"delx-commerce-csv-pivot-count-7496fafe","name":"Delx Commerce — CSV Pivot Count","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-pivot-count?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"text":{"type":"string","maxLength":8192,"description":"Text supplied to CSV Pivot Count; used only for this bounded calculation and processed in memory without retention."},"row_field":{"type":"string","maxLength":8192,"description":"Row Field supplied to CSV Pivot Count; used only for this bounded calculation and processed in memory without retention."},"column_field":{"type":"string","maxLength":8192,"description":"Column Field supplied to CSV Pivot Count; used only for this bounded calculation and processed in memory without retention."}}},"responseSchema":{"type":"json","example":{"result":{"pivot":{"a":{"ok":1,"bad":1},"b":{"ok":1}}},"schema":"delx/util-csv-pivot-count/v1","status":"pass","evidence":{"retained":false,"input_sha256":"a7d65f7e6ad53c38ed0da2d98857916e403a9b41abcade8314874497f4fdcd7b","external_calls":0},"operation":"data_batch:csv_pivot_count"}},"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_i4EFzxPdG6BtRr11jKwB5","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":"Counts occurrences in a CSV by pivoting rows and columns to produce a cross-tabulation frequency table","exampleAgentPrompt":"Take this CSV data and pivot it so that 'status' is the row and 'region' is the column, then count how many records fall into each combination.","exampleUseCases":[{"title":"Sales pipeline breakdown by stage and region","prompt":"I have this CSV of sales leads — can you pivot it with 'stage' as the row field and 'region' as the column field and count how many deals are in each bucket?"},{"title":"Survey response cross-tabulation","prompt":"Here's my survey CSV. I want to see how many respondents gave each answer option broken down by their age group — use 'answer' as the row field and 'age_group' as the column field."},{"title":"QA test results by category and outcome","prompt":"I've got a CSV of test runs. Pivot it with 'category' as the row and 'result' as the column so I can count how many passed, failed, or errored in each category."}],"resultDescription":"A JSON object containing a nested pivot table (row values → column values → count), a schema identifier, a pass/fail status, and a verifiable evidence block including input SHA-256 hash, a flag confirming no data retention, and a count of external calls made (always 0).","failureModes":["Missing or invalid CSV text returns an error","Specified row_field or column_field not found as a header in the CSV","CSV too large (exceeds 8192-character limit) causes rejection","Malformed CSV syntax may produce unexpected results or an error","Payment failure via x402 prevents execution"],"whenToPreferThis":"Choose this endpoint when you need a quick, verifiable, pay-per-call cross-tabulation of two categorical columns in a CSV without standing up infrastructure or authenticating with a service. It is ideal for agents that need auditable, tamper-evident computation (SHA-256 input hash provided) and work within the x402 micropayment protocol on Base or Solana. Prefer alternatives if your CSV exceeds 8 KB, you need multi-column pivots, or you require persistent storage of results.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-01T00:53:54.916Z","isFirstParty":false,"canonicalSlug":"delx-commerce-csv-pivot-count-7496fafe"}