{"uid":"cap_SQk7Z6Lx9Im4IKSa8h0dB","slug":"compositing-graphs-duplicate-key-report-date-by-category-pivot-40366e59","name":"Compositing Graphs — Duplicate Key Report + Date by Category Pivot","description":"Compositing graphs — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied compositing graphs records (node_count, render_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-09-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","node_count","render_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"node_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"render_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","node_count":10,"asset_group":"group-a","render_seconds":1},{"date":"2026-10-02","row_id":"row-2","node_count":20,"asset_group":"group-b","render_seconds":2},{"date":"2026-10-03","row_id":"row-3","node_count":15,"asset_group":"group-a","render_seconds":3},{"date":"2026-10-04","row_id":"row-4","node_count":30,"asset_group":"group-b","render_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["node_count","render_seconds"],"type":"string","default":"node_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_CB67xPbrgJv8uubH1p_PY","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 analytical reports on compositing graph records: a duplicate key report and a date-by-category pivot, for up to 200 rows of node_count or render_seconds data.","exampleAgentPrompt":"Can you run a duplicate key report and a date-by-category pivot on my compositing graph data — here are 4 rows with row IDs, asset groups, dates, and node counts — I want to analyze node_count specifically.","exampleUseCases":[{"title":"Detecting duplicate asset groups in renders","prompt":"I have a list of compositing graph records with row IDs, asset groups, dates, and render times — can you run a duplicate key report on them to find any repeated asset_group values, and also give me a date-by-category pivot for render_seconds?"},{"title":"Pivoting node counts by date for VFX pipeline","prompt":"Here are 150 rows of compositing graph data with node_count and render_seconds per asset group and date — can you pivot the node_count field by date and category and also flag any duplicate row IDs?"},{"title":"QA check on compositing graph exports","prompt":"I exported compositing graph records from our render farm — can you check for duplicate row keys and also show me a pivot table of node_count broken down by asset_group and date so I can spot anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying repeated row_id or asset_group values in the supplied records, and (2) a date-by-category pivot table of the selected numeric metric (node_count or render_seconds) broken down by date and asset_group, covering up to 200 input rows.","failureModes":["Input exceeds 200 rows — request will be rejected or truncated","Missing required fields (row_id, asset_group, date, node_count, render_seconds) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Numeric values outside the ±1,000,000,000,000 range are rejected","Empty rows array returns an error"],"whenToPreferThis":"Choose this endpoint when you have compositing graph records (with node_count or render_seconds metrics) and need both a duplicate key audit and a date-by-category pivot in a single low-cost call. It is ideal for VFX pipeline QA, render farm data validation, and compositing workflow analytics on datasets up to 200 rows. Not suitable for live lookups, predictions, or external data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:43:40.979Z","isFirstParty":false,"canonicalSlug":"compositing-graphs-duplicate-key-report-date-by-category-pivot-40366e59"}