{"uid":"cap_gbWzOG1ZjxV0pjdVYcP5s","slug":"assignment-turnaround-duplicate-key-report-numeric-interval-filter-636b042d","name":"Assignment Turnaround — Duplicate Key Report + Numeric Interval Filter","description":"Assignment turnaround — Duplicate key report + Numeric interval filter: Duplicate key report + Numeric interval filter for supplied assignment turnaround records (submission_count, feedback_hours). 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-05-059?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","submission_count","feedback_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"course_group":{"type":"string","default":"","maxLength":80},"feedback_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"submission_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","course_group":"group-a","feedback_hours":1,"submission_count":10},{"date":"2026-10-02","row_id":"row-2","course_group":"group-b","feedback_hours":2,"submission_count":20},{"date":"2026-10-03","row_id":"row-3","course_group":"group-a","feedback_hours":3,"submission_count":15},{"date":"2026-10-04","row_id":"row-4","course_group":"group-b","feedback_hours":4,"submission_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["submission_count","feedback_hours"],"type":"string","default":"submission_count"},"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_Y_snBXPSNuT3jqbrCuL11","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 assignment turnaround data: a duplicate key detection report and a numeric interval filter, over up to 200 rows of submission/feedback records.","exampleAgentPrompt":"Check my assignment turnaround records for duplicate row IDs and also filter to only show rows where submission_count is between 5 and 40 — here are 4 rows: row-1 group-a 2026-10-01 feedback_hours=1 submission_count=10, row-2 group-b 2026-10-02 feedback_hours=2 submission_count=20, row-3 group-a 2026-10-03 feedback_hours=3 submission_count=15, row-4 group-b 2026-10-04 feedback_hours=4 submission_count=30.","exampleUseCases":[{"title":"Detecting duplicate IDs in course records","prompt":"I have 50 rows of assignment turnaround data with row IDs and course groups — can you run a duplicate key report and also filter submission_count between 0 and 25? Here's the data: row-1 group-a 2026-10-01 submission_count=10 feedback_hours=1, row-2 group-b 2026-10-02 submission_count=20 feedback_hours=2, row-1 group-a 2026-10-03 submission_count=15 feedback_hours=3."},{"title":"Filtering feedback hours within acceptable range","prompt":"From my assignment dataset, give me a duplicate key report and filter on feedback_hours between 2 and 8 — the rows are: row-1 group-a 2026-10-01 submission_count=10 feedback_hours=1, row-2 group-b 2026-10-02 submission_count=20 feedback_hours=5, row-3 group-a 2026-10-03 submission_count=15 feedback_hours=9."},{"title":"Auditing assignment data before semester report","prompt":"Before I finalize my semester report, can you check these assignment turnaround records for any duplicate row IDs and show me which rows have submission_count between 10 and 30? Records: row-1 group-a 2026-10-01 submission_count=10 feedback_hours=2, row-2 group-b 2026-10-02 submission_count=35 feedback_hours=4, row-3 group-c 2026-10-03 submission_count=20 feedback_hours=3."}],"resultDescription":"Returns two reports: (1) a duplicate key report identifying any row_id values that appear more than once in the supplied data, and (2) a numeric interval filter listing which rows fall within the specified minimum and maximum range for the chosen field (submission_count or feedback_hours). Both reports are computed locally on the supplied data with no external lookup.","failureModes":["Empty or missing rows array returns an error","More than 200 rows submitted exceeds the limit and is rejected","Invalid date format (not YYYY-MM-DD) causes schema validation failure","field enum value not matching 'submission_count' or 'feedback_hours' causes rejection","minimum greater than maximum may return an empty interval filter result","Null numeric values for the filtered field may be excluded or flagged","Missing required row fields (row_id, course_group, date) causes validation errors"],"whenToPreferThis":"Choose this endpoint when you need both duplicate row ID detection and numeric range filtering on education/assignment turnaround data (submission counts and feedback hours) in a single low-cost call. It is ideal for data quality checks before reporting or aggregation, when you have up to 200 rows and want local analytical results without any external API calls, predictions, or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:31:36.517Z","isFirstParty":false,"canonicalSlug":"assignment-turnaround-duplicate-key-report-numeric-interval-filter-636b042d"}