{"uid":"cap_K7KB7XoEms-m-BzhsAgI0","slug":"company-headcount-observations-duplicate-key-report-keyed-dataset-f8592966","name":"Company Headcount Observations — Duplicate Key Report + Keyed Dataset Comparison","description":"Company headcount observations — Duplicate key report + Keyed dataset comparison: Duplicate key report + Keyed dataset comparison 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-069?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},"other":{"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":21,"open_roles":2,"company_group":"group-b"},{"date":"2026-10-03","row_id":"row-3","headcount":17,"open_roles":3,"company_group":"group-a"},{"date":"2026-10-04","row_id":"row-4","headcount":33,"open_roles":4,"company_group":"group-b"}],"maxItems":200,"minItems":0}}},"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_fDV3x0M88Vsz_hQghU-Zf","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 records to produce a duplicate key report and a keyed comparison between two supplied datasets, with no live lookups or external data.","exampleAgentPrompt":"Can you run a duplicate key check and side-by-side comparison on these two sets of company headcount records — the first set has rows for group-a and group-b from October 2026, and the second set has slightly different headcount and open_roles numbers for the same row IDs? I want to see any duplicate keys and where the two datasets diverge.","exampleUseCases":[{"title":"Detecting duplicate keys before a data merge","prompt":"I'm about to merge two headcount exports from our HR system and I need to know if there are any duplicate row IDs before I combine them — can you run a duplicate key report on these 150 rows of company headcount data with fields like row_id, company_group, date, headcount, and open_roles?"},{"title":"Comparing headcount snapshots across reporting periods","prompt":"We have last month's headcount observations and this month's for the same companies — can you do a keyed comparison between the two datasets so I can see exactly which rows changed in headcount or open_roles, matched by row_id?"},{"title":"Validating data pipeline output consistency","prompt":"Our ETL pipeline ran twice and produced two versions of the headcount observations table — can you check the two outputs (up to 200 rows each) for duplicate keys within each set and then compare them side by side to flag any discrepancies in headcount or open_roles values?"}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report identifying any row_id values that appear more than once within the supplied rows, and (2) a keyed dataset comparison showing row-by-row differences between the 'rows' and 'other' arrays matched on row_id, covering headcount and open_roles fields. No external data is fetched; analysis is performed entirely on the supplied records.","failureModes":["Fewer than 1 row supplied — validation error","More than 200 rows supplied — request rejected","Missing required fields (row_id, company_group, date, headcount, open_roles) — schema validation failure","Invalid date format (not YYYY-MM-DD) — pattern validation error","row_id exceeds 80 characters — field length error","Payment of 0.01 USDC not completed — 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a dataset-to-dataset comparison for company headcount observations (headcount, open_roles) in a single $0.01 call, without needing live data lookups, predictions, or external integrations. It is ideal for data pipeline validation, ETL output QA, and HR data reconciliation tasks where you supply both datasets locally.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:44:56.592Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-duplicate-key-report-keyed-dataset-f8592966"}