{"uid":"cap_z-8xK-bizOJsQtEYV4TUQ","slug":"company-record-completeness-string-normalisation-iqr-outlier-flags-d032290b","name":"Company Record Completeness — String Normalisation + IQR Outlier Flags","description":"Company record completeness — String normalisation + IQR outlier flags: String normalisation + 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-032?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_KTqlG3ajW-HOg_tz-7wdw","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":"Analyzes up to 200 company record completeness rows, producing string normalization and IQR-based outlier flag reports for populated_fields and required_fields metrics.","exampleAgentPrompt":"Can you run the string normalization and IQR outlier analysis on my company record completeness data — I have about 50 rows from group-a and group-b covering October 2026, each with populated_fields and required_fields counts, and I want to check the populated_fields column for outliers?","exampleUseCases":[{"title":"CRM data quality audit for sales team","prompt":"I've got 120 company records from our CRM export — each has a company group, a date, and counts of how many fields are populated versus required. Can you normalize the strings and flag any IQR outliers in the populated_fields column so I know which records look suspicious?"},{"title":"Monthly completeness anomaly detection","prompt":"We track record completeness for our two company groups every day in October. Can you run the IQR outlier check on the required_fields values across all 90 rows so I can see which days had abnormal completeness counts?"},{"title":"Pre-pipeline data hygiene check","prompt":"Before I load this company completeness dataset into our pipeline, can you normalize the string fields and flag any outliers using IQR for the populated_fields metric? I have around 180 rows split across three company groups."}],"resultDescription":"Two independent analytical reports per call: (1) a string normalization report cleaning and standardizing text fields in the supplied rows, and (2) an IQR outlier flag report identifying which rows have statistically anomalous values in the selected numeric field (populated_fields or required_fields), based purely on the supplied data with no external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, company_group, date, populated_fields, required_fields) causes request rejection","Invalid date format (not YYYY-MM-DD) fails schema validation","Numeric values outside allowed range (-1T to 1T) are rejected","Empty rows array returns an error","Supplying an invalid field enum value (not 'populated_fields' or 'required_fields') fails validation"],"whenToPreferThis":"Choose this endpoint when you need fast, local statistical analysis (IQR outlier detection + string normalization) on batches of up to 200 company record completeness rows without requiring any external data lookups, predictions, or live enrichment. Ideal for pre-pipeline data hygiene, CRM quality audits, and anomaly detection on completeness metrics where cost-efficiency ($0.01 for two reports) and offline analytical processing are priorities.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:05.990Z","isFirstParty":false,"canonicalSlug":"company-record-completeness-string-normalisation-iqr-outlier-flags-d032290b"}