{"uid":"cap_nhoQq223IlrnnIA7CrTZN","slug":"trim-deduplicate-match-and-summarize-text-records-7e7ad9c0","name":"Trim, Deduplicate, Match, and Summarize Text Records","description":"Trim text fields → Remove duplicate rows → Match text in a column → Numeric summary: Process customer-supplied records: Trim text fields → Remove duplicate rows → Match text in a column → Numeric summary. 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-200605745edb91804dda?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"field":{"type":"string","default":"value","pattern":"^[a-zA-Z][a-zA-Z0-9_]{0,39}$","maxLength":40},"query":{"type":"string","default":"useful","maxLength":100,"minLength":1},"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_9sipEkUVeKqJHT664MAEe","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 a batch of records through four sequential steps: trim text fields, remove duplicate rows, filter rows matching a text pattern, and compute a numeric summary.","exampleAgentPrompt":"Clean up these 50 customer records for me — trim whitespace from the 'name' field, remove any duplicate rows, then filter for rows matching 'premium', and give me a numeric summary and row count at each step.","exampleUseCases":[{"title":"Clean CRM export before import","prompt":"I've got 200 rows exported from our CRM with messy whitespace in the 'company' field and a bunch of duplicates — can you trim that field, deduplicate the rows, filter for ones matching 'enterprise', and tell me the counts at each stage?"},{"title":"Deduplicate survey responses and count matches","prompt":"Here are 150 survey responses — please trim the 'response' field, remove duplicate answers, then find all rows that match 'satisfied', and give me a numeric summary of the 'score' column."},{"title":"Validate uniqueness after text normalization","prompt":"Can you run these 80 product records through the cleaning pipeline? Trim the 'title' field, drop any duplicates, match rows containing 'organic', and show me how many rows remain after each step plus a numeric summary."}],"resultDescription":"Returns the fully processed records after all four pipeline steps (trim → deduplicate → match → numeric summary), along with row counts at each stage and a numeric summary of the relevant column. All processing is self-contained with no external data lookups.","failureModes":["Empty records array or missing required 'records' field returns a validation error","'field' parameter references a column that does not exist in the supplied records — may return zero matches or an error","'query' string that matches nothing returns an empty matched set and zero count at that step","Supplying more than 300 records exceeds the plan limit and may be rejected","Non-string values in the targeted field may be skipped or cause unexpected trim behavior"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, self-contained, multi-step data cleaning pipeline (trim → deduplicate → match → summarize) on small-to-medium record sets (up to 300 rows) without spinning up a full ETL system. It is ideal for pre-processing customer-supplied data before import, quickly validating uniqueness after text normalization, or getting a per-step audit trail of row counts during data quality checks.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-27T13:06:59.787Z","isFirstParty":false,"canonicalSlug":"trim-deduplicate-match-and-summarize-text-records-7e7ad9c0"}