{"uid":"cap_jUMR_EVCSxQ-cWHLaRTnt","slug":"tutorial-completion-duplicate-key-report-category-frequencies-4ad0ce33","name":"Tutorial Completion — Duplicate Key Report + Category Frequencies","description":"Tutorial completion — Duplicate key report + Category frequencies: Duplicate key report + Category frequencies 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-057?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_tkBw46i_kwVtnlgt9UGuK","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 a duplicate key report and category frequency breakdown for up to 200 rows.","exampleAgentPrompt":"Can you check my tutorial completion data for duplicate row IDs and also tell me how many times each game area appears? Here are 4 rows: row-1 on 2026-10-01 in group-a with 10 starts and 1 completion, row-2 on 2026-10-02 in group-b with 20 starts and 2 completions, row-3 on 2026-10-03 in group-a with 15 starts and 3 completions, and row-4 on 2026-10-04 in group-b with 30 starts and 4 completions.","exampleUseCases":[{"title":"Auditing game area distribution in tutorial data","prompt":"I have a batch of tutorial records across different game areas — can you tell me how frequently each game area shows up and flag any duplicate row IDs in the dataset? I'll give you the rows now."},{"title":"Detecting duplicate entries before data pipeline ingestion","prompt":"Before I load these 150 tutorial completion records into our data warehouse, can you run a duplicate key check on the row IDs and also give me a frequency count of how many records fall into each game area category?"},{"title":"Summarizing category breakdown for tutorial reporting","prompt":"I need a quick report on our tutorial starts and completions — specifically, how many records belong to each game area, and whether any row IDs are repeated. Here's the full list of up to 200 rows."}],"resultDescription":"Two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once in the supplied data, and (2) a category frequency table counting how many records belong to each distinct game_area value. No external lookups or predictions are made — all analysis is performed locally on the submitted rows.","failureModes":["Fewer than 1 row submitted — request rejected due to minItems constraint","More than 200 rows submitted — request rejected due to maxItems limit","Missing required fields (row_id, game_area, date, starts, completions) on any row — validation error","Date field does not match YYYY-MM-DD pattern — schema validation failure","row_id exceeds 80 character maxLength — rejected","starts or completions values outside allowed numeric range — validation error"],"whenToPreferThis":"Choose this endpoint when you need fast, local analytical reports on tutorial completion datasets without any external lookups or live data dependencies. It is ideal for data quality audits (duplicate key detection) combined with categorical summarization (game area frequencies) in a single low-cost call. Best suited for gaming or e-learning analytics pipelines where you want to validate and summarize tutorial engagement data before downstream processing.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:26.893Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-duplicate-key-report-category-frequencies-4ad0ce33"}