{"uid":"cap_IE6iTWq-Ia_W3XdOAMrOZ","slug":"company-headcount-observations-record-quality-audit-string-8b70ed10","name":"Company Headcount Observations — Record Quality Audit, String Normalisation & Exact Row Deduplication","description":"Company headcount observations — Record quality audit + String normalisation + Exact row deduplication: Record quality audit + String normalisation + Exact row deduplication for supplied company headcount observations records (headcount, open_roles). 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-12-191?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","company_group","date","headcount","open_roles"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"headcount":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"open_roles":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"company_group":{"type":"string","default":"","maxLength":80}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","headcount":10,"open_roles":1,"company_group":"group-a"},{"date":"2026-10-02","row_id":"row-2","headcount":20,"open_roles":2,"company_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","headcount":15,"open_roles":3,"company_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","headcount":30,"open_roles":4,"company_group":"group-b"}],"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_Lm7pxZ1jhm3LYmdVJm1oF","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":"Audits, normalises, and deduplicates up to 200 company headcount observation records, returning three independent analytical reports using local engines — no external lookups or predictions.","exampleAgentPrompt":"Can you run a quality audit, string normalisation, and exact deduplication check on these company headcount records I have — there are about 50 rows with company_group, date, headcount, and open_roles fields, and I want to get all three reports back at once?","exampleUseCases":[{"title":"Pre-analysis headcount data cleanup","prompt":"I have 120 rows of company headcount observations with company_group, date, headcount, and open_roles columns, and I want to clean them up before I run any analysis — can you audit the record quality, normalise the company name strings, and remove any exact duplicate rows?"},{"title":"HR data pipeline validation step","prompt":"Before we load this batch of headcount data into our warehouse, can you check it for quality issues, normalise the company group labels, and flag any duplicated rows? It's about 80 records with row_id, company_group, date, headcount, and open_roles."},{"title":"Spotting bad data in open roles feed","prompt":"Our open_roles feed has been acting weird and I suspect there are duplicates and inconsistent company name formatting — can you run the record quality audit, string normalisation, and deduplication reports on these 60 headcount observations?"}],"resultDescription":"Three independent reports covering: (1) a record quality audit flagging malformed, missing, or out-of-range values in headcount and open_roles fields; (2) a string normalisation report standardising company_group and other string fields; and (3) an exact row deduplication report identifying and removing fully duplicate rows — all generated locally from the supplied data, with no external lookups.","failureModes":["Submitting more than 200 rows returns an error as the batch limit is exceeded","Missing required fields (row_id, company_group, date, headcount, open_roles) cause validation errors on the input schema","Dates not matching YYYY-MM-DD pattern are rejected by schema validation","row_id values exceeding 80 characters are rejected","Numeric values for headcount or open_roles outside the allowed range cause schema rejection","Payment of 0.01 USDC must be included; missing payment results in 402 response"],"whenToPreferThis":"Choose this endpoint when you need three combined data-quality operations — record auditing, string normalisation, and exact deduplication — on company headcount observation data in a single API call and want purely local, deterministic analysis without external lookups, predictions, or professional assessments. It is especially useful for data pipeline validation steps before loading headcount time series into a warehouse or analytics system.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:53.548Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-record-quality-audit-string-8b70ed10"}