{"uid":"cap_8ed1CYFEueZONg8-ZaBBJ","slug":"forecast-verification-inputs-duplicate-key-report-date-by-category-0fc56c67","name":"Forecast Verification Inputs — Duplicate Key Report + Date by Category Pivot","description":"Forecast verification inputs — Duplicate key report + Date by category pivot: Duplicate key report + Date by category pivot for supplied forecast verification inputs records (forecast_value, observed_value). 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-24-068?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","station_group","date","forecast_value","observed_value"],"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},"forecast_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"observed_value":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","station_group":"group-a","forecast_value":10,"observed_value":1},{"date":"2026-10-02","row_id":"row-2","station_group":"group-b","forecast_value":20,"observed_value":2},{"date":"2026-10-03","row_id":"row-3","station_group":"group-a","forecast_value":15,"observed_value":3},{"date":"2026-10-04","row_id":"row-4","station_group":"group-b","forecast_value":30,"observed_value":4}],"maxItems":200,"minItems":1},"field":{"enum":["forecast_value","observed_value"],"type":"string","default":"forecast_value"}}},"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_mo9dFffKvy1YnUttrtHvh","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 forecast verification data (forecast_value, observed_value) to produce a duplicate key report and a date-by-category pivot table for up to 200 rows.","exampleAgentPrompt":"I have a set of forecast verification records with station groups and dates — can you run a duplicate key report and a date-by-category pivot on up to 200 rows using the forecast_value field? The data includes row IDs like 'row-1' through 'row-4', station groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and paired forecast and observed values.","exampleUseCases":[{"title":"Duplicate detection in forecast dataset","prompt":"I've got a batch of weather forecast verification records with row IDs and station groups — can you scan them for any duplicate keys and also give me a pivot of the forecast_value field broken down by date and station group? I have about 150 rows to process."},{"title":"Observed value pivot for model evaluation","prompt":"I'm comparing observed vs forecast temperatures across two station groups over a month. Can you take my 200 verification rows and produce a date-by-category pivot on the observed_value field, plus flag any duplicate row IDs in the dataset?"},{"title":"Data quality audit before forecast reporting","prompt":"Before I submit my forecast verification report, I want to make sure there are no duplicate entries and that my data looks right when pivoted by date and category. Can you run both a duplicate key report and a date-by-category pivot on my forecast_value records — I have about 80 rows with station groups and dates?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report flagging any repeated row_id values within the submitted dataset, and (2) a date-by-category pivot table summarizing the selected field (forecast_value or observed_value) broken down by date and station_group, for up to 200 submitted rows.","failureModes":["Exceeding 200-row limit returns an error or truncates input","Invalid date format (not YYYY-MM-DD) causes validation failure","Missing required fields (row_id, station_group, date, forecast_value, observed_value) causes rejection","Numeric values outside ±1,000,000,000,000 range fail validation","Empty rows array returns an error","Invalid field enum value (not 'forecast_value' or 'observed_value') causes schema rejection"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key report and a date-by-category pivot on forecast verification data (paired forecast and observed values) in a single low-cost call. It is best suited for data quality checks and exploratory analysis of weather or other forecast datasets up to 200 rows, with no need for external data lookups or live predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-31T00:43:09.254Z","isFirstParty":false,"canonicalSlug":"forecast-verification-inputs-duplicate-key-report-date-by-category-0fc56c67"}