{"uid":"cap_MgzTba25n6YbYkSTtauru","slug":"illustration-estimates-exact-row-deduplication-base-100-series-5d7fabec","name":"Illustration Estimates — Exact Row Deduplication + Base-100 Series","description":"Illustration estimates — Exact row deduplication + Base-100 series: Exact row deduplication + Base-100 series for supplied illustration estimates records (estimated_hours, actual_hours). 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-creative-19-047?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","required":["row_id","asset_group","date","estimated_hours","actual_hours"],"properties":{"date":{"type":"string","default":"","pattern":"^\\d{4}-\\d{2}-\\d{2}$","maxLength":10},"row_id":{"type":"string","default":"","maxLength":80,"minLength":1},"asset_group":{"type":"string","default":"","maxLength":80},"actual_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000},"estimated_hours":{"type":["number","null"],"maximum":1000000000000,"minimum":-1000000000000}},"additionalProperties":false},"default":[{"date":"2026-10-01","row_id":"row-1","asset_group":"group-a","actual_hours":1,"estimated_hours":10},{"date":"2026-10-02","row_id":"row-2","asset_group":"group-b","actual_hours":2,"estimated_hours":20},{"date":"2026-10-03","row_id":"row-3","asset_group":"group-a","actual_hours":3,"estimated_hours":15},{"date":"2026-10-04","row_id":"row-4","asset_group":"group-b","actual_hours":4,"estimated_hours":30}],"maxItems":200,"minItems":1},"field":{"enum":["estimated_hours","actual_hours"],"type":"string","default":"estimated_hours"},"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_4ERWU376VM6rZeGNLcmBp","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 illustration estimate rows and computes a Base-100 indexed time series for estimated_hours or actual_hours across up to 200 supplied records.","exampleAgentPrompt":"Take my illustration estimate records — 4 rows with asset groups 'group-a' and 'group-b', dates from 2026-10-01 to 2026-10-04, and estimated/actual hours — deduplicate them exactly and give me a Base-100 index series on estimated_hours starting from row index 0.","exampleUseCases":[{"title":"Deduplicating animation asset hour logs","prompt":"I have a list of 50 illustration estimate rows for our animation project with asset groups like 'backgrounds' and 'characters' — can you deduplicate them exactly and give me a Base-100 series on estimated_hours starting at index 0?"},{"title":"Indexing actual hours for creative billing review","prompt":"Run a Base-100 series on actual_hours for my 120 illustration estimate records across different asset groups and dates, deduplicating any exact duplicate rows first — set the base index to row 0."},{"title":"Auditing estimate accuracy across asset groups","prompt":"I want to check for duplicate rows in my illustration project time data (about 80 records with estimated and actual hours per asset group) and get a normalized Base-100 index on estimated_hours so I can compare trends across groups — can you run both reports?"}],"resultDescription":"Returns two analytical reports: (1) an exact row deduplication report identifying and removing duplicate records from the supplied illustration estimate rows, and (2) a Base-100 indexed time series for the chosen field (estimated_hours or actual_hours), normalized relative to the row at the specified base_index. Both reports are computed locally from the supplied data with no external lookups.","failureModes":["Fewer than 1 row supplied — minItems:1 validation error","More than 200 rows supplied — maxItems:200 validation error","Invalid date format (not YYYY-MM-DD) — pattern validation failure","Missing required fields (row_id, asset_group, date, estimated_hours, actual_hours) — schema validation error","base_index out of range (0–199) — validation error","Field value not in enum ['estimated_hours','actual_hours'] — validation error","Payment not provided or insufficient — x402 payment required response"],"whenToPreferThis":"Choose this endpoint when you have illustration or creative project time-estimate records (with estimated_hours and actual_hours) and need both exact duplicate row removal and a Base-100 normalized index series in a single low-cost call. It is purpose-built for creative/media asset group time data rather than general-purpose deduplication tools, and handles up to 200 rows for $0.01 USDC with no external data dependencies.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-25T12:33:13.883Z","isFirstParty":false,"canonicalSlug":"illustration-estimates-exact-row-deduplication-base-100-series-5d7fabec"}