{"uid":"cap_98po4ZQEjvCUORIN56mW-","slug":"returns-handling-data-quality-suite-record-quality-audit-exact-row-fadde893","name":"Returns Handling Data Quality Suite — Record Quality Audit, Exact Row Deduplication & Duplicate Key Report","description":"Returns handling — Record quality audit + Exact row deduplication + Duplicate key report: Record quality audit + Exact row deduplication + Duplicate key report for supplied returns handling records (returned_units, processing_minutes). 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-retail-04-209?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","store_group","date","returned_units","processing_minutes"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"store_group":{"type":"string","default":"","maxLength":80},"returned_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"processing_minutes":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","store_group":"group-a","returned_units":10,"processing_minutes":1},{"date":"2026-10-02","row_id":"row-2","store_group":"group-b","returned_units":20,"processing_minutes":2},{"date":"2026-10-03","row_id":"row-3","store_group":"group-a","returned_units":15,"processing_minutes":3},{"date":"2026-10-04","row_id":"row-4","store_group":"group-b","returned_units":30,"processing_minutes":4}],"maxItems":200,"minItems":1}}},"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_5Y8zl1U2PWFeix_ml1kWk","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 analytical reports on returns handling data: a record quality audit, exact row deduplication, and a duplicate key report — all locally, with no external calls.","exampleAgentPrompt":"Can you run a full data quality check on my returns handling records — I need a record quality audit, exact row deduplication, and a duplicate key report for these rows covering store groups A and B from October 2026 with returned_units and processing_minutes?","exampleUseCases":[{"title":"Pre-reporting returns data cleanup","prompt":"Before I generate my monthly returns report, can you audit these 150 rows of returns handling data for quality issues, remove any exact duplicate rows, and flag any duplicate row IDs? The data has store groups, dates, returned_units, and processing_minutes fields."},{"title":"Catching data pipeline errors","prompt":"Our ETL pipeline may have introduced duplicate records into our returns dataset — can you run an exact row deduplication and duplicate key report on these 80 rows so I can see what got duplicated before I push to the warehouse?"},{"title":"Returns data governance audit","prompt":"I need a formal record quality audit on this returns handling extract — about 200 rows with returned_units and processing_minutes per store group — to identify nulls, bad values, and any repeated entries before we share it with the ops team."}],"resultDescription":"Three independent analytical reports delivered together: (1) a record quality audit summarizing data issues such as nulls, out-of-range values, and format violations across returned_units and processing_minutes fields; (2) an exact row deduplication result showing which rows are identical and a cleaned set; (3) a duplicate key report identifying rows sharing the same row_id or key combination. All analysis is performed locally on the submitted data with no external lookups.","failureModes":["Exceeding 200-row limit results in rejection or truncation","Missing required fields (row_id, date, store_group, returned_units, processing_minutes) causes validation error","Malformed date strings not matching YYYY-MM-DD pattern are flagged or rejected","Empty rows array (minItems:1 not met) returns an error","Numeric values outside the allowed range may be rejected or flagged","Payment of 0.01 USDC not received causes 402 response blocking processing"],"whenToPreferThis":"Choose this endpoint when you need all three data quality operations — record quality audit, exact deduplication, and duplicate key reporting — bundled in a single low-cost call on returns handling data (up to 200 rows). It is ideal for pre-processing retail returns datasets before analytics or warehousing, when no live lookup or external enrichment is needed and the full analysis can be done on supplied data alone. Prefer alternatives if you need only one of the three reports, need more than 200 rows processed, or require predictive analytics or external data enrichment.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T18:37:40.842Z","isFirstParty":false,"canonicalSlug":"returns-handling-data-quality-suite-record-quality-audit-exact-row-fadde893"}