{"uid":"cap_xaWojMjcXsbfDcswVeK-M","slug":"training-assessments-exact-row-deduplication-and-duplicate-key-report-8239496d","name":"Training Assessments Exact Row Deduplication and Duplicate Key Report","description":"Training assessments — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied training assessments records (pre_score, post_score). 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-11-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","course_group","date","pre_score","post_score"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"pre_score":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"post_score":{"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","pre_score":10,"post_score":1,"course_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","pre_score":20,"post_score":2,"course_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","pre_score":15,"post_score":3,"course_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","pre_score":30,"post_score":4,"course_group":"group-b"}],"maxItems":200,"minItems":1}}},"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_3xL-mevwkpSUjftAa_NIc","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 exact rows and generates a duplicate key report for training assessment records containing pre-score and post-score fields, processing up to 200 rows.","exampleAgentPrompt":"I have up to 200 training assessment rows with row IDs, course groups, dates, pre-scores, and post-scores — can you run exact row deduplication and generate a duplicate key report on them so I can see which records are repeated?","exampleUseCases":[{"title":"Clean duplicate LMS export records","prompt":"I exported our LMS training assessment data and I think there are duplicate entries — here are the rows with row_id, course_group, date, pre_score, and post_score. Can you deduplicate the exact rows and give me a duplicate key report so I know which ones are repeated?"},{"title":"Audit pre/post score dataset integrity","prompt":"Before I analyze score improvements, I need to check this batch of training assessment records for duplicate rows and duplicate keys. The dataset has about 150 rows with pre_score and post_score values across several course groups — can you run both reports?"},{"title":"Validate merged assessment file quality","prompt":"We merged training assessment files from two sources and I suspect there are overlapping records. Can you take these rows — each has a row_id, course_group, date, pre_score, and post_score — and produce an exact row deduplication report plus a duplicate key report?"}],"resultDescription":"Two analytical reports: (1) an exact row deduplication report identifying which rows are perfect duplicates across all fields, and (2) a duplicate key report flagging rows that share the same key fields. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns an error — batch must be split","Missing required fields (row_id, course_group, date, pre_score, post_score) cause validation failure","Invalid date format (non-YYYY-MM-DD) causes schema rejection","Empty rows array rejected — at least 1 row required","Scores outside ±1,000,000,000,000 range cause validation errors"],"whenToPreferThis":"Choose this endpoint when you need both exact row deduplication and a duplicate key report on training assessment data (pre_score, post_score) in a single low-cost call. It is purpose-built for education and training assessment records with up to 200 rows and requires no external data sources, making it ideal for offline data quality checks on course group assessment exports.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T18:51:29.973Z","isFirstParty":false,"canonicalSlug":"training-assessments-exact-row-deduplication-and-duplicate-key-report-8239496d"}