{"uid":"cap_bbGgaWL_ASMTcCmvHPnoG","slug":"api-usage-exact-row-deduplication-ad9f4266","name":"API Usage Exact Row Deduplication","description":"API usage - Exact row deduplication: Exact row deduplication for API usage. Up to 200 supplied typed records. Local numeric and data-quality processing; no external enrichment or forecasting. One of 25 profiles or calculations across 20 shared operations in this sector. 0.01 USDC includes one bounded exact row deduplication deliverable.","url":"https://market.datapackvibe.com/x402/assistant-sector-analytics-api-usage-deduplicate?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","endpoint","date","requests","latency_ms"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"endpoint":{"type":"string","default":"","maxLength":80},"requests":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"latency_ms":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","endpoint":"group-a","requests":10,"latency_ms":1},{"date":"2026-10-02","row_id":"row-2","endpoint":"group-b","requests":20,"latency_ms":2},{"date":"2026-10-03","row_id":"row-3","endpoint":"group-a","requests":15,"latency_ms":3},{"date":"2026-10-04","row_id":"row-4","endpoint":"group-b","requests":30,"latency_ms":4}],"maxItems":200,"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_UCB3WT_tqScvL6ucUYlAQ","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 exact duplicate rows from API usage records (endpoint, date, requests, latency_ms) and returns a deduplicated set of up to 200 typed records.","exampleAgentPrompt":"I have a list of API usage records with endpoint names, dates, request counts, and latency values — can you deduplicate them and give me back only the unique rows?","exampleUseCases":[{"title":"Clean API logs before billing reconciliation","prompt":"I'm about to run billing reconciliation and I think my API usage export has duplicate rows — can you deduplicate these records? Each row has a row_id, endpoint, date, number of requests, and latency in ms."},{"title":"Prepare analytics dataset from repeated ingestion","prompt":"My data pipeline ingested the same API usage batch twice and now I have duplicate entries. Can you deduplicate this set of up to 200 rows so I only keep one copy of each unique record?"},{"title":"Normalize endpoint usage before dashboard import","prompt":"Before I load this API usage data into my dashboard, I need to strip out any exact duplicate rows — same endpoint, date, requests, and latency. Can you clean that up for me?"}],"resultDescription":"A deduplicated array of API usage records where every row is unique across all fields (endpoint, date, requests, latency_ms). Duplicate rows are removed, and only distinct records are returned.","failureModes":["Input array is empty (minItems:1 violated — request rejected)","More than 200 rows submitted (maxItems:200 exceeded — request rejected)","Missing required fields (row_id, endpoint, date, requests, or latency_ms) on any row — validation error","Date field not matching YYYY-MM-DD pattern — validation error","row_id exceeds 80 characters — validation error","Payment of 0.01 USDC not provided or x402 payment handshake fails — authentication/payment error"],"whenToPreferThis":"Choose this endpoint when you have a small-to-medium batch of API usage records (up to 200 rows) and need exact row deduplication locally, without any external enrichment, forecasting, or fuzzy matching. Ideal for data pipeline cleanup before analytics or billing.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T19:42:34.531Z","isFirstParty":false,"canonicalSlug":"api-usage-exact-row-deduplication-ad9f4266"}