{"uid":"cap_bHbOrwv97KSCPb6zBzY_z","slug":"deduplicate-filter-and-count-rows-pipeline-176976e4","name":"Deduplicate, Filter, and Count Rows Pipeline","description":"Remove duplicate rows → Match text in a column → Count values by group: Process customer-supplied records: Remove duplicate rows → Match text in a column → Count values by group. 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-a15fdee7e1b56dadc983?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},"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_AQDmXtXHKVTJcOlRNRx_n","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":"Removes duplicate rows from a record set, filters rows where a specified text column matches a query string, then counts remaining records grouped by value.","exampleAgentPrompt":"Take these 200 customer records, remove any duplicate rows, then keep only the ones where the 'status' column contains the word 'active', and give me a count of how many remain per group.","exampleUseCases":[{"title":"Deduplicating survey response data","prompt":"I have a list of survey responses with duplicate submissions — can you remove the duplicates, filter for responses where the 'answer' field contains 'satisfied', and tell me how many fall into each group?"},{"title":"Cleaning CRM lead records","prompt":"Here are 250 lead records from our CRM, some are duplicates. Remove the dupes, match only rows where the 'source' column contains 'referral', then count how many leads we have per source group."},{"title":"Filtering and counting product feedback entries","prompt":"Take this batch of product feedback rows, strip out any duplicate entries, filter to only those where the 'comment' field includes the word 'bug', and show me the count broken down by group."}],"resultDescription":"Returns the processed output after three sequential steps: (1) deduplicated records with count, (2) text-matched filtered records with count, and (3) a group-by count breakdown — all in a single response payload.","failureModes":["Records array is empty or missing — returns validation error","Field name does not match any property in the submitted records — filter step returns zero matches","Query string is empty or too long (>100 chars) — returns validation error","More than 300 records submitted — request rejected with limit exceeded error","Record objects contain more than 30 properties — schema validation failure"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, stateless three-step pipeline (deduplicate → text filter → group count) applied to up to 300 flat records in a single API call. It's ideal when you don't want to wire up multiple transformation steps yourself, need a cheap per-call price ($0.01 USDC), and have no need for external data lookups or joins.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:31.334Z","isFirstParty":false,"canonicalSlug":"deduplicate-filter-and-count-rows-pipeline-176976e4"}