{"uid":"cap_kweJyFIf3IorGiRMqloc3","slug":"air-quality-observations-duplicate-key-report-cbfdb6a4","name":"Air Quality Observations – Duplicate Key Report","description":"Air quality observations - Duplicate key report: Duplicate key report for Air quality observations. Up to 200 supplied typed records. Local descriptive analytics; no enrichment or forecast. One of 25 new profiles across 20 shared operations in this industry. 0.01 USDC includes one bounded duplicate key report report.","url":"https://market.datapackvibe.com/x402/assistant-ar-analytics-air-quality-observations-key-duplicates?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station","date","pm25","humidity_percent"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"pm25":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"station":{"type":"string","default":"","maxLength":80},"humidity_percent":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","pm25":10,"row_id":"row-1","station":"group-a","humidity_percent":1},{"date":"2026-10-02","pm25":20,"row_id":"row-2","station":"group-b","humidity_percent":2},{"date":"2026-10-03","pm25":15,"row_id":"row-3","station":"group-a","humidity_percent":3},{"date":"2026-10-04","pm25":30,"row_id":"row-4","station":"group-b","humidity_percent":4}],"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_e2-8Dw_Z3t6ZQrk4O3yIC","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":"Identifies duplicate key combinations in air quality observation records (station, date, PM2.5, humidity) submitted in a batch of up to 200 rows.","exampleAgentPrompt":"Check my air quality observation records for duplicate keys — I have a batch of readings from stations group-a and group-b between 2026-10-01 and 2026-10-04 with PM2.5 and humidity values, and I need to know which row_id entries share duplicate station/date combinations.","exampleUseCases":[{"title":"Sensor network data deduplication audit","prompt":"I've collected air quality readings from 10 monitoring stations over the past month and I suspect some dates were logged twice. Can you check these records for duplicate station-date key pairs and tell me which row IDs are duplicated? I'll give you up to 150 rows with station name, date, PM2.5 and humidity."},{"title":"ETL pipeline data quality check","prompt":"Before I load this batch of air quality observations into our database, run a duplicate key check on these 80 records — each has a row_id, station, date, pm25 and humidity_percent. I need to catch any collisions before they cause insert errors."},{"title":"Environmental compliance data validation","prompt":"We need to submit clean air quality data for our quarterly compliance report. Can you scan these 200 station observation records and flag any duplicate keys — same station and date appearing more than once — so we can remove them before submission?"}],"resultDescription":"A descriptive analytics report identifying which rows in the submitted batch share duplicate key combinations across the key fields (station, date, and associated measurements). The report includes details on which row_ids are duplicates and how many collisions exist, enabling data cleaning decisions. No enrichment, forecasting, or external data is added.","failureModes":["Fewer than 1 row submitted returns a validation error","More than 200 rows submitted exceeds the maxItems limit and returns an error","Missing required fields (row_id, station, date, pm25, humidity_percent) on any row causes schema validation failure","Date strings not matching YYYY-MM-DD pattern are rejected","Payment of 0.01 USDC not provided results in 402 Payment Required","Malformed JSON body returns a 400 Bad Request"],"whenToPreferThis":"Choose this endpoint when you need a quick, low-cost ($0.01 USDC) local duplicate key audit on a batch of up to 200 air quality observation records without needing enrichment or forecasting. It is ideal for data pipeline pre-validation, ETL deduplication checks, or compliance data cleaning specific to the air quality domain (station, date, PM2.5, humidity schema).","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:12:54.373Z","isFirstParty":false,"canonicalSlug":"air-quality-observations-duplicate-key-report-cbfdb6a4"}