{"uid":"cap_llWf4qyDm-RH1tdgLhNQ0","slug":"moneypilot-json-deduplication-api-2b55e882","name":"MoneyPilot JSON Deduplication API","description":"Autonomous earning worker plus eleven deterministic x402 APIs paid in Base USDC: endpoint trust scoring, API health, wallet activity, URL evidence, site maps, gas data, transaction receipts, JSON tools, and x402 verification.","url":"https://moneypilot-c6f8c4.joedyermens.chatgpt.site/api/x402/json-dedup","method":"GET","headers":{},"bodySchema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method"],"properties":{"type":{"type":"string","const":"http"},"method":{"enum":["GET","HEAD","DELETE"],"type":"string"},"queryParams":{"type":"object","required":["rows"],"properties":{"rows":{"type":"array","items":{"type":"object"},"maxItems":1000},"keyFields":{"type":"array","items":{"type":"string"},"maxItems":20}}}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":"object"}}}}},"responseSchema":{"type":"json","example":{"ok":true,"rows":[{"id":1,"value":"a"}],"inputCount":2,"uniqueCount":1,"duplicateCount":1}},"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_1TDRtBZe_ERAc8RoIMU6T","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 objects from a JSON array using configurable key fields, returning only unique rows with deduplication statistics.","exampleAgentPrompt":"Can you deduplicate this list of JSON objects for me — there are about 50 rows and I want to match on the 'id' and 'email' fields to find and remove duplicates?","exampleUseCases":[{"title":"Clean duplicate product records","prompt":"I have a JSON array of product records pulled from two sources and there are duplicates — can you deduplicate them by the 'sku' field and tell me how many dupes were removed?"},{"title":"Deduplicate user event log","prompt":"Here's a list of user events in JSON format, some appear more than once — please deduplicate on 'userId' and 'eventType' and return only unique combinations."},{"title":"Merge and deduplicate contact lists","prompt":"I've combined two contact lists into a single JSON array and need to remove any duplicate contacts — match on 'email' and give me back just the unique ones."}],"resultDescription":"Returns a JSON object with ok:true, the deduplicated rows array, the original input count, the number of unique rows, and the number of duplicates removed.","failureModes":["Missing required 'rows' query parameter returns an error","Array exceeds 1000-item limit returns a validation error","Malformed JSON objects in the array may cause processing errors","Invalid keyFields values (non-existent field names) may return all rows as unique","Payment failure via x402 returns HTTP 402 before processing"],"whenToPreferThis":"Choose this endpoint when you need a fast, deterministic, pay-per-call JSON deduplication tool without setting up infrastructure. Ideal for agents that process JSON arrays from APIs or scrapers and need to clean duplicate records on the fly. Prefer this over custom deduplication logic when working with up to 1000 rows and needing explicit duplicate counts.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:41:08.061Z","isFirstParty":false}