{"uid":"cap_8OGlZjsZZ8iR8mqrp8OUZ","slug":"rig-complexity-exact-row-deduplication-date-by-category-pivot-e78f0dc4","name":"Rig Complexity — Exact Row Deduplication + Date by Category Pivot","description":"Rig complexity — Exact row deduplication + Date by category pivot: Exact row deduplication + Date by category pivot for supplied rig complexity records (bone_count, constraint_count). 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-04-052?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","bone_count","constraint_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"bone_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"constraint_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","bone_count":10,"asset_group":"group-a","constraint_count":1},{"date":"2026-10-02","row_id":"row-2","bone_count":20,"asset_group":"group-b","constraint_count":2},{"date":"2026-10-03","row_id":"row-3","bone_count":15,"asset_group":"group-a","constraint_count":3},{"date":"2026-10-04","row_id":"row-4","bone_count":30,"asset_group":"group-b","constraint_count":4}],"maxItems":200,"minItems":1},"field":{"enum":["bone_count","constraint_count"],"type":"string","default":"bone_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_xsxWZcPKEQ3BTUXpy9lcc","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":"Deduplicates rig complexity records and produces a date-by-category pivot table for bone_count or constraint_count fields, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"I have a dataset of up to 150 rig complexity records with bone_count and constraint_count per asset group and date — can you run exact row deduplication and a date-by-category pivot on the bone_count field and give me both reports?","exampleUseCases":[{"title":"Cleaning duplicate rig records before export","prompt":"I've got a list of rig complexity entries for our character assets — some rows got duplicated during the export. Can you deduplicate them exactly and also give me a pivot of bone_count by date and asset group? Here are the rows with row_id, asset_group, date, bone_count, and constraint_count."},{"title":"Comparing constraint counts across asset groups over time","prompt":"Can you run a date-by-category pivot on constraint_count for my rig complexity data? I want to see how constraint counts vary across different asset groups across dates, and also clean out any duplicate rows first."},{"title":"Pre-pipeline rig data quality check for animation studio","prompt":"Before we push our rig data into the pipeline, I need to deduplicate the records and get a pivot table breaking down bone_count by date and asset group. We have about 180 rows covering groups like 'hero', 'prop', and 'environment' from 2025-01-01 to 2025-06-30."}],"resultDescription":"Returns two reports: (1) an exact row deduplication report identifying and removing fully duplicate entries from the supplied rig complexity records, and (2) a date-by-category pivot table showing the selected numeric field (bone_count or constraint_count) broken down by date and asset_group. Both reports are computed locally with no external lookups.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, asset_group, date, bone_count, constraint_count) cause validation failure","Invalid date format (not YYYY-MM-DD) triggers pattern validation error","Numeric values outside allowed range cause schema rejection","Empty rows array returns error","Invalid field enum value (not bone_count or constraint_count) causes failure"],"whenToPreferThis":"Choose this endpoint when you have rig complexity records (with bone_count and/or constraint_count per asset group and date) that need both exact row deduplication and a date-by-category pivot in a single low-cost call. Ideal for animation and rigging pipelines where data cleaning and summarization are needed together before downstream processing. Best suited for batch sizes up to 200 rows where no live lookup, external data enrichment, or predictive modeling is required.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-22T00:49:17.925Z","isFirstParty":false,"canonicalSlug":"rig-complexity-exact-row-deduplication-date-by-category-pivot-e78f0dc4"}