{"uid":"cap_k9sTiJUXfHRlaxT5bWt1c","slug":"payment-imports-csv-trimmed-typed-conversion-e9604bf1","name":"Payment Imports CSV Trimmed Typed Conversion","description":"Payment imports — Trimmed typed conversion: Trimmed typed conversion for Payment imports. Validate a declared CSV table contract, up to 1000 rows. Quoted cells supported; no external enrichment. Specialised preset in a shared 50-profile, 20-operation engine. 0.01 USDC includes one CSV trimmed typed conversion report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-payments-normalise?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","default":"payment_id,paid_on,invoice_id,paid_amount,processing_fee\nrecord-a,2026-01-01,group-a,10,2\nrecord-b,2026-01-02,group-b,20,3","maxLength":100000,"minLength":1},"maximum":{"type":"number","default":1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":-1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"delimiter":{"enum":[",",";","\t"],"type":"string","default":","},"max_cell_length":{"type":"integer","default":1000,"maximum":5000,"minimum":1},"allowed_categories":{"type":"array","items":{"type":"string","default":"","maxLength":100,"minLength":1},"default":["group-a","group-b"],"maxItems":100,"minItems":0}}},"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_JQinHFy_JKok6E_X2YNC_","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":"Validates and normalizes a payment imports CSV by trimming whitespace and converting cell types, supporting up to 1000 rows with configurable delimiters and value constraints.","exampleAgentPrompt":"Can you validate and normalize this payment imports CSV for me — it uses comma delimiters, amounts should be between 0 and 1000000, and only 'group-a' and 'group-b' are allowed invoice categories: 'payment_id,paid_on,invoice_id,paid_amount,processing_fee\\nrecord-a,2026-01-01,group-a,10,2'?","exampleUseCases":[{"title":"Pre-import payment file validation","prompt":"Before I push these payment records into our accounting system, can you run a typed conversion check on this CSV — delimiter is comma, amounts must be between 0 and 500000, and valid categories are 'group-a', 'group-b', and 'group-c'?"},{"title":"Catching malformed payment amounts","prompt":"I've got a payment CSV that might have some cells with trailing spaces or wrong numeric formats in the paid_amount column — can you trim and type-convert it, enforcing a max amount of 999999 and flagging anything outside that range?"},{"title":"Validating multi-currency payment batches by category","prompt":"Can you validate this semicolon-delimited payment imports file against our allowed categories 'EUR-batch' and 'USD-batch', with amounts between -1000000 and 1000000, and make sure every cell is properly typed and trimmed?"}],"resultDescription":"A CSV trimmed typed conversion report covering up to 1000 rows, detailing which cells passed type conversion and whitespace trimming, highlighting any values outside the declared numeric range, rows with disallowed category values, or cells exceeding the maximum cell length limit.","failureModes":["CSV exceeds 100000 character limit — request rejected","More than 1000 rows submitted — validation not performed","Cell value exceeds max_cell_length — flagged in report","Numeric values outside declared minimum/maximum bounds — flagged","Category value not in allowed_categories list — flagged","Malformed CSV structure (unclosed quotes, wrong delimiter) — parse error returned","Empty CSV body submitted — error response"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, paid-per-call validation step for payment-specific CSV files before ingestion, especially when you need trimmed whitespace, typed column enforcement, category allow-listing, and numeric range checks in a single pass without external enrichment. It is purpose-built for the payment_id/paid_on/invoice_id/paid_amount/processing_fee schema pattern and handles quoted cells correctly.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-16T00:52:09.462Z","isFirstParty":false,"canonicalSlug":"payment-imports-csv-trimmed-typed-conversion-e9604bf1"}