{"uid":"cap_76UTcHhSd_jSMxbqTZj2M","slug":"settlement-timing-data-cleaner-string-normalisation-exact-row-8feb4d63","name":"Settlement Timing Data Cleaner — String Normalisation & Exact Row Deduplication","description":"Settlement timing — String normalisation + Exact row deduplication: String normalisation + Exact row deduplication for supplied settlement timing records (settlement_minutes, payment_count). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-finance-18-020?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","settlement_minutes","payment_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"payment_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80},"settlement_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","payment_count":1,"instrument_group":"group-a","settlement_minutes":10},{"date":"2026-10-02","row_id":"row-2","payment_count":2,"instrument_group":"group-b","settlement_minutes":20},{"date":"2026-10-03","row_id":"row-3","payment_count":3,"instrument_group":"group-a","settlement_minutes":15},{"date":"2026-10-04","row_id":"row-4","payment_count":4,"instrument_group":"group-b","settlement_minutes":30}],"maxItems":200,"minItems":1}}},"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_nvnjNxhWlWcDl2PgdzcYX","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":"Normalises strings and deduplicates exact rows in settlement timing records (settlement_minutes, payment_count) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Can you clean my settlement timing records by normalising the instrument group strings and removing exact duplicate rows? I have 4 rows: row-1 for group-a on 2026-10-01 with 10 settlement minutes and 1 payment, row-2 for group-b on 2026-10-02 with 20 minutes and 2 payments, row-3 for group-a on 2026-10-03 with 15 minutes and 3 payments, and row-4 for group-b on 2026-10-04 with 30 minutes and 4 payments.","exampleUseCases":[{"title":"Pre-load settlement data hygiene","prompt":"Before I push this batch of 150 settlement timing rows into our data warehouse, can you normalise the instrument_group strings and strip out any exact duplicate records? Here are the rows with their row_ids, dates, settlement_minutes, and payment_counts."},{"title":"Reconciling duplicate payment records","prompt":"I've exported settlement timing data from two systems and merged them — now I have a file with up to 200 rows that likely has exact duplicates. Can you deduplicate them and also normalise the instrument group names so casing and whitespace are consistent?"},{"title":"Audit settlement data quality","prompt":"Can you run a string normalisation and exact deduplication pass on these settlement records for instrument groups like 'Wire Transfer', 'wire transfer ', and 'WIRE TRANSFER' across various dates, and give me the two reports showing what was cleaned?"}],"resultDescription":"Returns 2 analytical reports covering: (1) string normalisation results showing standardised instrument_group values and other string fields, and (2) exact row deduplication results identifying and removing fully duplicate records from the supplied dataset of up to 200 settlement timing rows.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, instrument_group, date, settlement_minutes, payment_count) — validation error","Malformed date format (not YYYY-MM-DD) — schema validation failure","Numeric values out of allowed range — rejected","Empty rows array — error returned","Payment not processed — no reports generated"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local string normalisation and exact-match deduplication on settlement timing data (settlement_minutes, payment_count) without any live data lookup, prediction, or external action. Best suited for pre-processing batches of up to 200 settlement records before ingestion into a data warehouse or reconciliation pipeline. At $0.01 USDC for 2 reports, it is cost-effective for routine data hygiene tasks on financial settlement datasets.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:51:31.274Z","isFirstParty":false,"canonicalSlug":"settlement-timing-data-cleaner-string-normalisation-exact-row-8feb4d63"}