{"uid":"cap_0u4_tJUh4YCKRMGVUMP5B","slug":"quest-pacing-duplicate-key-report-numeric-interval-filter-8fa2eafb","name":"Quest Pacing — Duplicate Key Report + Numeric Interval Filter","description":"Quest pacing — Duplicate key report + Numeric interval filter: Duplicate key report + Numeric interval filter for supplied quest pacing records (duration_minutes, objective_count). 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-game-04-059?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","game_area","date","duration_minutes","objective_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"game_area":{"type":"string","default":"","maxLength":80},"objective_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"duration_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","game_area":"group-a","objective_count":1,"duration_minutes":10},{"date":"2026-10-02","row_id":"row-2","game_area":"group-b","objective_count":2,"duration_minutes":20},{"date":"2026-10-03","row_id":"row-3","game_area":"group-a","objective_count":3,"duration_minutes":15},{"date":"2026-10-04","row_id":"row-4","game_area":"group-b","objective_count":4,"duration_minutes":30}],"maxItems":200,"minItems":1},"field":{"enum":["duration_minutes","objective_count"],"type":"string","default":"duration_minutes"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_0kjFrXv4RU-XvnTDWBf4V","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 quest pacing records to identify duplicate row_id keys and filter rows where a numeric field (duration_minutes or objective_count) falls within a specified numeric interval, returning two independent analytical reports.","exampleAgentPrompt":"Check my quest pacing dataset for duplicate row IDs, and also filter the duration_minutes field to show only rows between 10 and 60 — here are the rows: row-1, Forest, 2026-10-01, 15 min, 3 objectives; row-2, Cave, 2026-10-02, 45 min, 5 objectives; row-3, Forest, 2026-10-03, 90 min, 2 objectives; row-1, Desert, 2026-10-04, 20 min, 4 objectives.","exampleUseCases":[{"title":"Duplicate quest ID detection","prompt":"I have a list of quest pacing records and I want to know if any row_id values appear more than once — can you run a duplicate key report? Also filter duration_minutes between 0 and 30. Here are my rows: row-1 Forest 2026-10-01 10min 2obj, row-2 Cave 2026-10-02 25min 3obj, row-1 Desert 2026-10-03 45min 1obj, row-3 Forest 2026-10-04 8min 5obj."},{"title":"Objective count range filtering","prompt":"From my quest pacing data, show me only the quests where objective_count is between 2 and 8, and also flag any duplicate row IDs. Rows: row-1 TutorialZone 2026-11-01 20min 1obj, row-2 BossArena 2026-11-02 60min 5obj, row-3 Dungeon 2026-11-03 15min 9obj, row-4 Village 2026-11-04 30min 3obj."},{"title":"Game area pacing data quality audit","prompt":"I'm auditing quest pacing records across different game areas. Can you run a duplicate key check and filter duration_minutes to the 15–45 range? Here are up to 10 rows: row-1 Zone-A 2026-09-01 15min 4obj, row-2 Zone-B 2026-09-02 50min 2obj, row-2 Zone-C 2026-09-03 20min 6obj, row-3 Zone-A 2026-09-04 35min 3obj."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report listing any row_id values that appear more than once in the submitted dataset, and (2) a numeric interval filter report listing all rows where the selected field (duration_minutes or objective_count) falls within the specified minimum–maximum range. Handles up to 200 rows per call with no external lookups.","failureModes":["Fewer than 1 row submitted — validation error","More than 200 rows submitted — exceeds maxItems limit","Invalid date format (not YYYY-MM-DD) — schema validation failure","Missing required fields (row_id, game_area, date, duration_minutes, objective_count) — rejection","Minimum value greater than maximum value — may produce empty interval filter result","Numeric values outside ±1,000,000,000,000 range — schema validation failure"],"whenToPreferThis":"Choose this endpoint when you need to simultaneously check for duplicate row identifiers and filter records by a numeric range within quest pacing datasets (duration_minutes or objective_count). Ideal for game designers and QA analysts validating quest data integrity offline without external API calls, predictions, or live lookups. Best suited for small-to-medium datasets up to 200 rows where both a uniqueness audit and a numeric subsetting report are needed in a single call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:32:13.796Z","isFirstParty":false,"canonicalSlug":"quest-pacing-duplicate-key-report-numeric-interval-filter-8fa2eafb"}