{"uid":"cap_6B66aC3SuVwz5RJxfNNzW","slug":"creative-review-row-deduplication-and-numeric-ordering-cb90154d","name":"Creative Review Row Deduplication and Numeric Ordering","description":"Creative review — Exact row deduplication + Numeric row ordering: Exact row deduplication + Numeric row ordering for supplied creative review records (feedback_count, approved_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-creative-25-042?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","feedback_count","approved_items"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"approved_items":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"feedback_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","approved_items":1,"feedback_count":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","approved_items":2,"feedback_count":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","approved_items":3,"feedback_count":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","approved_items":4,"feedback_count":30}],"maxItems":200,"minItems":1},"field":{"enum":["feedback_count","approved_items"],"type":"string","default":"feedback_count"}}},"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_GV-O7ZxNhe0aiWmF5T68_","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 rows and applies numeric ordering to creative review records (feedback_count, approved_items) for up to 200 rows, returning 2 analytical reports.","exampleAgentPrompt":"Can you deduplicate and numerically sort my creative review records by feedback_count? I have rows with fields like row_id, asset_group, date, feedback_count, and approved_items — up to 50 rows — and I need 2 reports: one for exact duplicate removal and one for numeric ordering.","exampleUseCases":[{"title":"Clean duplicate creative feedback entries","prompt":"I have a batch of creative review records with asset groups and dates, and I suspect there are exact duplicate rows. Can you run deduplication on them and give me a report showing which rows were removed? The field I care about is feedback_count."},{"title":"Rank ad assets by approval count","prompt":"I need to numerically order my creative review dataset by approved_items so I can see which asset groups have the most approvals. Can you sort these rows and give me an ordered report?"},{"title":"Audit creative review data before reporting","prompt":"Before I send this creative review data to my manager, can you deduplicate the rows and sort them by feedback_count so the report looks clean? I have about 80 rows with row_id, asset_group, date, feedback_count, and approved_items fields."}],"resultDescription":"Returns 2 analytical reports: one showing exact row deduplication results (identifying and removing duplicate rows from the creative review dataset) and one showing numeric ordering of rows by the selected field (feedback_count or approved_items), processed locally without any external lookups.","failureModes":["Input array exceeds 200 rows — request rejected","Missing required fields (row_id, asset_group, date, feedback_count, approved_items) in one or more rows — validation error","Invalid date format (not YYYY-MM-DD) — schema validation failure","No rows provided (minItems: 1 not met) — request rejected","Numeric values out of allowed range (±1,000,000,000,000) — validation error"],"whenToPreferThis":"Choose this endpoint when you need fast, local deduplication and numeric sorting of creative review tabular data (up to 200 rows) without sending data to external prediction or AI services. It is cost-effective at $0.01 USDC for 2 reports and is ideal for pre-processing creative feedback datasets before analysis or reporting.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-09T00:32:48.899Z","isFirstParty":false,"canonicalSlug":"creative-review-row-deduplication-and-numeric-ordering-cb90154d"}