{"uid":"cap_J_KLnSI-QgSNW71ggxoYs","slug":"tutorial-completion-exact-row-deduplication-duplicate-key-report-cc67d9b7","name":"Tutorial Completion — Exact Row Deduplication + Duplicate Key Report","description":"Tutorial completion — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied tutorial completion records (starts, completions). 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-20-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","game_area","date","starts","completions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"starts":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"game_area":{"type":"string","default":"","maxLength":80},"completions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","starts":10,"game_area":"group-a","completions":1},{"date":"2026-10-02","row_id":"row-2","starts":20,"game_area":"group-b","completions":2},{"date":"2026-10-03","row_id":"row-3","starts":15,"game_area":"group-a","completions":3},{"date":"2026-10-04","row_id":"row-4","starts":30,"game_area":"group-b","completions":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_yzKG6MQ-gQQ_lc1t_S_TA","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 exact rows and generates a duplicate key report for tutorial completion records (starts and completions), processing up to 200 rows with two independent analytical reports.","exampleAgentPrompt":"I have a list of tutorial completion records with fields like row_id, game_area, date, starts, and completions — can you run exact row deduplication and produce a duplicate key report on these rows so I can clean up the dataset?","exampleUseCases":[{"title":"Game tutorial data cleanup","prompt":"I've got up to 150 rows of tutorial completion records from our game, each with a row_id, game_area, date, starts count, and completions count — can you deduplicate them exactly and give me a report of any duplicate keys so I know what to clean up?"},{"title":"Daily tutorial pipeline audit","prompt":"Before I load today's tutorial starts and completions into our warehouse, can you check these records for exact duplicate rows and flag any duplicate row_id or game_area/date key combinations? I have about 80 rows to check."},{"title":"QA check on tutorial export","prompt":"We exported tutorial completion logs from two systems and merged them — there are around 200 rows with game_area, date, starts, and completions fields. Can you run deduplication and a duplicate key report to catch any overlap before we report the numbers?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing fully identical rows from the input dataset, and (2) a duplicate key report flagging records that share the same key fields (e.g. row_id, game_area, date) even if other columns differ — all derived purely from the supplied input rows with no external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, game_area, date, starts, completions) on any row — validation error","Invalid date format not matching YYYY-MM-DD pattern — schema validation failure","Empty rows array (minItems:1 violated) — request rejected","Non-numeric starts or completions values outside allowed range — schema error"],"whenToPreferThis":"Choose this endpoint when you have tutorial completion data (game area, date, starts, completions rows) that needs both exact row-level deduplication and a duplicate key report in a single call, for up to 200 rows. It is ideal when you need offline/local analytical processing with no external data dependencies, and when you want two complementary data quality reports for the price of one call. Prefer alternatives if you need more than 200 rows, fuzzy matching, or additional report types beyond deduplication and duplicate key detection.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:51.160Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-exact-row-deduplication-duplicate-key-report-cc67d9b7"}