{"uid":"cap_3bj14Ndm46t3sC6OjXg2e","slug":"csv-pivot-count-117414ab","name":"CSV Pivot Count","description":"CSV Pivot Count: CSV Pivot Count builds a count pivot from row and column category fields from bounded caller-supplied values without an external provider. Call CSV Pivot Count 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 Pivot Count as versioned deterministic JSON. Price: $0.001 USDC via x402 on Base. First-part…","url":"https://api.delx.ai/api/v1/x402/csv-pivot-count","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_u-UnPoAIUWDvnRtlhZdBn","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":"Builds a count-based pivot table from CSV text using specified row and column category fields, returning normalized counts as versioned deterministic JSON.","exampleAgentPrompt":"Take this CSV data and build a pivot count table where 'region' is the row field and 'product_category' is the column field — I want to see how many records fall into each combination.","exampleUseCases":[{"title":"Sales data cross-tab by region","prompt":"I have a CSV of sales transactions. Can you pivot-count them with 'region' as rows and 'product_category' as columns so I can see the frequency of each combination?"},{"title":"Survey response frequency table","prompt":"Here's my survey CSV — build a count pivot table using 'age_group' as the row field and 'response_rating' as the column field so I can see how each age group answered."},{"title":"Pre-flight data validation before downstream tool","prompt":"Before I send this structured CSV to the reporting pipeline, pivot-count it by 'department' rows and 'status' columns so I can verify the category distribution looks right."}],"resultDescription":"Returns a versioned deterministic JSON object containing the count pivot table with cross-tabulated frequencies for each row/column category combination, normalized values, and a versioned result contract identifying the transformation.","failureModes":["Missing or invalid row_field or column_field names not found in the CSV header — returns validation error","CSV text exceeds 8192 character limit — truncated or rejected","Malformed CSV input that cannot be parsed — returns parsing error","Empty CSV with no data rows — returns empty pivot with zero counts","Payment failure via x402 — returns 402 Payment Required"],"whenToPreferThis":"Use this endpoint when you need a deterministic, bounded count pivot from two categorical fields in CSV data without relying on an external analytics provider. It is ideal as a pre-flight step before handing structured data to a downstream tool with a strict schema contract, or when you need a reproducible, versioned cross-tabulation result for lightweight in-memory aggregation on small-to-medium CSV inputs.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T01:07:12.799Z","isFirstParty":false}