{"uid":"cap_WUr60vWVgkFAXyRYTcVl2","slug":"controller-sampling-exact-row-deduplication-duplicate-key-report-507ab04a","name":"Controller Sampling — Exact Row Deduplication + Duplicate Key Report","description":"Controller sampling — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied controller sampling records (input_latency_ms, sample_count). 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-game-15-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","game_area","date","input_latency_ms","sample_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"game_area":{"type":"string","default":"","maxLength":80},"sample_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"input_latency_ms":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","game_area":"group-a","sample_count":1,"input_latency_ms":10},{"date":"2026-10-02","row_id":"row-2","game_area":"group-b","sample_count":2,"input_latency_ms":20},{"date":"2026-10-03","row_id":"row-3","game_area":"group-a","sample_count":3,"input_latency_ms":15},{"date":"2026-10-04","row_id":"row-4","game_area":"group-b","sample_count":4,"input_latency_ms":30}],"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_ja-D4LhD3DG2sdcFkYAZL","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 controller sampling records by exact row match and generates a duplicate key report for up to 200 rows of input_latency_ms and sample_count data.","exampleAgentPrompt":"I have a batch of controller sampling records with fields like game_area, date, input_latency_ms, and sample_count — can you run exact row deduplication and give me a duplicate key report on them? Here are up to 200 rows: row-1, group-a, 2026-10-01, latency 10ms, sample_count 1; row-2, group-b, 2026-10-02, latency 20ms, sample_count 2.","exampleUseCases":[{"title":"Cleaning duplicate game latency logs","prompt":"I've collected controller sampling data from multiple game areas and I think there are exact duplicate rows — can you deduplicate them and tell me which row_ids have duplicate keys? I have about 150 rows with fields: row_id, game_area, date, input_latency_ms, and sample_count."},{"title":"Auditing repeated sample entries","prompt":"My pipeline accidentally submitted some controller sampling records twice. Can you run exact row deduplication and a duplicate key report on this set of 80 rows covering game areas like group-a and group-b, with dates in October 2026 and input_latency_ms values ranging from 10 to 30ms?"},{"title":"QA check on sampling dataset before analysis","prompt":"Before I analyze our controller input latency data, I want to make sure there are no duplicate rows or repeated keys. Please deduplicate these 200 controller sampling records and give me a full duplicate key report — the data includes row_id, game_area, date, input_latency_ms, and sample_count."}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication result identifying and removing fully duplicate rows from the supplied controller sampling records, and (2) a duplicate key report listing any row_id or key combinations that appear more than once. Both reports are generated locally without external lookups, covering up to 200 input rows.","failureModes":["Input exceeds 200 rows — request rejected with validation error","Missing required fields (row_id, date, game_area, input_latency_ms, sample_count) — row-level validation failure","Date field not matching YYYY-MM-DD pattern — schema validation error","Numeric fields out of allowed range (±1,000,000,000,000) — schema rejection","Empty rows array — minimum item count violation"],"whenToPreferThis":"Choose this endpoint when you have controller sampling records (with input_latency_ms and sample_count fields) and need both exact row deduplication and a duplicate key audit in a single low-cost call. It is ideal for data cleaning pipelines prior to game analytics, QA workflows flagging repeated submissions, or any scenario where you need two complementary data quality reports on up to 200 rows for $0.01 USDC without external dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:31:59.306Z","isFirstParty":false,"canonicalSlug":"controller-sampling-exact-row-deduplication-duplicate-key-report-507ab04a"}