{"uid":"cap_P4qn8Y-r6SlLS4DUOeAgJ","slug":"camera-coverage-record-quality-audit-deduplication-and-daily-sum-series-f1fde374","name":"Camera Coverage Record Quality Audit, Deduplication, and Daily Sum Series","description":"Camera coverage — Record quality audit + Exact row deduplication + Daily sum series: Record quality audit + Exact row deduplication + Daily sum series for supplied camera coverage records (shot_count, coverage_seconds). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-creative-12-215?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","shot_count","coverage_seconds"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"shot_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"asset_group":{"type":"string","default":"","maxLength":80},"coverage_seconds":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","shot_count":10,"asset_group":"group-a","coverage_seconds":1},{"date":"2026-10-02","row_id":"row-2","shot_count":20,"asset_group":"group-b","coverage_seconds":2},{"date":"2026-10-03","row_id":"row-3","shot_count":15,"asset_group":"group-a","coverage_seconds":3},{"date":"2026-10-04","row_id":"row-4","shot_count":30,"asset_group":"group-b","coverage_seconds":4}],"maxItems":200,"minItems":1},"field":{"enum":["shot_count","coverage_seconds"],"type":"string","default":"shot_count"}}},"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_INszidovNHIEXfosP7YWe","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 three local analytical reports on camera coverage data (shot_count, coverage_seconds): record quality audit, exact row deduplication, and daily sum time series — up to 200 rows per call.","exampleAgentPrompt":"Can you audit this camera coverage dataset for data quality issues, remove any exact duplicate rows, and give me a daily sum series for shot_count? Here are my records: row-1, group-a, 2026-10-01, shot_count=10, coverage_seconds=1; row-2, group-b, 2026-10-02, shot_count=20, coverage_seconds=2; row-3, group-a, 2026-10-03, shot_count=15, coverage_seconds=3 — up to 200 rows total.","exampleUseCases":[{"title":"Daily shot count rollup for production team","prompt":"I have a list of up to 150 camera coverage records with shot counts per asset group per day — can you give me a daily sum series for shot_count, flag any bad records, and deduplicate any exact duplicate rows?"},{"title":"Coverage seconds quality check before reporting","prompt":"Before I send this camera coverage report, can you run a record quality audit and exact deduplication on these 80 rows and show me the daily sum of coverage_seconds grouped by date?"},{"title":"Cleaning exported camera log data","prompt":"I just exported camera logs with asset_group, date, shot_count, and coverage_seconds fields — around 200 rows. Can you check the data quality, find and remove any exact duplicate entries, and produce a daily aggregated sum for coverage_seconds?"}],"resultDescription":"Returns three independent reports: (1) a record quality audit flagging null, out-of-range, or malformed values; (2) an exact row deduplication report identifying and removing duplicate records; and (3) a daily sum time series aggregating the selected field (shot_count or coverage_seconds) by date — all computed locally without any external lookups.","failureModes":["More than 200 rows submitted — request exceeds row limit and will be rejected","Missing required fields (row_id, asset_group, date, shot_count, or coverage_seconds) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Numeric values outside allowed range (±1,000,000,000,000) — rejected by schema","Empty rows array — minItems:1 constraint violated","Invalid field selector (not 'shot_count' or 'coverage_seconds') — enum validation error"],"whenToPreferThis":"Choose this endpoint when you have up to 200 camera coverage records (shot_count and/or coverage_seconds) and need all three of these offline analytical reports in a single call: a data quality audit, exact-match deduplication, and a daily aggregated sum series. It is ideal for pre-reporting data cleaning, batch quality checks, and time series rollups on camera production data without requiring any external data source, live lookup, or professional assessment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-17T12:42:56.518Z","isFirstParty":false,"canonicalSlug":"camera-coverage-record-quality-audit-deduplication-and-daily-sum-series-f1fde374"}