{"uid":"cap_m3RQWA3PFTTkKdLk0cSpR","slug":"company-headcount-observations-duplicate-key-report-adjacent-row-bc43f130","name":"Company Headcount Observations — Duplicate Key Report + Adjacent Row Changes","description":"Company headcount observations — Duplicate key report + Adjacent row changes: Duplicate key report + Adjacent row changes for supplied company headcount observations records (headcount, open_roles). 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-12-062?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},"field":{"enum":["headcount","open_roles"],"type":"string","default":"headcount"}}},"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_Z_K8rAmmdWY1waC6RwSYU","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 headcount observation rows to produce a duplicate key report and adjacent row change calculations for headcount or open_roles fields.","exampleAgentPrompt":"Can you run a duplicate key check and adjacent row change report on this headcount dataset — I have up to 50 rows with company_group, date, headcount, and open_roles — and I want the analysis on the headcount field?","exampleUseCases":[{"title":"HR data quality audit for headcount records","prompt":"I've got a batch of company headcount observation records with row IDs, company groups, dates, headcount counts, and open roles — can you check them for any duplicate keys and also show me how headcount changes between consecutive rows?"},{"title":"Detecting duplicate entries in workforce snapshots","prompt":"We imported headcount snapshots for several company groups and I'm worried there are duplicate date+company combinations in there — can you run a duplicate key report on these 120 rows and also show adjacent changes in open_roles?"},{"title":"Sequential change analysis for hiring pipeline data","prompt":"Here are our weekly headcount and open_roles observations across a few groups — can you flag any duplicate row IDs and calculate the row-to-row changes in headcount so I can spot anomalies?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying rows with repeated key combinations within the supplied dataset, and (2) an adjacent row change report showing the delta between consecutive rows for the selected field (headcount or open_roles), covering up to 200 input rows.","failureModes":["More than 200 rows submitted — request will be rejected or truncated","Missing required fields (row_id, company_group, date, headcount, or open_roles) cause validation errors","Invalid date format (not YYYY-MM-DD) causes schema rejection","Invalid field enum value (not 'headcount' or 'open_roles') causes error","Empty rows array causes minimum item validation failure"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and adjacent row change analysis on company headcount or open_roles data in a single API call, without needing live lookups, predictions, or external data enrichment. It is ideal for offline data quality checks on batches of up to 200 workforce observation records.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:31.094Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-duplicate-key-report-adjacent-row-bc43f130"}