{"uid":"cap_9e4ItljPf1iiNsDBBLcsr","slug":"illustration-estimates-string-normalisation-numeric-interval-filter-eed429a8","name":"Illustration Estimates — String Normalisation + Numeric Interval Filter","description":"Illustration estimates — String normalisation + Numeric interval filter: String normalisation + Numeric interval filter 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-026?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"},"maximum":{"type":"number","default":100,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":0,"maximum":1000000000000,"minimum":-1000000000000}}},"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_E57l_oAVlNGeUqrekKLRW","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":"Normalises string fields and filters illustration estimate records (estimated_hours, actual_hours) by a numeric interval, returning up to 2 analytical reports for up to 200 rows.","exampleAgentPrompt":"Can you run a string normalisation and numeric interval filter on my illustration estimates data? I have rows with asset_group, date, estimated_hours, and actual_hours — filter on estimated_hours between 5 and 50 hours, and send up to 4 rows including row-1 in group-a on 2026-10-01 with 10 estimated and 1 actual hour.","exampleUseCases":[{"title":"Filter overestimated illustration tasks","prompt":"I have my illustration project time logs and want to find all rows where estimated_hours falls between 8 and 40 — can you normalise the string fields and give me a filtered report? Here are my rows: row-1, group-a, 2026-10-01, estimated 10, actual 1; row-2, group-b, 2026-10-02, estimated 45, actual 2."},{"title":"Audit actual hours within target range","prompt":"Run a string normalisation and interval filter report on my illustration estimates — I want to check actual_hours between 0 and 5 across these records: row-1 group-a 2026-10-01 estimated 10 actual 1, row-2 group-b 2026-10-02 estimated 20 actual 6, row-3 group-a 2026-10-03 estimated 15 actual 3."},{"title":"Clean asset group labels and range-check hours","prompt":"My illustration data has messy asset_group strings and I need to normalise them, then filter to rows where estimated_hours is between 10 and 30. Can you process these 4 rows: row-1 'Group A' 2026-10-01 est 10 act 1, row-2 'group_b' 2026-10-02 est 25 act 2, row-3 'GROUP-A' 2026-10-03 est 15 act 3, row-4 'Group B' 2026-10-04 est 30 act 4?"}],"resultDescription":"Returns up to 2 analytical reports: one covering string-normalised fields (e.g. standardised asset_group values) and one covering records filtered to rows where the selected numeric field (estimated_hours or actual_hours) falls within the specified minimum–maximum interval, across up to 200 input rows.","failureModes":["Input array is empty or missing required fields (row_id, date, estimated_hours, actual_hours) — validation error","Date strings not matching YYYY-MM-DD pattern — schema rejection","minimum greater than maximum — may return zero matching rows","More than 200 rows submitted — request rejected or truncated","Non-numeric values in estimated_hours or actual_hours — schema validation failure","Payment not fulfilled — x402 payment required error"],"whenToPreferThis":"Choose this endpoint when you have illustration project time-tracking records and need both string normalisation of categorical fields (like asset_group) and numeric range filtering on hour fields (estimated_hours or actual_hours) in a single call. It is best suited for local, offline analytical processing of supplied data without any external lookups or live data fetches. Prefer it over general data tools when working specifically with creative/illustration estimate datasets up to 200 rows and needing two bundled reports at low cost.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-11-02T12:41:14.261Z","isFirstParty":false,"canonicalSlug":"illustration-estimates-string-normalisation-numeric-interval-filter-eed429a8"}