{"uid":"cap_v3t4beFk_fh2blocOGgFv","slug":"feature-availability-exact-row-deduplication-duplicate-key-report-a695bd89","name":"Feature Availability — Exact Row Deduplication + Duplicate Key Report","description":"Feature availability — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied feature availability records (populated_features, expected_features). 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-analytics-10-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","dataset_group","date","populated_features","expected_features"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"dataset_group":{"type":"string","default":"","maxLength":80},"expected_features":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"populated_features":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","dataset_group":"group-a","expected_features":1,"populated_features":10},{"date":"2026-10-02","row_id":"row-2","dataset_group":"group-b","expected_features":2,"populated_features":20},{"date":"2026-10-03","row_id":"row-3","dataset_group":"group-a","expected_features":3,"populated_features":15},{"date":"2026-10-04","row_id":"row-4","dataset_group":"group-b","expected_features":4,"populated_features":30}],"maxItems":200,"minItems":1}}},"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_e4vM0BudRn2OPRapovXD7","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 feature availability records: exact row deduplication and duplicate key detection, for up to 200 rows per call.","exampleAgentPrompt":"Can you deduplicate these feature availability records and also flag any duplicate keys? I have up to 50 rows with fields like row_id, dataset_group, date, populated_features, and expected_features — I need both an exact row deduplication report and a duplicate key report.","exampleUseCases":[{"title":"ML pipeline feature audit","prompt":"I'm building an ML pipeline and suspect my feature availability log has duplicate entries. Can you run an exact row deduplication and duplicate key report on these 80 records? Each row has a row_id, dataset_group, date, populated_features count, and expected_features count."},{"title":"Data ingestion quality check","prompt":"Before I load this batch into our data warehouse, can you check these 120 feature availability rows for exact duplicates and any repeated row keys? The rows have date, row_id, dataset_group, populated_features, and expected_features fields."},{"title":"Daily feature coverage validation","prompt":"We track feature availability daily across dataset groups and need to catch any duplicate rows or duplicate row_id keys before reporting. Can you run both deduplication reports on these 35 rows with their populated and expected feature counts?"}],"resultDescription":"Returns two independent reports: (1) an exact row deduplication report identifying fully identical rows and the deduplicated clean set, and (2) a duplicate key report flagging rows sharing the same key (likely row_id or a composite key). Both reports are computed locally using analytical engines with no external lookups.","failureModes":["More than 200 rows submitted — endpoint rejects input exceeding maxItems limit","Missing required fields (row_id, date, populated_features, expected_features) cause validation errors","Invalid date format (not YYYY-MM-DD) triggers schema rejection","Numeric values outside the allowed range (-1e12 to 1e12) cause validation errors","Empty rows array (minItems: 1 not met) returns an error"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and duplicate key detection on feature availability data (with populated_features and expected_features fields) in a single $0.01 call covering up to 200 rows. Prefer it over manual deduplication scripts when you need two structured reports simultaneously without any external data lookups or network dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T06:45:14.232Z","isFirstParty":false,"canonicalSlug":"feature-availability-exact-row-deduplication-duplicate-key-report-a695bd89"}