{"uid":"cap_ibymKuBfnPDzAh7UdgcRA","slug":"company-headcount-observations-exact-row-deduplication-date-by-3c412b3a","name":"Company Headcount Observations — Exact Row Deduplication + Date by Category Pivot","description":"Company headcount observations — Exact row deduplication + Date by category pivot: Exact row deduplication + Date by category pivot 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-052?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_dmPv4tnVEA2aXRRCAfDJW","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 duplicate rows and generates a date-by-category pivot table from company headcount observation records (headcount or open_roles), processing up to 200 rows in two bundled analytical reports.","exampleAgentPrompt":"I have up to 200 rows of company headcount observations with fields row_id, company_group, date, headcount, and open_roles — can you deduplicate exact duplicate rows and then pivot the headcount values by date and company group into a summary table?","exampleUseCases":[{"title":"Cleaning duplicate HR data exports","prompt":"I exported our HR system's headcount records and there are definitely duplicate rows in the data. Can you deduplicate the exact duplicate entries and also pivot the headcount numbers by date and company group so I can see a clean summary? Here are up to 200 rows with row_id, company_group, date, headcount, and open_roles fields."},{"title":"Open roles trend pivot by department","prompt":"I want to see how open_roles have changed across our different company groups over time. Can you take these headcount observation records, remove any exact duplicates, and create a pivot table of open_roles by date and company_group for me?"},{"title":"Validating headcount data before reporting","prompt":"Before I send our quarterly headcount report to leadership, can you run a deduplication pass on these headcount observation rows and generate a date-by-category pivot on the headcount field so I can spot any anomalies? I have about 150 rows with company_group, date, headcount, and open_roles."}],"resultDescription":"Returns two analytical reports sharing local analytical engines: (1) an exact-row-deduplicated version of the supplied records removing identical duplicate rows, and (2) a pivot table organizing the selected field (headcount or open_roles) by date (rows) and company_group (columns), covering up to 200 input rows.","failureModes":["Exceeding 200 rows returns an error or truncation","Missing required fields (row_id, company_group, date, headcount, open_roles) causes validation failure","Invalid date format (not YYYY-MM-DD) causes schema rejection","Payment failure (insufficient USDC balance) blocks the call","Null values in headcount or open_roles may affect pivot completeness","Empty rows array causes a minItems validation error"],"whenToPreferThis":"Choose this endpoint when you already have company headcount or open_roles data in hand and need to (1) remove exact duplicate records and (2) reshape the data into a date-by-category pivot table — all in a single low-cost ($0.01 USDC) call covering up to 200 rows. It is ideal for pre-reporting data cleaning and quick restructuring of HR observation exports without needing a live database connection or external workforce data provider.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-19T06:45:37.703Z","isFirstParty":false,"canonicalSlug":"company-headcount-observations-exact-row-deduplication-date-by-3c412b3a"}