{"uid":"cap_GWTbmSFoCeSAunJZuPWQ5","slug":"damaged-stock-deduplication-and-adjacent-row-change-analysis-d1aca8c6","name":"Damaged Stock Deduplication and Adjacent Row Change Analysis","description":"Damaged stock — Exact row deduplication + Adjacent row changes: Exact row deduplication + Adjacent row changes for supplied damaged stock records (handled_units, damaged_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-retail-18-046?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","handled_units","damaged_units"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"store_group":{"type":"string","default":"","maxLength":80},"damaged_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"handled_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","damaged_units":1,"handled_units":10},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","damaged_units":2,"handled_units":20},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","damaged_units":3,"handled_units":15},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","damaged_units":4,"handled_units":30}],"maxItems":200,"minItems":1},"field":{"enum":["handled_units","damaged_units"],"type":"string","default":"handled_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_Yi8m459DzsIx8Z6afUsjx","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":"Performs exact row deduplication and adjacent row change detection on up to 200 damaged stock records, delivering two analytical reports from local engines for handled_units or damaged_units.","exampleAgentPrompt":"I have a list of damaged stock records by store group and date — can you run exact row deduplication plus adjacent row change detection on the handled_units field? Here are the rows: row-1, group-a, 2026-10-01, handled=10, damaged=1; row-2, group-b, 2026-10-02, handled=20, damaged=2; row-3, group-a, 2026-10-03, handled=15, damaged=3.","exampleUseCases":[{"title":"Retail chain duplicate stock audit","prompt":"I've got 150 rows of damaged stock records from our warehouse system and I suspect there are duplicates — can you run exact row deduplication on the damaged_units field and also flag where adjacent rows show changes, grouped by store group and date?"},{"title":"Daily stock damage change monitoring","prompt":"Here are today's handled_units entries across our store groups — can you check for any exact duplicate rows and also tell me where consecutive rows show a change in handled_units values so I can investigate spikes?"},{"title":"Pre-reporting inventory data cleanup","prompt":"Before I finalize our monthly damage report, I need to deduplicate these 80 stock records and detect any adjacent row shifts in damaged_units — can you run both analyses and give me the two reports?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing fully duplicate records from the input set, and (2) an adjacent row change report highlighting where consecutive rows differ in the selected field (handled_units or damaged_units), across up to 200 input rows processed by local analytical engines with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, store_group, date, handled_units, damaged_units) — validation error","Invalid date format (must match YYYY-MM-DD pattern) — schema validation failure","Field value outside allowed numeric range (±1,000,000,000,000) — rejection","Empty rows array — minimum 1 item required","Malformed JSON body — parse error","Insufficient USDC balance (requires 0.01 USDC per call) — payment failure"],"whenToPreferThis":"Choose this endpoint when you need two complementary data quality operations on damaged stock data in a single call: exact duplicate row removal and sequential row change detection. It is ideal for retail inventory analysts who want to clean records and spot anomalous adjacent shifts in handled or damaged unit counts without involving external prediction or live data services. Best when your dataset is under 200 rows and you want a cost-effective combined report at $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-09T06:41:38.813Z","isFirstParty":false,"canonicalSlug":"damaged-stock-deduplication-and-adjacent-row-change-analysis-d1aca8c6"}