{"uid":"cap_0PyIjWlLu35tzL-It2qkU","slug":"csv-required-columns-check-db95bf46","name":"CSV Required Columns Check","description":"CSV Required Columns Check: CSV Required Columns Check checks a CSV header for required column names from bounded caller-supplied values without an external provider. Call CSV Required Columns Check before an agent hands structured data or a batch plan to a downstream tool with a stricter contract. Returns the bounded transformation or validation finding with counts, normalized values, and a versioned result contract for CSV Required Columns Check as versioned deterministic JSON. Price: $0.001…","url":"https://api.delx.ai/api/v1/x402/csv-required-columns-check","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"text":{"type":"string","maxLength":8192,"description":"Text supplied to CSV Required Columns Check; used only for this bounded calculation and processed in memory without retention."},"required_columns":{"type":"array","items":{"type":"string","maxLength":8192},"maxItems":256,"description":"Required Columns supplied to CSV Required Columns Check; used only for this bounded calculation and processed in memory without retention."}}},"responseSchema":{"type":"json","example":{"result":{"passed":true,"missing_columns":[]},"schema":"delx/util-csv-required-columns-check/v1","status":"pass","evidence":{"retained":false,"input_sha256":"775c5abb7e34060297d8b70ad6cc76e9040bb7f6113985a9158905cc7bcafa42","external_calls":0},"operation":"data_batch:csv_required_columns_check"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.001","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.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_FOK4KvU8Y_cmi3MzDPKhU","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Validates that a CSV header contains all specified required column names, returning counts and normalized findings as versioned deterministic JSON.","exampleAgentPrompt":"Before handing this CSV off to the next step, check that it has all the required columns — 'user_id', 'email', 'created_at', and 'status' — and tell me which ones are missing if any.","exampleUseCases":[{"title":"Preflight check before ETL pipeline","prompt":"I'm about to push this CSV into our data warehouse loader. Check that it has all the required columns: 'order_id', 'customer_id', 'amount', 'currency', and 'timestamp' — let me know if anything is missing before I proceed."},{"title":"Validate user-uploaded CSV file","prompt":"A user just uploaded a CSV and I need to make sure it has the columns 'first_name', 'last_name', 'email', and 'phone' before I import it into the CRM. Can you run a required columns check on this header row and report what's present or missing?"},{"title":"Batch plan schema compliance check","prompt":"Before I send this batch instruction CSV to the downstream fulfillment tool, verify it includes all the mandatory columns: 'sku', 'quantity', 'warehouse_code', and 'ship_date'. Show me the counts and flag anything that's absent."}],"resultDescription":"Returns a versioned deterministic JSON object containing: a pass/fail validation result, counts of required vs present columns, a list of missing column names, a list of found column names, and normalized values — all under a versioned result contract.","failureModes":["Malformed or empty CSV text may result in no header being parsed, returning all columns as missing","Required columns list is empty — may return trivially passing result with no meaningful validation","Column name matching may be case-sensitive, causing false negatives if header uses different casing","Input exceeds maxLength (8192 chars) causing rejection","required_columns array exceeds 256 items causing rejection","Whitespace or delimiter inconsistencies in the CSV header may cause column names to not match expected values"],"whenToPreferThis":"Use this endpoint when an agent needs to programmatically verify that a CSV header satisfies a known contract before passing data to a downstream tool, ETL pipeline, or API with strict schema requirements. Prefer it over manual inspection when the required column list is explicit and deterministic validation with a structured, versioned JSON result is needed. It is especially useful as a preflight gate in agentic workflows where failing early on missing columns prevents costly downstream errors.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T07:04:56.392Z","isFirstParty":false}