{"uid":"cap_KoF61j4qmcOQmCM1Je3j5","slug":"remove-duplicates-text-match-sort-numbers-descending-6872a708","name":"Remove Duplicates → Text Match → Sort Numbers Descending","description":"Remove duplicate rows → Match text in a column → Sort numbers descending: Process customer-supplied records: Remove duplicate rows → Match text in a column → Sort numbers descending. 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-72a93bfc8cb8b26e2d26?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_RH6l3SnAGety1lnBEH7nc","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 by sequentially removing duplicate rows, filtering rows where a text column matches a query, and sorting the results by a numeric column in descending order.","exampleAgentPrompt":"Take these customer records and run them through a three-step pipeline: first remove any duplicate rows, then keep only rows where the 'category' column matches 'electronics', and finally sort what's left by the 'price' column from highest to lowest.","exampleUseCases":[{"title":"Deduplicate and rank product listings","prompt":"I have a list of product records with duplicates — can you remove the dupes, keep only rows where the 'type' field contains 'widget', and sort the results by 'revenue' from highest to lowest?"},{"title":"Filter customer survey responses by keyword","prompt":"Here are my survey responses. Remove any duplicate entries, filter down to rows where the 'answer' column matches 'satisfied', then sort them by 'score' descending so I see the highest scores first."},{"title":"Clean and prioritize support tickets","prompt":"Can you process these support ticket records — strip out duplicate rows, keep only tickets where the 'status' field matches 'open', and order the result by 'priority_score' from highest to lowest?"}],"resultDescription":"Returns the fully processed records array after all three sequential steps (deduplication, text match filter, numeric sort descending), along with row counts at each stage so you can see how many rows were removed or kept at each step.","failureModes":["Empty records array or fewer than 1 item returns a validation error","Records array exceeding 300 items is rejected","Field name not matching pattern ^[a-zA-Z][a-zA-Z0-9_]{0,39}$ returns schema error","Query string shorter than 1 character or longer than 100 characters is rejected","Non-object items in records array cause schema validation failure","No rows surviving deduplication or text-match filter returns empty result set with zero rows"],"whenToPreferThis":"Choose this endpoint when you need a fixed three-step pipeline (deduplicate → text-match filter → numeric descending sort) applied to up to 300 flat records in a single call for a flat $0.01 USDC. Ideal for lightweight ETL preprocessing, data cleaning tasks, or quick report generation where you don't want to maintain your own transformation logic. Not suitable if you need a different operation order, more than 300 records, external data lookups, or custom aggregation beyond these three steps.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:48:24.517Z","isFirstParty":false,"canonicalSlug":"remove-duplicates-text-match-sort-numbers-descending-6872a708"}