{"uid":"cap_IRWpjJCaw1GQF_S9MpCmH","slug":"order-imports-csv-declared-column-projection-validator-718c8a9d","name":"Order Imports CSV Declared Column Projection Validator","description":"Order imports — Declared column projection: Declared column projection for Order 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 declared column projection report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-orders-projection?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","default":"order_id,ordered_on,customer_id,gross_amount,item_count\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_f0ybbtlDzXDf7sUkOfSfD","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 a declared CSV column contract for order import data (up to 1000 rows), checking structure, types, and value constraints without external enrichment.","exampleAgentPrompt":"Can you validate this orders CSV against the declared column contract — it uses a comma delimiter, and customer_id should only be 'group-a' or 'group-b', gross_amount should be between 0 and 50000, and each cell shouldn't exceed 500 characters? Here's the CSV: order_id,ordered_on,customer_id,gross_amount,item_count\\nrecord-a,2026-01-01,group-a,10,2","exampleUseCases":[{"title":"Pre-upload order batch validation","prompt":"Before I push this CSV to our order management system, can you check it against the declared column schema? The file uses comma delimiters, customer_id must be one of 'group-a' or 'group-b', gross_amount should be between 0 and 100000, and no cell should be longer than 1000 characters."},{"title":"E-commerce data pipeline QA check","prompt":"Run a column projection report on this orders export CSV — delimited by semicolons, allowed customer categories are 'retail', 'wholesale', and 'partner', gross_amount must be at least 0 and no more than 999999, max cell length 500. Tell me which rows or columns fail the declared contract."},{"title":"Marketplace seller order import compliance","prompt":"I have a seller's order import file in CSV format and need to verify it matches our declared schema — comma-separated, only 'group-a' and 'group-b' are valid customer_id values, item_count and gross_amount must be non-negative, and cells can't exceed 200 characters. Can you validate it and give me the projection report?"}],"resultDescription":"Returns a declared column projection report covering schema compliance, per-column type and constraint checks, category membership validation, numeric range adherence, and cell-length violations — up to 1000 rows, with no external data enrichment applied.","failureModes":["CSV exceeds 100,000 character limit — request rejected","More than 1000 rows submitted — only first 1000 processed or error returned","Invalid delimiter specified outside allowed enum (',', ';', tab) — validation error","Cell values exceed max_cell_length — flagged as violations","Malformed CSV that cannot be parsed — parse error returned","allowed_categories list exceeds 100 items — schema rejection","minimum value greater than maximum value — constraint conflict error"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, fast, contract-first validation of an order import CSV — specifically when the columns are known (order_id, ordered_on, customer_id, gross_amount, item_count), you want to enforce category allowlists and numeric bounds, and you do not need external data enrichment or transformation. Ideal for pre-upload QA in order ingestion pipelines where schema compliance must be confirmed cheaply ($0.01 USDC) before committing data downstream.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-15T18:48:52.304Z","isFirstParty":false,"canonicalSlug":"order-imports-csv-declared-column-projection-validator-718c8a9d"}