{"uid":"cap_sVuKPc_T-26tn5aHr8dIK","slug":"newsroom-assignments-record-quality-audit-string-normalisation-e0347ccf","name":"Newsroom Assignments — Record Quality Audit + String Normalisation + Numeric Row Ordering","description":"Newsroom assignments — Record quality audit + String normalisation + Numeric row ordering: Record quality audit + String normalisation + Numeric row ordering for supplied newsroom assignments records (assigned_items, completed_items). 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-news-03-196?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},"field":{"enum":["assigned_items","completed_items"],"type":"string","default":"assigned_items"}}},"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_xMqwwXwjx6UDwmrEzHU--","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":"Runs three local analytical reports on newsroom assignment data: record quality audit, string normalisation, and numeric row ordering for up to 200 rows of assigned/completed items.","exampleAgentPrompt":"Can you run the three-report quality audit, string normalisation, and numeric row ordering on my newsroom assignment records? I have 4 rows: row-1 on 2026-10-01 for group-a with 10 assigned and 1 completed, row-2 on 2026-10-02 for group-b with 20 assigned and 2 completed, row-3 on 2026-10-03 for group-a with 15 assigned and 3 completed, row-4 on 2026-10-04 for group-b with 30 assigned and 4 completed — use assigned_items as the numeric field.","exampleUseCases":[{"title":"Weekly assignment data health check","prompt":"Run a quality audit, string normalisation, and numeric row ordering on this week's newsroom assignment data — I've got 8 rows covering groups alpha and beta from 2026-10-01 to 2026-10-08, with assigned_items ranging from 5 to 50 and completed_items from 1 to 40. Use assigned_items as the field to order by."},{"title":"Detecting bad records in editorial tracker","prompt":"Can you audit my editorial tracker export for record quality issues, normalise the channel_group strings, and sort rows by completed_items? I have 15 rows from October 2026 across groups 'News Desk', 'sports desk', and 'OPINION' with varying assigned and completed counts."},{"title":"Pre-reporting data clean-up for channel groups","prompt":"Before I build my report, I need you to run the three-report analysis — quality audit, string normalisation, and numeric ordering — on 20 rows of newsroom assignment records across channel groups 'breaking-news', 'features', and 'digital', dated from 2026-09-01 to 2026-09-20, ordered by assigned_items."}],"resultDescription":"Returns three independent analytical reports covering: (1) a record quality audit flagging completeness and validity issues per row, (2) string normalisation results for text fields like channel_group, and (3) numeric row ordering of the specified field (assigned_items or completed_items). All computed locally without external lookups.","failureModes":["Exceeding 200 rows returns a validation error","Missing required fields (row_id, channel_group, date, assigned_items, completed_items) cause row-level failures","Invalid date format (non-YYYY-MM-DD) triggers schema validation errors","Null numeric values may affect ordering report output","Payment failure over x402 prevents job execution"],"whenToPreferThis":"Choose this endpoint when you need a bundled, cost-efficient ($0.01 USDC) set of three data-quality operations on newsroom assignment records in a single call, without requiring any external data lookups or predictions. Best suited for structured editorial workflow data with up to 200 rows where string normalisation, quality auditing, and numeric ordering are all needed together.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:34:05.727Z","isFirstParty":false,"canonicalSlug":"newsroom-assignments-record-quality-audit-string-normalisation-e0347ccf"}