{"uid":"cap_EaK9vjMRYW72osQ8g9S-C","slug":"payment-reconciliation-string-normalisation-secondary-measure-c10b3883","name":"Payment Reconciliation — String Normalisation + Secondary-Measure Weighted Mean","description":"Payment reconciliation — String normalisation + Secondary-measure weighted mean: String normalisation + Secondary-measure weighted mean for supplied payment reconciliation records (expected_amount, received_amount). 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-08-034?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","expected_amount","received_amount"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"expected_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"received_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","expected_amount":10,"received_amount":1,"instrument_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","expected_amount":20,"received_amount":2,"instrument_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","expected_amount":15,"received_amount":3,"instrument_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","expected_amount":30,"received_amount":4,"instrument_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["expected_amount","received_amount"],"type":"string","default":"expected_amount"}}},"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_rlECGakot2gC3633eAg4v","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":"Runs string normalisation and secondary-measure weighted mean analytics on up to 200 payment reconciliation rows (expected vs received amounts), returning two independent analytical reports.","exampleAgentPrompt":"Run string normalisation and a secondary-measure weighted mean on these payment reconciliation rows — I have 4 records with instrument groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, expected amounts of 10, 20, 15, and 30, received amounts of 1, 2, 3, and 4, and I want the weighted mean calculated on the expected_amount field.","exampleUseCases":[{"title":"Month-end payment shortfall analysis","prompt":"I have 150 payment reconciliation records for October — each with a row ID, instrument group, date, expected amount, and received amount. Run string normalisation and a weighted mean on the expected_amount field so I can see where shortfalls are concentrated by group."},{"title":"Instrument group weighted average review","prompt":"Can you compute the secondary-measure weighted mean on the received_amount field for my 80 reconciliation rows? Each row has a date, instrument group, expected amount, and received amount — I want to understand the average receipt weight across groups."},{"title":"Reconciliation data quality and normalisation audit","prompt":"I need to normalise the strings across my 200 payment reconciliation records and get a weighted mean report on expected_amount. The rows each have a row_id, instrument_group, date, expected_amount, and received_amount — give me both analytical reports."}],"resultDescription":"Two independent analytical reports: (1) a string normalisation report applied to the payment reconciliation fields, and (2) a secondary-measure weighted mean report computed over the specified numeric field (expected_amount or received_amount), segmented across the supplied rows and instrument groups. No external lookups or predictions are included — all computation is local and deterministic.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, instrument_group, date, expected_amount, received_amount) cause schema rejection","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Amount values outside ±1,000,000,000,000 are rejected","Empty rows array (minItems:1 not met) returns an error","Payment failure (insufficient USDC balance) prevents execution"],"whenToPreferThis":"Choose this endpoint when you have up to 200 payment reconciliation records and need both string normalisation and a secondary-measure weighted mean computed locally without any external lookups or predictions. It is ideal for finance and accounting workflows that require deterministic, batch analytical reports on expected vs received amounts grouped by instrument. Prefer it over general-purpose analytics tools when you need two specific report types (string normalisation + weighted mean) delivered together at low cost ($0.01 USDC) in a single call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:38:43.989Z","isFirstParty":false,"canonicalSlug":"payment-reconciliation-string-normalisation-secondary-measure-c10b3883"}