{"uid":"cap_2LAYcSO1JGS101muGwe7N","slug":"business-event-participation-data-quality-audit-deduplication-4398f4ba","name":"Business Event Participation Data Quality Audit — Deduplication & Category Frequencies","description":"Business event participation — Record quality audit + Exact row deduplication + Category frequencies: Record quality audit + Exact row deduplication + Category frequencies for supplied business event participation records (attendee_count, company_count). Up to 200 rows; 3 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 3 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-company-19-212?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_QUzdUnNLBT3YGi0vbwyoP","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 three analytical reports on business event participation data: a record quality audit, exact row deduplication, and category frequency analysis, all in one call for up to 200 rows.","exampleAgentPrompt":"Can you audit my business event participation records for data quality issues, remove exact duplicate rows, and give me a frequency count of each company group? I have up to 50 rows with fields like row_id, company_group, date, attendee_count, and company_count.","exampleUseCases":[{"title":"Pre-pipeline event data validation","prompt":"Before I load my event participation data into our analytics pipeline, can you audit it for quality issues, deduplicate any exact duplicate rows, and show me how often each company group appears? I have about 120 rows with attendee counts and company counts per date."},{"title":"Conference attendance deduplication","prompt":"I exported our conference attendance records and suspect there are duplicates — can you run an exact deduplication and also tell me which company groups show up most frequently? The dataset has around 80 rows with attendee_count and company_count fields."},{"title":"Monthly event reporting cleanup","prompt":"I need to clean up last month's event participation records before sending them to leadership — can you check for data quality problems, remove any exact duplicate rows, and give me a category frequency breakdown by company group across about 60 rows?"}],"resultDescription":"Three independent reports in one response: (1) a record quality audit flagging nulls, out-of-range values, and malformed dates across all rows; (2) an exact row deduplication report identifying and removing fully duplicate records; and (3) a category frequency table showing how often each company_group value appears in the supplied dataset. All analysis is performed locally on the submitted data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Rows missing required fields (row_id, company_group, date, attendee_count, company_count) are rejected","Invalid date format (not YYYY-MM-DD) causes row-level or request-level failure","Numeric values outside the allowed range trigger schema validation errors","Empty rows array returns an error","Payment not included or insufficient USDC balance results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need three complementary data quality operations — quality audit, deduplication, and category frequency — on business event participation data in a single low-cost call. Ideal for preprocessing event datasets of up to 200 rows before downstream analytics or reporting, especially when you need all three reports at once rather than calling separate services. Not suited for live event lookups, predictions, or datasets exceeding 200 rows.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-20T18:56:40.324Z","isFirstParty":false,"canonicalSlug":"business-event-participation-data-quality-audit-deduplication-4398f4ba"}