{"uid":"cap_OtZSeY90sap4WXxBbUEZQ","slug":"quest-pacing-exact-row-deduplication-numeric-interval-filter-c74bb2e5","name":"Quest Pacing — Exact Row Deduplication + Numeric Interval Filter","description":"Quest pacing — Exact row deduplication + Numeric interval filter: Exact row deduplication + 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-043?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_zTBlM-F-kSnygHCbc_1Pc","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":"Deduplicates quest pacing records and filters rows by a numeric interval on duration_minutes or objective_count, returning two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my quest pacing records and filter them to only keep rows where duration_minutes is between 5 and 60? Here are my rows: row-1 (group-a, 2026-10-01, 10 min, 1 objective), row-2 (group-b, 2026-10-02, 20 min, 2 objectives), row-3 (group-a, 2026-10-03, 70 min, 3 objectives) — filter on duration_minutes and give me the two analytical reports.","exampleUseCases":[{"title":"Filter quests by time budget","prompt":"I have a list of up to 150 quest pacing records with game areas, dates, and durations. Can you deduplicate them and then filter to only rows where duration_minutes is between 10 and 45? Filter on the duration_minutes field and give me both analytical reports."},{"title":"Remove duplicate objectives data","prompt":"My quest dataset has some duplicate rows — can you clean it up by deduplicating and also filter out any rows where objective_count falls outside 1 to 20? Use the objective_count field for filtering and return both reports."},{"title":"Audit short and long quest outliers","prompt":"Can you take my quest pacing data — about 80 rows with game_area, date, duration_minutes and objective_count — deduplicate it and filter to only keep rows where duration_minutes is between 0 and 15 so I can audit the shortest quests? Provide the two analytical reports."}],"resultDescription":"Two independent analytical reports covering the deduplicated and interval-filtered quest pacing dataset. Reports reflect exact row deduplication (removing fully identical rows) and a numeric interval filter on the chosen field (duration_minutes or objective_count) bounded by the supplied minimum and maximum values. Processing is local with no external lookups; up to 200 input rows supported.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, game_area, date, duration_minutes, objective_count) cause row validation errors","Invalid date format (not YYYY-MM-DD) triggers pattern validation failure","Minimum value greater than maximum value may produce empty filtered result set","Null numeric values in filter field may exclude rows from interval filter","Payment of 0.01 USDC not completed — request blocked by x402 paywall"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a numeric range filter applied to quest pacing data (duration_minutes or objective_count) in a single call that returns two analytical reports. It is best suited for game analytics pipelines where data quality (deduplication) and scoped analysis (interval filtering) are needed together on small-to-medium datasets (up to 200 rows) without requiring live data lookups or external predictions.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:32:27.192Z","isFirstParty":false,"canonicalSlug":"quest-pacing-exact-row-deduplication-numeric-interval-filter-c74bb2e5"}