{"uid":"cap_5QqgbLer8Q-pJ5R8FljWj","slug":"business-event-participation-exact-row-deduplication-duplicate-key-738d6d66","name":"Business Event Participation — Exact Row Deduplication + Duplicate Key Report","description":"Business event participation — Exact row deduplication + Duplicate key report: Exact row deduplication + Duplicate key report for supplied business event participation records (attendee_count, company_count). 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-company-19-038?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","attendee_count","company_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80},"attendee_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_count":1,"company_group":"group-a","attendee_count":10},{"date":"2026-10-02","row_id":"row-2","company_count":2,"company_group":"group-b","attendee_count":20},{"date":"2026-10-03","row_id":"row-3","company_count":3,"company_group":"group-a","attendee_count":15},{"date":"2026-10-04","row_id":"row-4","company_count":4,"company_group":"group-b","attendee_count":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_C3i1na7ZZBRNNX3vjJY9T","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 business event participation records and generates a duplicate key report for up to 200 rows of attendee and company count data.","exampleAgentPrompt":"I have a list of up to 200 business event participation records with attendee counts and company counts per group and date — can you run exact row deduplication and generate a duplicate key report on them?","exampleUseCases":[{"title":"Event attendance data cleanup","prompt":"We collected event participation data across multiple company groups and dates but suspect there are duplicate rows — can you deduplicate these records and show me a report of any duplicate keys? Here are the rows with row_id, company_group, date, attendee_count, and company_count."},{"title":"Conference registrar deduplication audit","prompt":"I'm preparing a summary of which companies attended our quarterly conferences and I think some entries were submitted twice. Please run exact row deduplication and give me a duplicate key report on this batch of up to 150 participation records."},{"title":"Event analytics data hygiene check","prompt":"Before I aggregate our business event participation numbers, I need to make sure there are no duplicate rows in my dataset. Can you deduplicate these event records by attendee_count and company_count and give me a report identifying any duplicate keys?"}],"resultDescription":"Returns two independent analytical reports: (1) an exact row deduplication report identifying and removing fully identical rows from the input, and (2) a duplicate key report listing which key combinations appear more than once across the supplied business event participation records (up to 200 rows).","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, company_group, date, attendee_count, company_count) — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","Empty rows array — minimum 1 item required","row_id exceeds 80 character limit — validation error","Payment not completed or insufficient USDC balance — 402 error"],"whenToPreferThis":"Choose this endpoint when you have business event participation data (with attendee and company counts per group and date) and need both exact row deduplication and a duplicate key report in a single call. It is ideal for pre-aggregation data hygiene, auditing event registrations for accidental duplicate submissions, or cleaning exported event datasets before analysis. It handles up to 200 rows per call and requires no external data sources or live lookups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T18:57:19.145Z","isFirstParty":false,"canonicalSlug":"business-event-participation-exact-row-deduplication-duplicate-key-738d6d66"}