{"uid":"cap_BUbrzrmGQLy4kdiNWCKgE","slug":"warehouse-bins-exact-row-deduplication-category-frequencies-61f7dc15","name":"Warehouse Bins — Exact Row Deduplication + Category Frequencies","description":"Warehouse bins — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies for supplied warehouse bins records (occupied_volume, available_volume). 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-13-041?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","occupied_volume","available_volume"],"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},"occupied_volume":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"available_volume":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","occupied_volume":10,"available_volume":1},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","occupied_volume":20,"available_volume":2},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","occupied_volume":15,"available_volume":3},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","occupied_volume":30,"available_volume":4}],"maxItems":200,"minItems":1}}},"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_jsn64X4DiAgmGyxHDmznU","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":"Deduplicates warehouse bin records and computes category-level frequency counts for occupied_volume and available_volume fields across up to 200 rows.","exampleAgentPrompt":"I have up to 200 warehouse bin records with fields for row_id, store_group, date, occupied_volume, and available_volume — can you deduplicate the exact rows and also give me a frequency breakdown by category for these bin records?","exampleUseCases":[{"title":"Warehouse bin data deduplication audit","prompt":"I've got a list of warehouse bin records for groups A and B across October — some rows might be duplicated. Can you run exact row deduplication and tell me which records are repeated, and also show me how often each store group appears in the dataset?"},{"title":"Retail store group frequency analysis","prompt":"Here are 150 warehouse bin entries with store groups, dates, and volume figures. Can you deduplicate them and give me a category frequency report so I can see how many records belong to each store group?"},{"title":"Inventory data quality check before reporting","prompt":"Before I finalize my warehouse report, I need to clean up these bin records — please deduplicate any exact duplicate rows and give me the frequency counts by store group for the occupied and available volumes across all entries."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying which rows among the submitted warehouse bin records are identical duplicates, and (2) a category frequency report counting how often each store_group value appears in the dataset. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, store_group, date, occupied_volume, available_volume) on any row causes validation error","Invalid date format (not YYYY-MM-DD) triggers schema validation failure","Empty rows array returns no meaningful report","Numeric values outside ±1,000,000,000,000 range are rejected","Payment of 0.01 USDC not fulfilled causes 402 response"],"whenToPreferThis":"Choose this endpoint when you have warehouse bin records (with occupied_volume and available_volume fields) and need both duplicate row detection and store_group category frequency analysis in a single low-cost call. It is ideal for data quality checks on small-to-medium datasets (up to 200 rows) before downstream reporting or aggregation. Prefer this over general-purpose analytics tools when you want a simple, pre-packaged pair of reports without setting up a full analytics pipeline.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:35:04.614Z","isFirstParty":false,"canonicalSlug":"warehouse-bins-exact-row-deduplication-category-frequencies-61f7dc15"}