{"uid":"cap_p0J8iYxBwjpCFk_nN2ZPp","slug":"remove-duplicates-filter-non-null-numeric-summary-pipeline-b1f5aa37","name":"Remove Duplicates → Filter Non-Null → Numeric Summary Pipeline","description":"Remove duplicate rows → Keep rows with a value → Numeric summary: Process customer-supplied records: Remove duplicate rows → Keep rows with a value → 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-d209400e5f06b6f1531b?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},"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_qfIoGEiMlaigtzJda1Ze2","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 three sequential steps: deduplication, filtering rows with a value in a specified field, and computing a numeric summary — returning processed output and row counts per step.","exampleAgentPrompt":"I have a list of customer records with a 'value' field — can you remove any duplicate rows, keep only rows where 'value' is filled in, and then give me a numeric summary of what's left?","exampleUseCases":[{"title":"Sales data dedup and summary","prompt":"I've got up to 300 sales transaction records with a 'revenue' field. Can you strip out duplicate rows, keep only the ones that actually have a revenue value, and give me a numeric summary of the revenue figures?"},{"title":"Survey response cleanup","prompt":"Here are my survey responses — each row has a 'score' field. Please deduplicate the rows, drop any that are missing a score, and summarize the score distribution numerically."},{"title":"Inventory record aggregation","prompt":"I have an inventory list with a 'quantity' field and there are duplicate entries. Run it through deduplication, filter to rows with a quantity value, and return the numeric summary along with how many rows survived each step."}],"resultDescription":"Returns the processed records after each pipeline stage (deduplicated, then filtered, then summarized), along with row counts showing how many records remained after each step and numeric summary statistics (such as count, sum, min, max, mean) for the specified numeric field.","failureModes":["Empty records array (violates minItems:1 constraint)","More than 300 records submitted (exceeds maxItems:300)","Field name does not match pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ (invalid field name)","Records contain objects with more than 30 properties (violates maxProperties:30)","Specified field does not exist in any records, resulting in empty filtered output","Non-numeric values in field preventing numeric summary computation","Payment of 0.01 USDC not provided, resulting in 402 Payment Required"],"whenToPreferThis":"Choose this endpoint when you need a quick, all-in-one data cleaning and summarization pipeline on up to 300 flat records — specifically when you want to deduplicate, filter non-null rows by field, and get numeric statistics in a single API call without setting up your own ETL. It's ideal for lightweight data-prep tasks where the records fit within the 300-row flat limit and you need row-count transparency per step.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-18T00:58:42.096Z","isFirstParty":false,"canonicalSlug":"remove-duplicates-filter-non-null-numeric-summary-pipeline-b1f5aa37"}