{"uid":"cap_ZresVWkvB-wIk3Ir2I8yC","slug":"trim-deduplicate-and-filter-records-pipeline-3a34715e","name":"Trim, Deduplicate, and Filter Records Pipeline","description":"Trim text fields → Remove duplicate rows → Keep rows with a value: Process customer-supplied records: Trim text fields → Remove duplicate rows → Keep rows with a value. Returns the processed output and row counts per step. No external data lookup. 0.01 USDC includes up to 300 flat records.","url":"https://market.datapackvibe.com/x402/assistant-cap-e2336958058c63ea6b13?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"field":{"type":"string","default":"text","pattern":"^[a-zA-Z][a-zA-Z0-9_]{0,39}$","maxLength":40},"records":{"type":"array","items":{"type":"object","maxProperties":30,"additionalProperties":{"type":["string","number","boolean","null"]}},"default":[{"text":" Useful example ","value":10},{"text":"Useful example","value":20},{"text":"Other row","value":5}],"maxItems":300,"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_Dz8rbh5AdAnm-CrcVnktp","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":"Processes tabular records through a three-step pipeline: trims whitespace from text fields, removes duplicate rows, then filters out rows missing a value in the specified field.","exampleAgentPrompt":"Clean up these customer records for me — trim any extra whitespace from the 'name' field, remove duplicate rows, and then drop any rows where 'name' is empty. Here are up to 300 records: [{\"name\": \" Alice \", \"score\": 10}, {\"name\": \"Alice\", \"score\": 20}, {\"name\": \"\", \"score\": 5}].","exampleUseCases":[{"title":"Deduplicating email subscriber list","prompt":"I have a list of email subscriber records with extra spaces and duplicates in the 'email' field — can you trim the whitespace, remove duplicates, and drop any rows where 'email' is blank? Here's the list of up to 300 records."},{"title":"Cleaning form submission data","prompt":"These form submissions have messy 'company' field values with leading/trailing spaces and a bunch of duplicates. Can you trim the 'company' field, deduplicate the rows, and remove any entries where 'company' has no value?"},{"title":"Normalizing product catalog entries","prompt":"I've got a raw product list where the 'sku' field has inconsistent whitespace and there are duplicate entries. Please trim the 'sku' field, strip duplicates, and filter out rows where 'sku' is missing or empty."}],"resultDescription":"Returns the processed records array after all three pipeline steps, plus row counts at each stage (original count, after trim, after deduplication, after filtering), enabling the caller to see exactly how many rows were dropped at each step.","failureModes":["Empty records array returns a validation error (minItems:1 not satisfied)","Field name not matching pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ causes schema rejection","Records array exceeding 300 items returns a 400 error","Individual record objects exceeding 30 properties may be rejected","Non-string/number/boolean/null field values cause schema validation failure","Network timeout if payload is very large near the 300-record limit"],"whenToPreferThis":"Choose this endpoint when you need a fast, cheap ($0.01 USDC for up to 300 records), stateless pipeline that handles the three most common tabular data cleaning steps — whitespace trimming, deduplication, and blank-row removal — in a single call without needing an external data source or a full ETL framework. Ideal for pre-processing user-submitted records, form data, or CSV exports before storage or analysis.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:35.239Z","isFirstParty":false,"canonicalSlug":"trim-deduplicate-and-filter-records-pipeline-3a34715e"}