{"uid":"cap_CzjwFtEBOBFaMAQJFHK2c","slug":"coordinate-quality-checks-duplicate-key-report-numeric-row-ordering-f36dc8b9","name":"Coordinate Quality Checks — Duplicate Key Report + Numeric Row Ordering","description":"Coordinate quality checks — Duplicate key report + Numeric row ordering: Duplicate key report + Numeric row ordering for supplied coordinate quality checks records (checked_points, flagged_points). 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-weather-23-058?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","checked_points","flagged_points"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"station_group":{"type":"string","default":"","maxLength":80},"checked_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"flagged_points":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","station_group":"group-a","checked_points":10,"flagged_points":1},{"date":"2026-10-02","row_id":"row-2","station_group":"group-b","checked_points":20,"flagged_points":2},{"date":"2026-10-03","row_id":"row-3","station_group":"group-a","checked_points":15,"flagged_points":3},{"date":"2026-10-04","row_id":"row-4","station_group":"group-b","checked_points":30,"flagged_points":4}],"maxItems":200,"minItems":1},"field":{"enum":["checked_points","flagged_points"],"type":"string","default":"checked_points"}}},"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__oyrxYL4qRmg2_GtV2jfs","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 coordinate quality check records to produce a duplicate key report and a numeric row ordering report for up to 200 rows.","exampleAgentPrompt":"I have a dataset of coordinate quality check records with station groups, dates, checked_points, and flagged_points — can you run a duplicate key report and a numeric row ordering on it, sorting by checked_points, for up to 200 rows?","exampleUseCases":[{"title":"Audit station quality data for duplicates","prompt":"I have 150 rows of coordinate quality check records from multiple station groups. Can you scan them for any duplicate row IDs and also give me a numeric ranking by flagged_points so I can see which stations had the most issues?"},{"title":"Rank monitoring records by checked points","prompt":"Here are my quality check records for weather monitoring stations across several dates — can you produce a numeric row ordering by checked_points and also flag any duplicate keys in the dataset?"},{"title":"Pre-analysis data cleanup for coordinate records","prompt":"Before I run my analysis, I want to make sure my coordinate quality check data is clean — please run a duplicate key report and sort the rows numerically by flagged_points for these 80 records."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report identifying any rows sharing the same key fields, and (2) a numeric row ordering report ranking the supplied records by the chosen field (checked_points or flagged_points). Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Input array is empty or exceeds 200 rows — validation error returned","Required fields (row_id, station_group, date, checked_points, flagged_points) missing from one or more rows — schema validation failure","Invalid date format (not YYYY-MM-DD) — pattern validation error","Field enum value not matching checked_points or flagged_points — rejected input","Null numeric values may affect ordering logic — partial results or null-handling edge cases"],"whenToPreferThis":"Choose this endpoint when you need a quick, low-cost ($0.01 USDC) dual-report analysis — duplicate key detection plus numeric row ordering — on up to 200 rows of coordinate or station quality check records, without requiring any live lookup, external API call, or professional assessment. It is best suited for lightweight data quality auditing tasks on pre-collected tabular datasets involving checked_points and flagged_points metrics.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T00:42:29.762Z","isFirstParty":false,"canonicalSlug":"coordinate-quality-checks-duplicate-key-report-numeric-row-ordering-f36dc8b9"}