{"uid":"cap_ir0YiR5ZwRFwVqquRaJrz","slug":"tutorial-completion-duplicate-key-report-and-adjacent-row-changes-0031a6cd","name":"Tutorial Completion Duplicate Key Report and Adjacent Row Changes","description":"Tutorial completion — Duplicate key report + Adjacent row changes: Duplicate key report + Adjacent row changes 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-062?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},"field":{"enum":["starts","completions"],"type":"string","default":"starts"}}},"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_loBzdyC_2R9TwD-IG5D6q","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":"Analyzes tutorial completion records (starts and completions) to produce two reports: a duplicate key report and an adjacent row changes report, for up to 200 rows.","exampleAgentPrompt":"Can you run a duplicate key report and adjacent row changes analysis on my tutorial completion data? Here are the rows — each has a row_id, game_area, date, starts, and completions — and I want to check the 'completions' field for row changes.","exampleUseCases":[{"title":"Spot duplicate tutorial records by game area","prompt":"I have 150 rows of tutorial tracking data with row IDs, game areas, dates, starts, and completions — can you check the 'starts' field for duplicates and flag any adjacent rows where the value changes?"},{"title":"QA check on daily tutorial funnel data","prompt":"Before I load this tutorial funnel data into our dashboard, can you run a duplicate key check and adjacent row change report on it? I'll give you the rows with row_id, game_area, date, starts, and completions."},{"title":"Identify data entry errors in completion logs","prompt":"We've been getting inconsistent tutorial completion numbers across our game areas — can you analyze these records for duplicate keys and highlight where completions change between consecutive rows?"}],"resultDescription":"Two independent analytical reports: (1) a duplicate key report identifying rows with duplicate key combinations within the supplied dataset, and (2) an adjacent row changes report showing where the selected field (starts or completions) changes between consecutive rows. Both reports are generated locally from the submitted data with no external lookups.","failureModes":["Input array is empty or missing (minItems:1 violated)","More than 200 rows submitted (maxItems:200 violated)","Row missing required fields: row_id, game_area, date, starts, or completions","Date field does not match YYYY-MM-DD pattern","row_id or game_area exceeds 80 character maxLength","Numeric values for starts or completions outside allowed range","Invalid field enum value (must be 'starts' or 'completions')","Payment not provided or insufficient (requires 0.01 USDC via x402)"],"whenToPreferThis":"Choose this endpoint when you have tutorial completion tracking data (up to 200 rows) and need both a duplicate key check and an adjacent row change report in a single call for a flat $0.01 USDC fee. It is best suited for data quality audits of game tutorial funnel records where you want to detect duplicates and spot anomalous transitions between consecutive entries without any external API calls or live data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-29T12:53:38.454Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-duplicate-key-report-and-adjacent-row-changes-0031a6cd"}