{"uid":"cap_ESYaqMP9aV0OWP5U9CCqE","slug":"training-compliance-exact-row-deduplication-and-adjacent-row-changes-cfa97bb3","name":"Training Compliance Exact Row Deduplication and Adjacent Row Changes","description":"Training compliance — Exact row deduplication + Adjacent row changes: Exact row deduplication + Adjacent row changes for supplied training compliance records (completed_courses, assigned_courses). 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-operations-10-046?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","team_group","date","completed_courses","assigned_courses"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"team_group":{"type":"string","default":"","maxLength":80},"assigned_courses":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_courses":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","team_group":"group-a","assigned_courses":1,"completed_courses":10},{"date":"2026-10-02","row_id":"row-2","team_group":"group-b","assigned_courses":2,"completed_courses":20},{"date":"2026-10-03","row_id":"row-3","team_group":"group-a","assigned_courses":3,"completed_courses":15},{"date":"2026-10-04","row_id":"row-4","team_group":"group-b","assigned_courses":4,"completed_courses":30}],"maxItems":200,"minItems":1},"field":{"enum":["completed_courses","assigned_courses"],"type":"string","default":"completed_courses"}}},"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_eG-nbhhUNnvxs1EoYvTxP","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 up to 200 training compliance records to identify exact duplicate rows and detect adjacent row changes across completed_courses and assigned_courses fields.","exampleAgentPrompt":"Can you run a deduplication check and adjacent row change analysis on our training compliance data? I have about 50 rows with team_group, date, completed_courses, and assigned_courses — I want to analyze the completed_courses field specifically.","exampleUseCases":[{"title":"Audit HR training records for duplicates","prompt":"We have 120 training compliance records from different team groups across Q3 and I suspect there are duplicate entries mixed in. Can you run an exact row deduplication plus adjacent row changes analysis on the completed_courses field so I can identify and clean up the duplicates?"},{"title":"Track assigned course count changes by team","prompt":"I need to see where our assigned_courses numbers changed between consecutive rows for our compliance dataset — it covers groups like group-a and group-b across October. Can you run the deduplication and adjacent change reports on the assigned_courses field for these 80 rows?"},{"title":"Validate compliance data before monthly report","prompt":"Before I finalize our monthly training report, I want to make sure our compliance data is clean — can you check these 60 rows for any exact duplicates and flag anywhere the completed_courses value shifted between adjacent rows?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying fully identical rows in the submitted dataset, and (2) an adjacent row changes report highlighting where the selected field (completed_courses or assigned_courses) changed value between consecutive rows. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Exceeds 200 row limit — request rejected","Missing required fields (row_id, team_group, date, completed_courses, assigned_courses) — validation error","Invalid date format not matching YYYY-MM-DD pattern — schema rejection","Invalid field enum value (not completed_courses or assigned_courses) — rejected","Empty rows array — minimum 1 item required","Numeric values outside allowed range — schema rejection"],"whenToPreferThis":"Choose this endpoint when you need fast, local analytical deduplication and change-detection on small-to-medium training compliance datasets (up to 200 rows) without any external data lookup or prediction. Ideal for data quality auditing workflows before reporting, or when you need two distinct compliance data reports (deduplication + adjacent changes) in a single low-cost call. Not suited for large datasets exceeding 200 rows, real-time monitoring, or predictive analytics.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T12:43:39.998Z","isFirstParty":false,"canonicalSlug":"training-compliance-exact-row-deduplication-and-adjacent-row-changes-cfa97bb3"}