{"uid":"cap_uB9h1BoJN9XD_WN8gcRo8","slug":"third-party-reviews-exact-row-deduplication-category-frequencies-6b6f2f6b","name":"Third Party Reviews — Exact Row Deduplication + Category Frequencies","description":"Third party reviews — Exact row deduplication + Category frequencies: Exact row deduplication + Category frequencies for supplied third party reviews records (vendors_reviewed, outstanding_actions). 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-security-24-041?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","control_group","date","vendors_reviewed","outstanding_actions"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"control_group":{"type":"string","default":"","maxLength":80},"vendors_reviewed":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"outstanding_actions":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","control_group":"group-a","vendors_reviewed":10,"outstanding_actions":1},{"date":"2026-10-02","row_id":"row-2","control_group":"group-b","vendors_reviewed":20,"outstanding_actions":2},{"date":"2026-10-03","row_id":"row-3","control_group":"group-a","vendors_reviewed":15,"outstanding_actions":3},{"date":"2026-10-04","row_id":"row-4","control_group":"group-b","vendors_reviewed":30,"outstanding_actions":4}],"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_iewYb_3ftW-etrvdbuIJ3","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 rows and computes category frequencies for third-party review records (vendors_reviewed, outstanding_actions) — two analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you deduplicate my third-party vendor review records and give me a frequency breakdown by control group? I have a list of up to 50 rows, each with a date, row_id, control_group, vendors_reviewed count, and outstanding_actions count.","exampleUseCases":[{"title":"Vendor Review Audit Deduplication","prompt":"I've got a CSV of third-party vendor review entries — about 80 rows with dates, control groups, and counts of vendors reviewed and outstanding actions. Can you strip out any exact duplicate rows and tell me how often each control group shows up?"},{"title":"Outstanding Actions Frequency Breakdown","prompt":"Run a category frequency report on my vendor review dataset — I need to see how outstanding_actions values are distributed across control groups. Here are 120 rows with row_id, date, control_group, vendors_reviewed, and outstanding_actions fields."},{"title":"Pre-Audit Data Cleaning for Review Records","prompt":"Before I submit our quarterly vendor review report, can you deduplicate these 60 review records and give me a frequency count by control group so I can spot any anomalies? Each row has a date, row_id, control_group, vendors_reviewed, and outstanding_actions."}],"resultDescription":"Two reports: (1) the input rows with exact duplicates removed, and (2) a frequency table showing how often each category value (control_group) appears across the deduplicated dataset, including counts for vendors_reviewed and outstanding_actions groupings.","failureModes":["Empty rows array returns an error (minItems: 1 required)","More than 200 rows submitted — exceeds maxItems limit and will be rejected","Invalid date format (not YYYY-MM-DD) causes schema validation failure","Missing required fields (row_id, control_group, date, vendors_reviewed, outstanding_actions) causes rejection","Numeric values outside ±1,000,000,000,000 range rejected","Payment of 0.01 USDC not included or rejected causes 402 response"],"whenToPreferThis":"Choose this endpoint when you have up to 200 third-party review records and need both exact duplicate removal and categorical frequency analysis in a single low-cost call ($0.01 USDC). It is ideal for pre-audit data cleaning, vendor review compliance reporting, or any workflow where review data arrives with potential duplicate entries and you want a quick breakdown by control group without setting up local data pipelines.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:34:04.075Z","isFirstParty":false,"canonicalSlug":"third-party-reviews-exact-row-deduplication-category-frequencies-6b6f2f6b"}