{"uid":"cap_LK1_8yLwrnvGdNnKEbJAU","slug":"remove-duplicate-rows-match-text-in-column-numeric-summary-a0aba4da","name":"Remove Duplicate Rows → Match Text in Column → Numeric Summary","description":"Remove duplicate rows → Match text in a column → Numeric summary: Process customer-supplied records: 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-a359e296a6341bcba00f?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_-0TCgnh0CIjd4sEIUrPbA","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 customer-supplied records by deduplicating rows, filtering by text match in a specified column, then returning a numeric summary with row counts per step.","exampleAgentPrompt":"I have a list of up to 300 customer records with a 'text' column and a 'value' column — can you remove duplicate rows, then keep only rows where 'text' contains 'Useful example', and give me a numeric summary with row counts at each step?","exampleUseCases":[{"title":"Clean and summarize sales records","prompt":"I've got a batch of sales records with a 'product' column and a 'revenue' column — remove any duplicate rows, then filter to rows where 'product' matches 'Widget A', and give me a numeric summary of the revenue values with counts at each stage."},{"title":"Deduplicate survey responses by keyword","prompt":"Here are 200 survey responses in a 'response' field — strip out exact duplicates, then keep only rows where 'response' contains 'satisfied', and show me a numeric summary with how many rows survived each step."},{"title":"Filter and count unique inventory items","prompt":"Take this inventory list with an 'item_name' column and a 'quantity' column, remove duplicate entries, match only rows where 'item_name' includes 'bolt', and return the numeric summary and row counts for each stage of processing."}],"resultDescription":"Returns the processed output records and row counts per step: (1) after deduplication, (2) after text-match filtering, and (3) a numeric summary of the remaining data. Up to 300 input records supported per call.","failureModes":["Input records array is empty or missing (minItems: 1 violated)","More than 300 records supplied (maxItems exceeded)","Field name doesn't match pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ or exceeds 40 characters","Query string is empty or exceeds 100 characters","Records contain objects with more than 30 properties (maxProperties violated)","No rows survive the text-match filter, resulting in empty output set"],"whenToPreferThis":"Choose this endpoint when you have a flat dataset (up to 300 records) and need a chained pipeline of deduplication followed by text-column filtering followed by numeric aggregation — all in a single call for $0.01 USDC. It is ideal for lightweight, self-contained data cleaning and summarization tasks that do not require external data lookups or complex transformations beyond this three-step sequence.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:29.748Z","isFirstParty":false,"canonicalSlug":"remove-duplicate-rows-match-text-in-column-numeric-summary-a0aba4da"}