{"uid":"cap_wJbICbtNimpVv6b8t2vkr","slug":"machine-utilisation-imports-trimmed-typed-conversion-a10d85f7","name":"Machine Utilisation Imports — Trimmed Typed Conversion","description":"Machine utilisation imports — Trimmed typed conversion: Trimmed typed conversion for Machine utilisation imports. Validate a declared CSV table contract, up to 1000 rows. Quoted cells supported; no external enrichment. Specialised preset in a shared 50-profile, 20-operation engine. 0.01 USDC includes one CSV trimmed typed conversion report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-machines-normalise?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","default":"observation_id,observed_on,machine_id,running_hours,scheduled_hours\nrecord-a,2026-01-01,group-a,10,2\nrecord-b,2026-01-02,group-b,20,3","maxLength":100000,"minLength":1},"maximum":{"type":"number","default":1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"minimum":{"type":"number","default":-1000000000000,"maximum":1000000000000,"minimum":-1000000000000},"delimiter":{"enum":[",",";","\t"],"type":"string","default":","},"max_cell_length":{"type":"integer","default":1000,"maximum":5000,"minimum":1},"allowed_categories":{"type":"array","items":{"type":"string","default":"","maxLength":100,"minLength":1},"default":["group-a","group-b"],"maxItems":100,"minItems":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_gSPRYomH-47Y1t65lxX1Q","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":"Validates and normalises a machine utilisation CSV (observation ID, dates, machine IDs, hours) into trimmed, typed output — up to 1000 rows, quoted cells supported.","exampleAgentPrompt":"Can you validate and normalise this machine utilisation CSV for me? It has columns observation_id, observed_on, machine_id, running_hours, and scheduled_hours, with comma delimiters, and the allowed machine categories are group-a and group-b — I want a trimmed typed conversion report back.","exampleUseCases":[{"title":"Factory floor hours import validation","prompt":"I have a CSV export from our factory floor system with columns observation_id, observed_on, machine_id, running_hours, and scheduled_hours — can you validate and normalise it using comma as the delimiter, allow only category IDs line-a and line-b, and flag any cells that are out of range or malformed?"},{"title":"Scheduled vs running hours compliance check","prompt":"Please run a trimmed typed conversion on this machine utilisation CSV I'm about to paste — columns are observation_id, observed_on, machine_id, running_hours, scheduled_hours — comma-delimited, max cell length 500, and only allow machine categories grp-01 and grp-02."},{"title":"Data pipeline pre-load normalisation","prompt":"Before we load this machine utilisation data into our database, can you parse and type-check this CSV with observation_id, observed_on, machine_id, running_hours, scheduled_hours columns, using tab as the delimiter, and ensure running_hours and scheduled_hours stay between 0 and 24?"}],"resultDescription":"A trimmed typed conversion report covering up to 1000 rows of the submitted machine utilisation CSV — each cell parsed, whitespace-trimmed, and type-validated. The report identifies malformed fields, out-of-range numeric values, disallowed category strings, and produces a clean, typed row-level summary ready for downstream processing.","failureModes":["CSV exceeds 100,000 character limit — request rejected","More than 1000 rows submitted — validation may be truncated or refused","Invalid delimiter value outside allowed enum (',', ';', tab) — schema error","Cell value exceeds max_cell_length — flagged or rejected","Numeric value outside configured minimum/maximum bounds — validation failure","Category value not in allowed_categories list — row flagged as invalid","Malformed quoted cells that break CSV parsing — parse error returned","Empty CSV body submitted — minimum length violation"],"whenToPreferThis":"Choose this endpoint when you need to validate and normalise machine utilisation CSV imports (with observation IDs, machine IDs, running hours, and scheduled hours) and want typed, trimmed output with configurable category allowlists and numeric bounds — particularly for pre-load data quality checks in manufacturing or industrial pipelines. Prefer it over generic CSV tools when the schema matches machine utilisation records specifically.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:48:14.088Z","isFirstParty":false,"canonicalSlug":"machine-utilisation-imports-trimmed-typed-conversion-a10d85f7"}