{"uid":"cap_FkJu_X7CgXRLFka-N46x6","slug":"company-record-completeness-exact-row-deduplication-iqr-outlier-flags-19ba8c38","name":"Company Record Completeness — Exact Row Deduplication + IQR Outlier Flags","description":"Company record completeness — Exact row deduplication + IQR outlier flags: Exact row deduplication + IQR outlier flags for supplied company record completeness records (populated_fields, required_fields). 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-01-049?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","populated_fields","required_fields"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"company_group":{"type":"string","default":"","maxLength":80},"required_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"populated_fields":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","company_group":"group-a","required_fields":1,"populated_fields":10},{"date":"2026-10-02","row_id":"row-2","company_group":"group-b","required_fields":2,"populated_fields":20},{"date":"2026-10-03","row_id":"row-3","company_group":"group-a","required_fields":3,"populated_fields":15},{"date":"2026-10-04","row_id":"row-4","company_group":"group-b","required_fields":4,"populated_fields":30}],"maxItems":200,"minItems":1},"field":{"enum":["populated_fields","required_fields"],"type":"string","default":"populated_fields"}}},"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_O82V4kUD6dXnGZp1XZNnF","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 exact rows and flags IQR outliers in company record completeness data (populated_fields, required_fields) for up to 200 rows, producing 2 independent analytical reports.","exampleAgentPrompt":"Can you deduplicate and flag IQR outliers in my company record completeness data? I have rows with populated_fields and required_fields for groups like group-a and group-b across dates in October 2026 — analyze the populated_fields column and give me the 2-report output.","exampleUseCases":[{"title":"CRM data quality audit","prompt":"I've got up to 150 company records from our CRM with populated_fields and required_fields counts per company_group — can you deduplicate exact duplicates and flag any IQR outliers in the populated_fields column so I know which records look anomalous?"},{"title":"Monthly completeness anomaly detection","prompt":"Run an outlier check on our monthly company completeness snapshots — I have rows with row_id, company_group, date, populated_fields, and required_fields. Deduplicate any exact duplicate rows and flag IQR outliers in required_fields for me."},{"title":"Multi-group completeness comparison","prompt":"We track record completeness across 5 company groups with about 80 rows total — can you remove exact duplicate rows and identify which groups have IQR outliers in populated_fields? I want both deduplication and outlier reports."}],"resultDescription":"Returns 2 independent analytical reports: one covering exact row deduplication (identifying and removing duplicate rows from the supplied dataset) and one covering IQR-based outlier flagging for the chosen field (populated_fields or required_fields), applied across the supplied company record completeness rows. No external lookups or predictions are made — all analysis is performed on the supplied data only.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, company_group, date, populated_fields, required_fields) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Non-numeric or out-of-range values for populated_fields or required_fields fail schema validation","Empty rows array (minItems:1 not met) causes rejection","Invalid field enum value (not 'populated_fields' or 'required_fields') causes error"],"whenToPreferThis":"Choose this endpoint when you need a low-cost, local statistical audit of company record completeness data — specifically exact row deduplication combined with IQR-based outlier detection — without any external data lookups, predictions, or ML inference. Ideal for data quality pipelines, ETL validation steps, or periodic completeness audits where you have up to 200 rows of company group completeness metrics and want two structured reports for $0.01 USDC.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T00:56:14.800Z","isFirstParty":false,"canonicalSlug":"company-record-completeness-exact-row-deduplication-iqr-outlier-flags-19ba8c38"}