{"uid":"cap_x63fWlH_qLJl3BvbR66xM","slug":"audio-voices-duplicate-key-report-date-by-category-pivot-154c49ca","name":"Audio Voices Duplicate Key Report + Date by Category Pivot","description":"Audio voices — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied audio voices records (active_voices, audio_cpu_ms). 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-10-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","game_area","date","active_voices","audio_cpu_ms"],"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},"audio_cpu_ms":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"active_voices":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","game_area":"group-a","audio_cpu_ms":1,"active_voices":10},{"date":"2026-10-02","row_id":"row-2","game_area":"group-b","audio_cpu_ms":2,"active_voices":20},{"date":"2026-10-03","row_id":"row-3","game_area":"group-a","audio_cpu_ms":3,"active_voices":15},{"date":"2026-10-04","row_id":"row-4","game_area":"group-b","audio_cpu_ms":4,"active_voices":30}],"maxItems":200,"minItems":1},"field":{"enum":["active_voices","audio_cpu_ms"],"type":"string","default":"active_voices"}}},"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_a_aA0B2DLkSHYxw6Zb5Uq","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":"Runs two local analytical reports on supplied audio voice records: a duplicate key report and a date-by-category pivot, for up to 200 rows.","exampleAgentPrompt":"I have game audio records with row IDs, game areas, dates, and active_voices counts — can you run a duplicate key report and a date-by-category pivot on them? Here's my data: row-1, group-a, 2026-10-01, 10 active voices, 1ms CPU; row-2, group-b, 2026-10-02, 20 active voices, 2ms CPU; row-3, group-a, 2026-10-03, 15 active voices, 3ms CPU — use active_voices as the field.","exampleUseCases":[{"title":"Detect duplicate voice record IDs","prompt":"I've got a batch of game audio logs with row IDs and I suspect some rows are duplicated — can you run a duplicate key report on these records? Here's the data: row-1/group-a/2026-10-01/10 active voices/1ms, row-2/group-b/2026-10-02/20 active voices/2ms, row-2/group-a/2026-10-03/15 active voices/3ms. Use active_voices as the field."},{"title":"Pivot audio CPU usage by date and area","prompt":"Can you pivot my game audio CPU milliseconds data by date and game area? I have four records: row-1/group-a/2026-10-01/1ms, row-2/group-b/2026-10-02/2ms, row-3/group-a/2026-10-03/3ms, row-4/group-b/2026-10-04/4ms. Use audio_cpu_ms as the field."},{"title":"Audit voice data quality before ingestion","prompt":"Before I load these audio voice records into our system, can you check for duplicate row IDs and show me a date-by-category breakdown of active voices? Data: row-1/group-a/2026-10-01/10, row-2/group-b/2026-10-02/20, row-3/group-a/2026-10-03/15, row-4/group-b/2026-10-04/30. Field should be active_voices."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any rows sharing the same row_id, and (2) a date-by-category pivot table aggregating the selected metric (active_voices or audio_cpu_ms) broken down by date and game_area. Up to 200 rows processed per call.","failureModes":["More than 200 rows submitted — request rejected or truncated","Missing required fields (row_id, game_area, date, active_voices, audio_cpu_ms) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Invalid field enum value (not active_voices or audio_cpu_ms) causes error","Empty rows array fails minItems validation","Payment not provided or insufficient USDC causes 402 response"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key check and a date-by-category pivot on game audio voice data (active_voices or audio_cpu_ms) in a single low-cost call. It is ideal for data quality audits and aggregation reporting on small-to-medium datasets (up to 200 rows) without needing an external database or analytics engine. Prefer it over generic analytics tools when your data matches the audio voices schema and you want both reports bundled for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:33:21.051Z","isFirstParty":false,"canonicalSlug":"audio-voices-duplicate-key-report-date-by-category-pivot-154c49ca"}