{"uid":"cap_iO6jT5UA3T27naGu7oehu","slug":"event-attendance-exact-row-deduplication-38696b45","name":"Event Attendance Exact Row Deduplication","description":"Event attendance - Exact row deduplication: Exact row deduplication for Event attendance. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded exact row deduplication deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-event-attendance-deduplicate?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","event_type","date","registrations","attendees"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"attendees":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"event_type":{"type":"string","default":"","maxLength":80},"registrations":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","attendees":1,"event_type":"group-a","registrations":10},{"date":"2026-10-02","row_id":"row-2","attendees":2,"event_type":"group-b","registrations":20},{"date":"2026-10-03","row_id":"row-3","attendees":3,"event_type":"group-a","registrations":15},{"date":"2026-10-04","row_id":"row-4","attendees":4,"event_type":"group-b","registrations":30}],"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_a664-MlaVrintMpZPopgi","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":"Removes exact duplicate rows from event attendance datasets containing event_type, date, registrations, and attendees fields.","exampleAgentPrompt":"Can you deduplicate my event attendance records? I have 4 rows: row-1 is a 'conference' event on 2025-03-01 with 50 registrations and 42 attendees, row-2 is 'workshop' on 2025-03-02 with 30 registrations and 28 attendees, row-3 is the same 'conference' on 2025-03-01 with 50 registrations and 42 attendees (exact duplicate of row-1), and row-4 is 'webinar' on 2025-03-03 with 100 registrations and 89 attendees — please return only the unique rows.","exampleUseCases":[{"title":"Clean event tracker before reporting","prompt":"I've got 12 rows of event attendance data that I think have some duplicates — can you run exact row deduplication on them so I only keep unique entries before I build my monthly report? The events include 'conference', 'webinar', and 'workshop' types across March 2025."},{"title":"Merge duplicate registrations from two systems","prompt":"We exported attendance records from two systems and combined them into one list of 80 rows, but there are definitely exact duplicates in there. Can you deduplicate these event attendance records by row — each row has a row_id, event_type, date, registrations count, and attendees count?"},{"title":"Validate data pipeline output integrity","prompt":"Our data pipeline for event attendance is supposed to output unique rows only, but I suspect it's generating duplicates. Can you run exact deduplication on this batch of 150 event attendance rows — types like 'summit' and 'expo' — and tell me how many exact duplicate rows were found and removed?"}],"resultDescription":"Returns the deduplicated set of event attendance rows with exact duplicate rows removed, preserving unique combinations of event_type, date, registrations, and attendees. May include a count of duplicates removed and the cleaned list of records.","failureModes":["Rows missing required fields (row_id, event_type, date, registrations, attendees) will cause validation errors","More than 200 rows submitted will exceed the maxItems limit and be rejected","Invalid date format (not YYYY-MM-DD) will fail pattern validation","Payment not provided or insufficient USDC balance will block the request","Empty array input (minItems: 1 not met) will return an error"],"whenToPreferThis":"Choose this endpoint when you need fast, local exact row deduplication for event attendance data specifically structured with event_type, date, registrations, and attendees fields — up to 200 rows per call. It is ideal when you want a simple, deterministic duplicate-removal operation with no external enrichment, at very low cost ($0.01 USDC). Prefer alternatives if you need fuzzy/approximate matching, enrichment, or datasets larger than 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T19:09:12.809Z","isFirstParty":false,"canonicalSlug":"event-attendance-exact-row-deduplication-38696b45"}