{"uid":"cap_s3OVNjKcjY4fRI_JffkzK","slug":"transaction-fee-observations-exact-row-deduplication-base-100-series-987c3e6b","name":"Transaction Fee Observations — Exact Row Deduplication + Base-100 Series","description":"Transaction fee observations — Exact row deduplication + Base-100 series: Exact row deduplication + Base-100 series for supplied transaction fee observations records (fee_units, transaction_count). Up to 200 rows; 2 independent reports using shared local analytical engines. No live lookup, prediction, professional assessment or external action. 0.01 USDC includes 2 supplied-data reports for up to 200 rows.","url":"https://market.datapackvibe.com/x402/assistant-ib26-finance-03-047?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","instrument_group","date","fee_units","transaction_count"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"fee_units":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"instrument_group":{"type":"string","default":"","maxLength":80},"transaction_count":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","fee_units":10,"instrument_group":"group-a","transaction_count":1},{"date":"2026-10-02","row_id":"row-2","fee_units":20,"instrument_group":"group-b","transaction_count":2},{"date":"2026-10-03","row_id":"row-3","fee_units":15,"instrument_group":"group-a","transaction_count":3},{"date":"2026-10-04","row_id":"row-4","fee_units":30,"instrument_group":"group-b","transaction_count":4}],"maxItems":200,"minItems":1},"field":{"enum":["fee_units","transaction_count"],"type":"string","default":"fee_units"},"base_index":{"type":"integer","default":0,"maximum":199,"minimum":0}}},"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_Di8aV5QGaBSlfG4J34WBB","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":"Deduplicates transaction fee observation rows and computes a Base-100 index series for fee_units or transaction_count fields across up to 200 supplied records.","exampleAgentPrompt":"Can you deduplicate my transaction fee observations and generate a Base-100 index series for fee_units starting at row index 0? Here are my rows: row-1 on 2026-10-01 group-a fee_units=10 transaction_count=1, row-2 on 2026-10-02 group-b fee_units=20 transaction_count=2, row-3 on 2026-10-03 group-a fee_units=15 transaction_count=3.","exampleUseCases":[{"title":"Normalize fee trends across instrument groups","prompt":"I have 50 rows of daily fee_units observations across two instrument groups and I need to deduplicate them and then build a Base-100 index series anchored to the first row so I can compare fee trends over time — can you run both reports?"},{"title":"Audit duplicate fee records before reporting","prompt":"Before I submit our quarterly fee report, can you check these 120 transaction fee observation rows for exact duplicates and also produce a base-100 series for transaction_count starting at row index 0?"},{"title":"Index transaction counts to baseline for dashboard","prompt":"I want to normalize my transaction_count data to a base-100 series starting at row index 2, and also strip out any duplicate rows from my dataset — here are the 30 records with row_id, date, instrument_group, fee_units, and transaction_count."}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the supplied dataset, and (2) a Base-100 index series computed for the selected field (fee_units or transaction_count) relative to the specified base row index, covering up to 200 input rows.","failureModes":["Input array exceeds 200 rows — request will be rejected","Missing required fields (row_id, instrument_group, date, fee_units, transaction_count) on any row causes validation failure","base_index out of range (0–199) or pointing beyond the supplied row count","Malformed date strings not matching YYYY-MM-DD pattern rejected","All rows are duplicates — deduplication report returns empty result set","Numeric values outside ±1,000,000,000,000 range rejected","Payment failure or insufficient USDC balance blocks execution"],"whenToPreferThis":"Choose this endpoint when you have up to 200 transaction fee observation records and need both exact row deduplication and a Base-100 normalized index series in a single call. It is ideal for financial data cleaning and trend normalization workflows where you supply your own data and want local analytical processing without live market lookups or external data enrichment. Prefer it over generic data tools when working specifically with fee_units and transaction_count fields across instrument groups.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-26T12:32:21.199Z","isFirstParty":false,"canonicalSlug":"transaction-fee-observations-exact-row-deduplication-base-100-series-987c3e6b"}