{"uid":"cap_7WF8NdAmUoz8eXjsxg-jP","slug":"invoice-ageing-numeric-row-ordering-explicit-missing-value-fill-0d466936","name":"Invoice Ageing — Numeric Row Ordering + Explicit Missing-Value Fill","description":"Invoice ageing — Numeric row ordering + Explicit missing-value fill: Numeric row ordering + Explicit missing-value fill 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-124?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"},"method":{"enum":["zero","mean","median"],"type":"string","default":"median"}}},"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_uvlpd9FXGizvSMN-z0mfG","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":"Sorts invoice ageing records by a numeric field and fills missing values using zero, mean, or median imputation, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Sort my invoice ageing records by outstanding_amount and fill any missing values using median imputation — I have about 50 rows with fields like row_id, instrument_group, date, outstanding_amount, and age_days.","exampleUseCases":[{"title":"Accounts receivable ageing cleanup","prompt":"I have 120 invoice ageing records and some of the outstanding_amount values are null — can you sort them by outstanding_amount and fill the blanks using median so I can generate a clean ageing report?"},{"title":"Overdue invoice ranking by age","prompt":"Sort my 80 invoice rows by age_days in ascending order and replace any missing age_days values with zero so I can see which invoices have been outstanding the longest."},{"title":"Finance team dual-report generation","prompt":"I need two invoice ageing reports from my 150-row dataset — sort by outstanding_amount and use mean to fill in any missing values, so the finance team can review both outputs together."}],"resultDescription":"Returns two structured invoice ageing reports for the supplied rows (up to 200): one with rows reordered numerically by the specified field (outstanding_amount or age_days), and one with missing values in that field replaced using the chosen method (zero, mean, or median). All processing is done locally with no external lookups.","failureModes":["More than 200 rows supplied — request exceeds row limit","Missing required fields (row_id, date, outstanding_amount, age_days) — validation error","Invalid date format (not YYYY-MM-DD) — schema rejection","Field or method enum value not recognized — bad request","All values in target field are null — mean/median imputation undefined"],"whenToPreferThis":"Choose this endpoint when you have invoice ageing tabular data (outstanding_amount, age_days) that needs numeric sorting and/or missing-value imputation in a single low-cost call, and you want two reports simultaneously without any external data lookups or predictions. Ideal for finance data pipelines that need deterministic, reproducible cleaning steps on batches up to 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:12.047Z","isFirstParty":false,"canonicalSlug":"invoice-ageing-numeric-row-ordering-explicit-missing-value-fill-0d466936"}