{"uid":"cap_pRvfDX8lLzY3xFB9X0XLq","slug":"tutorial-completion-string-normalisation-duplicate-key-report-c4d3c82d","name":"Tutorial Completion — String Normalisation + Duplicate Key Report","description":"Tutorial completion — String normalisation + Duplicate key report: String normalisation + 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-021?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_O2NZtXEDOdGoLX91bsPbk","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 analytical reports: string normalization and duplicate key detection, for up to 200 rows.","exampleAgentPrompt":"Can you check my tutorial completion data for duplicate row IDs and normalize the game_area strings? I have about 50 rows with fields like row_id, game_area, date, starts, and completions — here's the data.","exampleUseCases":[{"title":"Audit game tutorial data quality","prompt":"I've got a batch of tutorial completion records from our game — around 80 rows with row_id, game_area, date, starts, and completions. Can you check them for duplicate keys and normalize any inconsistent game_area strings so I know what needs fixing?"},{"title":"Detect duplicate entries before reporting","prompt":"Before I run my weekly tutorial funnel report, can you scan these 120 tutorial completion rows for any duplicate row_id values and flag any string normalization issues in the game_area column?"},{"title":"Clean tutorial dataset for analysis","prompt":"I have a CSV export of tutorial starts and completions across different game areas — about 150 rows. Can you normalize the string fields and tell me which row IDs appear more than once so I can clean it up?"}],"resultDescription":"Returns two independent analytical reports: (1) a string normalization report identifying and standardizing inconsistent string values in fields like game_area, and (2) a duplicate key report flagging rows where row_id or key fields appear more than once. Both reports are generated from the supplied data locally with no external lookups.","failureModes":["Input array is empty (minItems: 1 not met)","Input array exceeds 200 rows (maxItems exceeded)","Invalid date format (must match YYYY-MM-DD pattern)","row_id field missing or empty (required, minLength: 1)","Malformed numeric values for starts or completions outside allowed range","Payment not fulfilled via x402 protocol resulting in 402 response"],"whenToPreferThis":"Choose this endpoint when you need two simultaneous data quality reports — string normalization and duplicate key detection — on tutorial completion records (starts/completions by game area and date) in a single low-cost call. It is best suited for batch offline analysis of up to 200 rows where no live data lookup, prediction, or external enrichment is needed. Prefer alternatives if you need more than 200 rows, real-time validation, or different report types such as numeric distribution or outlier detection.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:33.260Z","isFirstParty":false,"canonicalSlug":"tutorial-completion-string-normalisation-duplicate-key-report-c4d3c82d"}