{"uid":"cap_MNlciFn0-DPq4ZbmC8yAH","slug":"contract-milestones-string-normalisation-numeric-row-ordering-5f9fdd64","name":"Contract Milestones — String Normalisation + Numeric Row Ordering","description":"Contract milestones — String normalisation + Numeric row ordering: String normalisation + Numeric row ordering for supplied contract milestones records (completed_items, planned_items). 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-operations-11-025?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","completed_items","planned_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"planned_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","planned_items":1,"completed_items":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","planned_items":2,"completed_items":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","planned_items":3,"completed_items":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","planned_items":4,"completed_items":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_items","planned_items"],"type":"string","default":"completed_items"}}},"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_1u-7x70Ho-V7a2OUN7i5M","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 applies numeric row ordering to contract milestone records (completed_items, planned_items) across up to 200 rows, producing 2 analytical reports.","exampleAgentPrompt":"Can you normalise the string fields and sort the rows numerically by completed_items for these contract milestones — I have 4 rows: row-1 for group-a on 2026-10-01 with 10 completed and 1 planned, row-2 for group-b on 2026-10-02 with 20 completed and 2 planned, row-3 for group-a on 2026-10-03 with 15 completed and 3 planned, and row-4 for group-b on 2026-10-04 with 30 completed and 4 planned?","exampleUseCases":[{"title":"Sprint milestone completion ranking","prompt":"I have a list of sprint milestone records for two teams across the past week — can you normalise the team name strings and rank all rows by completed_items so I can see which days had the highest delivery? Here are the rows: row-1, group-alpha, 2026-11-01, 50 completed, 60 planned; row-2, group-beta, 2026-11-02, 45 completed, 60 planned; row-3, group-alpha, 2026-11-03, 70 completed, 65 planned."},{"title":"Planned items ordering for contract review","prompt":"For our contract review meeting, can you sort these milestone records by planned_items and normalise any inconsistent string values? Rows: row-1, Team A, 2026-09-15, 100 planned, 80 completed; row-2, team a, 2026-09-16, 120 planned, 90 completed; row-3, TEAM B, 2026-09-17, 95 planned, 85 completed."},{"title":"Multi-team milestone data cleanup","prompt":"We've got messy string data and unsorted rows in our contract milestone tracker — please normalise the team_group strings and order everything numerically by completed_items for these 5 rows from October: row-1 group-x 2026-10-05 33 completed 40 planned, row-2 Group X 2026-10-06 28 completed 35 planned, row-3 group-y 2026-10-07 55 completed 50 planned, row-4 GROUP Y 2026-10-08 60 completed 55 planned, row-5 group-x 2026-10-09 45 completed 48 planned."}],"resultDescription":"Two analytical reports derived from the supplied milestone rows: one covering string normalisation of text fields (team_group, row_id, date formatting), and one providing numeric row ordering on the selected field (completed_items or planned_items). Results are computed locally without external lookups or predictions.","failureModes":["More than 200 rows submitted — exceeds maxItems limit, request rejected","Invalid date format in date field — must match YYYY-MM-DD pattern","Numeric values outside allowed range (±1,000,000,000,000) — validation error","Missing required fields (row_id, team_group, date, completed_items, planned_items) — schema validation failure","Invalid field enum value — must be 'completed_items' or 'planned_items'","Empty rows array — minItems 1 constraint violated","Payment of 0.01 USDC not provided — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you need lightweight, local string normalisation and numeric row ordering on contract milestone data (completed_items or planned_items) for up to 200 rows without any external API calls, live lookups, or predictions. It is ideal for data-cleaning pipelines that require two standardised analytical reports in a single low-cost call ($0.01 USDC). Prefer alternatives if you need statistical forecasting, external data enrichment, or processing more than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:30:47.301Z","isFirstParty":false,"canonicalSlug":"contract-milestones-string-normalisation-numeric-row-ordering-5f9fdd64"}