{"uid":"cap_td-oG5J5kEzx4Ro8QgnEL","slug":"newsroom-assignments-duplicate-key-report-keyed-dataset-comparison-c6e90c9e","name":"Newsroom Assignments Duplicate Key Report + Keyed Dataset Comparison","description":"Newsroom assignments — Duplicate key report + Keyed dataset comparison: Duplicate key report + Keyed dataset comparison for supplied newsroom assignments records (assigned_items, completed_items). 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-news-03-069?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","assigned_items","completed_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"channel_group":{"type":"string","default":"","maxLength":80},"assigned_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","channel_group":"group-a","assigned_items":10,"completed_items":1},{"date":"2026-10-02","row_id":"row-2","channel_group":"group-b","assigned_items":20,"completed_items":2},{"date":"2026-10-03","row_id":"row-3","channel_group":"group-a","assigned_items":15,"completed_items":3},{"date":"2026-10-04","row_id":"row-4","channel_group":"group-b","assigned_items":30,"completed_items":4}],"maxItems":200,"minItems":1},"other":{"type":"array","items":{"type":"object","required":["row_id","channel_group","date","assigned_items","completed_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"channel_group":{"type":"string","default":"","maxLength":80},"assigned_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"completed_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","channel_group":"group-a","assigned_items":10,"completed_items":1},{"date":"2026-10-02","row_id":"row-2","channel_group":"group-b","assigned_items":21,"completed_items":2},{"date":"2026-10-03","row_id":"row-3","channel_group":"group-a","assigned_items":17,"completed_items":3},{"date":"2026-10-04","row_id":"row-4","channel_group":"group-b","assigned_items":33,"completed_items":4}],"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_EfcpoI5IhnQxKiGtgAotz","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 rows of newsroom assignment records to produce a duplicate key report and a keyed dataset comparison between two supplied datasets.","exampleAgentPrompt":"Can you check my newsroom assignment records for duplicate row IDs and also compare today's dataset against yesterday's — I'll give you both sets of rows with fields like row_id, channel_group, date, assigned_items, and completed_items, up to 200 rows each?","exampleUseCases":[{"title":"Catching duplicate assignments before editorial review","prompt":"I have a CSV export of this week's newsroom assignments with columns row_id, channel_group, date, assigned_items, and completed_items — can you scan it for any duplicate row IDs so we can clean it up before the editorial meeting?"},{"title":"Comparing morning vs evening assignment snapshots","prompt":"Here are two snapshots of our newsroom assignment data from this morning and this evening — both have row_id, channel_group, date, assigned_items, and completed_items fields. Can you compare them key-by-key and tell me what changed?"},{"title":"Auditing channel group data after a system migration","prompt":"We just migrated our newsroom assignment records and I want to make sure nothing got duplicated or corrupted — can you run a duplicate key check and compare the pre-migration and post-migration datasets? Both have the same schema: row_id, channel_group, date, assigned_items, completed_items."}],"resultDescription":"Returns two independent analytical reports: (1) a duplicate key report flagging any row_id values that appear more than once within the supplied dataset, and (2) a keyed dataset comparison showing differences between the two supplied datasets matched by key fields, covering assigned_items and completed_items values. No external data is fetched; all analysis is performed on the submitted rows only.","failureModes":["Exceeding 200 rows causes rejection — keep both datasets within the limit","Missing required fields (row_id, channel_group, date, assigned_items, completed_items) will cause validation errors","Malformed date strings not matching YYYY-MM-DD pattern will be rejected","Empty rows array will fail minItems:1 constraint","Values outside the allowed numeric range for assigned_items or completed_items will be rejected"],"whenToPreferThis":"Choose this endpoint when you need both a duplicate key audit and a side-by-side keyed comparison of two newsroom assignment datasets in a single low-cost call. It is purpose-built for editorial and newsroom workflows involving assigned_items and completed_items metrics grouped by channel and date. Prefer it over generic data tools when your records fit the specific schema (row_id, channel_group, date, assigned_items, completed_items) and you want both reports together for $0.01 USDC without any external lookups or live data dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-30T12:38:08.031Z","isFirstParty":false,"canonicalSlug":"newsroom-assignments-duplicate-key-report-keyed-dataset-comparison-c6e90c9e"}