{"uid":"cap_IqYOzPR46-w9mk5bHsubx","slug":"survey-participation-duplicate-key-report-numeric-interval-filter-b22ea051","name":"Survey Participation Duplicate Key Report + Numeric Interval Filter","description":"Survey participation — Duplicate key report + Numeric interval filter: Duplicate key report + Numeric interval filter for supplied survey participation records (respondents, invitations). 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-education-10-059?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","respondents","invitations"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"invitations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"respondents":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"course_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","invitations":1,"respondents":10,"course_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","invitations":2,"respondents":20,"course_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","invitations":3,"respondents":15,"course_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","invitations":4,"respondents":30,"course_group":"group-b"}],"maxItems":200,"minItems":1},"field":{"enum":["respondents","invitations"],"type":"string","default":"respondents"},"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_Psq94WzUC3mvRohih7G_A","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 two local analytical reports on supplied survey participation data: identifies duplicate row keys and filters rows where a chosen numeric field falls within a specified range.","exampleAgentPrompt":"Check my survey participation data for duplicate row IDs and also filter it to only show rows where respondents is between 5 and 50 — here are up to 200 rows with fields row_id, course_group, date, respondents, and invitations.","exampleUseCases":[{"title":"Education survey data quality audit","prompt":"I have a dataset of 150 survey participation records from our online courses — each row has a row_id, course_group, date, respondents, and invitations. Can you run a duplicate key check and also filter to only rows where respondents falls between 20 and 200?"},{"title":"Invitation range filter for campaign analysis","prompt":"Here's my survey invitation data across several course groups. Flag any duplicate row IDs for me, and also pull out all rows where invitations is between 0 and 50 so I can see which sessions had low invite counts."},{"title":"Respondent threshold filtering for reporting","prompt":"I need two quick reports on these survey participation records: first, show me any duplicate row_ids, and second, filter by the respondents field to only include rows between 100 and 500. There are about 80 rows total with course_group and date fields included."}],"resultDescription":"Returns two independent reports: (1) a duplicate key report listing any rows sharing the same row_id, and (2) a numeric interval filter report listing all rows where the selected field (respondents or invitations) falls within the specified minimum and maximum range. Up to 200 input rows are processed using local analytical engines with no external lookups.","failureModes":["Exceeding 200 rows returns an error or truncated result","Missing required fields (row_id, course_group, date, respondents, invitations) causes validation failure","Invalid date format (not YYYY-MM-DD) triggers a pattern mismatch error","Numeric values outside allowed bounds (-1,000,000,000,000 to 1,000,000,000,000) are rejected","Providing an invalid field enum value (not 'respondents' or 'invitations') returns an error","Empty rows array (minItems:1 violated) causes request rejection"],"whenToPreferThis":"Choose this endpoint when you have survey participation data (respondents and invitations) with course group and date dimensions and need two simultaneous data quality operations: duplicate key detection and numeric range filtering. Ideal for education analytics workflows needing lightweight, local computation without external data dependencies. Best when input is under 200 rows and you need both reports in a single $0.01 call rather than separate services.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:34:20.993Z","isFirstParty":false,"canonicalSlug":"survey-participation-duplicate-key-report-numeric-interval-filter-b22ea051"}