{"uid":"cap_Ii3PI3dPq-VJYsprMwOtp","slug":"code-review-analytics-duplicate-key-report-numeric-row-ordering-8255bf0c","name":"Code Review Analytics — Duplicate Key Report + Numeric Row Ordering","description":"Code review — Duplicate key report + Numeric row ordering: Duplicate key report + Numeric row ordering for supplied code review records (pull_requests, review_hours). 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-software-11-058?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","component","date","pull_requests","review_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"component":{"type":"string","default":"","maxLength":80},"review_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"pull_requests":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","component":"group-a","review_hours":1,"pull_requests":10},{"date":"2026-10-02","row_id":"row-2","component":"group-b","review_hours":2,"pull_requests":20},{"date":"2026-10-03","row_id":"row-3","component":"group-a","review_hours":3,"pull_requests":15},{"date":"2026-10-04","row_id":"row-4","component":"group-b","review_hours":4,"pull_requests":30}],"maxItems":200,"minItems":1},"field":{"enum":["pull_requests","review_hours"],"type":"string","default":"pull_requests"}}},"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_4TqT-UvsHSNdXevKgE2cl","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 code review records (pull_requests, review_hours) to produce a duplicate key report and a numeric row ordering report for up to 200 rows.","exampleAgentPrompt":"Check my code review data for duplicate row IDs and also rank the rows numerically by pull_requests — here are the records: row-1 for group-a on 2026-10-01 with 10 pull requests and 1 review hour, row-2 for group-b on 2026-10-02 with 20 pull requests and 2 review hours.","exampleUseCases":[{"title":"Duplicate key audit for sprint data","prompt":"I have 50 code review entries from last sprint and I suspect some row IDs got duplicated when we merged the datasets — can you run a duplicate key report on them and also order the rows by review_hours so I can see which components took longest?"},{"title":"Code review leaderboard by pull requests","prompt":"Take these 30 pull request records across our three teams and give me a numeric ordering by pull_requests field, plus flag any rows that share the same row ID."},{"title":"Data quality check before dashboard import","prompt":"Before I import this code review CSV into our dashboard, can you scan these 120 rows for any duplicate row IDs and also sort them numerically by review_hours so I can spot anomalies?"}],"resultDescription":"Two independent analytical reports: (1) a duplicate key report listing any row_id values that appear more than once in the supplied dataset, and (2) a numeric row ordering report ranking all rows by the selected field (pull_requests or review_hours), all computed locally without external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, component, date, pull_requests, review_hours) — validation error","Invalid date format (must be YYYY-MM-DD) — schema validation failure","row_id empty or exceeds 80 characters — rejected","field enum value not 'pull_requests' or 'review_hours' — invalid input error","Empty rows array — minimum 1 item required"],"whenToPreferThis":"Choose this endpoint when you need fast, offline duplicate key detection and numeric ordering on code review tabular data (pull_requests, review_hours) without requiring external lookups, predictions, or professional assessments. It is ideal for data quality validation pipelines before importing code review metrics into dashboards or reports, handling up to 200 rows in a single $0.01 call that covers both reports simultaneously.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:32:15.463Z","isFirstParty":false,"canonicalSlug":"code-review-analytics-duplicate-key-report-numeric-row-ordering-8255bf0c"}