{"uid":"cap_nWjN7XqjBAUWUiV78bNx_","slug":"material-libraries-duplicate-key-report-and-numeric-distribution-a68dc5ed","name":"Material Libraries Duplicate Key Report and Numeric Distribution","description":"Material libraries — Duplicate key report + Numeric distribution: Duplicate key report + Numeric distribution for supplied material libraries records (material_count, texture_mb). 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-03-055?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","material_count","texture_mb"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"texture_mb":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"material_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","texture_mb":1,"asset_group":"group-a","material_count":10},{"date":"2026-10-02","row_id":"row-2","texture_mb":2,"asset_group":"group-b","material_count":20},{"date":"2026-10-03","row_id":"row-3","texture_mb":3,"asset_group":"group-a","material_count":15},{"date":"2026-10-04","row_id":"row-4","texture_mb":4,"asset_group":"group-b","material_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["material_count","texture_mb"],"type":"string","default":"material_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_wB40ZXGxJmpYoPkdSpm5l","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 up to 200 material library records to produce a duplicate key report and numeric distribution for material_count or texture_mb fields.","exampleAgentPrompt":"Can you run a duplicate key report and numeric distribution on my material library records? I have rows with asset groups like 'environment' and 'character', dates, material counts, and texture sizes in MB — check the material_count field for the distribution.","exampleUseCases":[{"title":"Audit game asset library for duplicates","prompt":"I have a list of about 150 material library entries from our game project with row IDs, asset groups, dates, material counts, and texture sizes. Can you check for any duplicate row IDs and give me a numeric distribution of the material_count values?"},{"title":"Analyze texture size spread across groups","prompt":"Here are 80 records from our material database — each has a row ID, asset group, date, material count, and texture_mb. Run a duplicate key check and show me the numeric distribution of texture_mb across all entries."},{"title":"Quality check before material library import","prompt":"Before I import these 120 material records into our system, can you scan for any duplicate keys and give me a distribution breakdown of the material_count field so I can spot anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any repeated row_id values across the submitted records, and (2) a numeric distribution summary for the selected field (material_count or texture_mb), such as histogram buckets, min/max, mean, and frequency counts. No external lookups are performed — all analysis runs on the supplied data locally.","failureModes":["Submitting more than 200 rows returns an error — batch must be split","Missing required fields (row_id, asset_group, date, material_count, texture_mb) cause validation failure","Invalid date format (non YYYY-MM-DD) triggers schema rejection","Specifying a field value outside the enum ['material_count','texture_mb'] returns an error","Empty rows array is rejected by minItems:1 constraint"],"whenToPreferThis":"Choose this endpoint when you have up to 200 material library records and need both a duplicate key audit and a numeric distribution report in a single call without any external data lookups or predictions. Ideal for pre-import data quality checks, pipeline validation steps, or ad-hoc audits of 3D asset or texture metadata. Not suitable if you need live lookups, predictions, or more than 200 rows processed at once.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T06:49:13.242Z","isFirstParty":false,"canonicalSlug":"material-libraries-duplicate-key-report-and-numeric-distribution-a68dc5ed"}