{"uid":"cap_hw-ESJ_A0iYvDqGkHRE0n","slug":"invoice-ageing-string-normalisation-numeric-row-ordering-ca7651c9","name":"Invoice Ageing — String Normalisation + Numeric Row Ordering","description":"Invoice ageing — String normalisation + Numeric row ordering: String normalisation + Numeric row ordering for supplied invoice ageing records (outstanding_amount, age_days). 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-07-025?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","outstanding_amount","age_days"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"age_days":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80},"outstanding_amount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","age_days":1,"instrument_group":"group-a","outstanding_amount":10},{"date":"2026-10-02","row_id":"row-2","age_days":2,"instrument_group":"group-b","outstanding_amount":20},{"date":"2026-10-03","row_id":"row-3","age_days":3,"instrument_group":"group-a","outstanding_amount":15},{"date":"2026-10-04","row_id":"row-4","age_days":4,"instrument_group":"group-b","outstanding_amount":30}],"maxItems":200,"minItems":1},"field":{"enum":["outstanding_amount","age_days"],"type":"string","default":"outstanding_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_3K0OTjgVqzLX29SHBScHs","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 string fields and orders rows numerically for invoice ageing records containing outstanding_amount and age_days, producing 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you normalise the string fields and sort these invoice ageing rows numerically by outstanding_amount? I have 4 invoices: row-1 on 2026-10-01 in group-a for $10 aged 1 day, row-2 on 2026-10-02 in group-b for $20 aged 2 days, row-3 on 2026-10-03 in group-a for $15 aged 3 days, and row-4 on 2026-10-04 in group-b for $30 aged 4 days — I need 2 reports back.","exampleUseCases":[{"title":"Overdue invoice cleanup and ranking","prompt":"I have 50 outstanding invoice records with messy instrument group names and I need them sorted by age_days so I can see which ones are most overdue — can you normalise the strings and order the rows numerically by age_days?"},{"title":"Monthly AR report data prep","prompt":"Before I send our accounts receivable report to management, can you clean up the string fields and rank these 120 invoice rows by outstanding_amount so everything is tidy and consistently formatted?"},{"title":"Finance team invoice triage","prompt":"Our finance team has 180 invoice ageing entries that need string normalisation on the instrument_group column and numeric ordering by outstanding_amount — can you produce the two analytical reports so we can prioritise collections?"}],"resultDescription":"Two analytical reports covering the supplied invoice ageing rows: one applying string normalisation to text fields (e.g. instrument_group) and one ordering rows numerically by the selected field (outstanding_amount or age_days). No external data is fetched; all processing is performed locally on the submitted rows.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, date, outstanding_amount, age_days) causes a schema rejection","Invalid date format (not YYYY-MM-DD) triggers a pattern validation failure","Null values in numeric fields may affect ordering output","Submitting 0 rows or an empty array is rejected by minItems constraint"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local string cleaning and numeric ordering on invoice ageing data (up to 200 rows) without any external lookup, prediction, or live data enrichment. It is particularly suitable when you want two distinct reports — normalisation and ordering — in a single low-cost call ($0.01 USDC) and have no need for forecasting, credit scoring, or third-party data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:34:08.410Z","isFirstParty":false,"canonicalSlug":"invoice-ageing-string-normalisation-numeric-row-ordering-ca7651c9"}