{"uid":"cap_rgMGVQU3_j9NFaSqBuFvb","slug":"animation-clips-duplicate-key-report-date-by-category-pivot-2b718821","name":"Animation Clips Duplicate Key Report + Date by Category Pivot","description":"Animation clips — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied animation clips records (frame_count, duration_seconds). 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-creative-07-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","frame_count","duration_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"frame_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duration_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","frame_count":10,"duration_seconds":1},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","frame_count":20,"duration_seconds":2},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","frame_count":15,"duration_seconds":3},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","frame_count":30,"duration_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["frame_count","duration_seconds"],"type":"string","default":"frame_count"}}},"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_6S-HSE08g6x8Sl9irzFl9","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 supplied animation clip records to produce a duplicate key report and a date-by-category pivot table for frame_count or duration_seconds, covering up to 200 rows.","exampleAgentPrompt":"Check my animation clip records for duplicate keys and also give me a pivot of frame_count by date and asset_group — here are my rows: row-1, group-a, 2026-10-01, 10 frames, 1s; row-2, group-b, 2026-10-02, 20 frames, 2s; row-3, group-a, 2026-10-03, 15 frames, 3s. Use frame_count as the field.","exampleUseCases":[{"title":"Duplicate clip ID audit for pipeline","prompt":"I have a batch of animation clip records from our pipeline and I want to know if any row IDs or key combinations are duplicated — can you run a duplicate key report on these 50 clips using frame_count as the field?"},{"title":"Date-category pivot for animation library","prompt":"Can you pivot my animation library data by date and asset_group, showing frame_count totals? I'll give you about 120 rows with row IDs, group names, dates, frame counts, and durations."},{"title":"QA check on imported animation assets","prompt":"We just imported a new batch of animation assets and I need to validate that there are no duplicate keys and also see a date-by-category breakdown of duration_seconds — here are the 80 records."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any records sharing the same key fields within the supplied animation clip data, and (2) a date-by-category pivot table aggregating the selected metric (frame_count or duration_seconds) across dates and asset groups. Covers up to 200 input rows. No external data is fetched; all analysis is performed locally on the supplied records.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, asset_group, date, frame_count, duration_seconds) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Invalid field enum value (not frame_count or duration_seconds) — schema rejection","Empty rows array — minimum 1 item required","Numeric values out of range (beyond ±1,000,000,000,000) — schema validation error"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a date-by-category pivot on animation clip records in a single call for a flat $0.01 USDC fee. It is ideal for pipeline QA, asset library audits, and batch analytics on up to 200 animation clip rows without requiring any external data sources or live lookups. Not suitable for real-time streaming analysis, datasets exceeding 200 rows, or non-animation data domains.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-21T18:57:03.265Z","isFirstParty":false,"canonicalSlug":"animation-clips-duplicate-key-report-date-by-category-pivot-2b718821"}