{"uid":"cap_ih6ZYBsKTtZajv3fIDpvZ","slug":"office-supplies-string-normalisation-and-numeric-row-ordering-a7f6b436","name":"Office Supplies String Normalisation and Numeric Row Ordering","description":"Office supplies — String normalisation + Numeric row ordering: String normalisation + Numeric row ordering for supplied office supplies records (issued_units, received_units). 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-24-025?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","issued_units","received_units"],"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},"issued_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"received_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","issued_units":10,"received_units":1},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","issued_units":20,"received_units":2},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","issued_units":15,"received_units":3},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","issued_units":30,"received_units":4}],"maxItems":200,"minItems":1},"field":{"enum":["issued_units","received_units"],"type":"string","default":"issued_units"}}},"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_0s-lqntpDyIFQoH_S-Ok4","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 office supplies records (issued_units, received_units) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Can you normalise the string fields and sort the rows numerically by issued_units for these office supplies records? I have 4 rows: row-1 for group-a on 2026-10-01 with issued_units 10 and received_units 1, row-2 for group-b on 2026-10-02 with issued_units 20 and received_units 2, row-3 for group-a on 2026-10-03 with issued_units 15 and received_units 3, row-4 for group-b on 2026-10-04 with issued_units 30 and received_units 4.","exampleUseCases":[{"title":"Quarterly supply distribution ordering","prompt":"I have our Q4 office supplies log with about 50 rows across group-a and group-b, each with issued_units and received_units — can you normalise the string fields and order all rows numerically by received_units so I can see who got the most supplies?"},{"title":"Multi-team issued units ranking","prompt":"We track issued_units for several team groups daily. Can you take these 120 office supply records, clean up the strings, and rank the rows by issued_units numerically so I can identify the highest-usage days?"},{"title":"Data cleanup before inventory report","prompt":"Before I send this to finance, can you normalise the team_group strings and sort these 80 office supply rows by issued_units numerically? I need both analytical reports the service produces."}],"resultDescription":"Returns 2 independent analytical reports: one covering string normalisation of fields such as team_group and date, and one providing numeric row ordering based on the selected field (issued_units or received_units). Reports are generated locally with no external lookups.","failureModes":["More than 200 rows submitted — request rejected with validation error","Missing required fields (row_id, date, issued_units, received_units) cause row-level errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Numeric values outside ±1,000,000,000,000 range rejected","Invalid field enum value (not 'issued_units' or 'received_units') causes error","Empty rows array rejected (minItems: 1)"],"whenToPreferThis":"Choose this endpoint when you have office supplies tabular data with string inconsistencies and need numeric row ordering on issued or received unit counts, and want two bundled analytical reports at low cost ($0.01 for both). Ideal for lightweight, offline-style data cleaning and sorting without needing external data sources, predictions, or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T12:48:36.495Z","isFirstParty":false,"canonicalSlug":"office-supplies-string-normalisation-and-numeric-row-ordering-a7f6b436"}