{"uid":"cap_-EDBW-JpSSL7BFSnOGXjn","slug":"foundry-csv-ingestion-contract-1b56ecc5","name":"Foundry CSV Ingestion Contract","description":"Pay-per-request evidence and data tools: CSV validation and reconciliation, DNS/email configuration evidence, and bounded official weather, earthquake, vehicle, company and study records. Exact USDC prices, explicit JSON contracts and source provenance. No mailbox, ownership, medical or safety guarantees.","url":"https://foundry-par007-machine-revenue-mainnet.inference-chip-index.workers.dev/v2/data/csv-ingestion-contract","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":24000,"minLength":1},"columns":{"type":"array","items":{"type":"object","required":["source","target","type","nullable","trim"],"properties":{"trim":{"type":"boolean","default":false},"type":{"enum":["string","number","integer","boolean"],"type":"string"},"source":{"type":"string","maxLength":100,"minLength":1},"target":{"type":"string","maxLength":100,"minLength":1},"nullable":{"type":"boolean","default":false}},"additionalProperties":false},"maxItems":25,"minItems":1}}},"responseSchema":{"type":"json","example":{"route":"csv-ingestion-contract-packet","result":{"data":[{"name":"Ada","points":10},{"name":"Lin","points":12}],"issues":[],"status":"TRANSFORMED","columns":["name","points"],"row_count":2,"issue_count":0,"limitations":["Synthetic example hash only."],"input_sha256":"0000000000000000000000000000000000000000000000000000000000000000","issues_truncated":false},"observed_at":"2026-09-06T00:00:00Z"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.015","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.015/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.015","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.015","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_MeMwGKrYRp6Ml_lrCtLBT","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.015","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Validates, transforms, and reconciles a bounded CSV against a caller-supplied column contract, returning typed row data, issue counts, and provenance hash.","exampleAgentPrompt":"Can you validate this CSV against my column contract — map 'Name' (string, not nullable, trim) and 'Score' (integer, not nullable) — and tell me how many rows are clean, any issues found, and give me the input hash? Here's the CSV: Name,Score\\nAda,10\\nLin,12","exampleUseCases":[{"title":"Pre-pipeline CSV quality gate","prompt":"Before I load this sales data CSV into our database, validate it against these columns: 'customer_id' (integer, not nullable), 'email' (string, not nullable, trim), 'revenue' (number, nullable) — and tell me exactly which rows have issues and the SHA-256 of what I submitted."},{"title":"Rename and type-cast uploaded report columns","prompt":"I have a CSV export from our old system with headers 'Cust Name' and 'Rev USD' — can you map 'Cust Name' to 'customer_name' (string, trim, not nullable) and 'Rev USD' to 'revenue' (number, nullable), validate all the rows, and return the cleaned data as JSON?"},{"title":"Audit partner data submission for null violations","prompt":"Our partner sent us this CSV and I need to check that none of the 'partner_id' (integer, not nullable) or 'transaction_date' (string, not nullable, trim) fields are blank or wrong type — run it through the ingestion contract and show me the issue count and any flagged rows."}],"resultDescription":"Returns a JSON object with: the transformed row data as an array of typed objects, a list of per-row issues (truncated flag included), overall status (e.g. TRANSFORMED), column names, row count, issue count, SHA-256 hash of the input CSV, and a limitations array noting any synthetic or provenance caveats.","failureModes":["CSV exceeds 24,000 character limit — request rejected","Column definition missing required fields (source, target, type, nullable, trim) — schema validation error","More than 25 columns specified — rejected by maxItems constraint","Malformed CSV that cannot be parsed — issues array populated, status may indicate failure","Empty CSV string — rejected by minLength constraint","Type mismatch on a non-nullable column — issues recorded in response"],"whenToPreferThis":"Choose this endpoint when you need deterministic, contract-driven CSV validation and transformation with explicit JSON output, per-row issue reporting, and cryptographic input provenance (SHA-256) — especially when you need typed coercion (string/number/integer/boolean), null-checking, and column renaming in a single pay-per-request call. Prefer it over generic CSV parsers when you need an auditable, structured result with a clear issue count and source hash, and when the CSV fits within 24,000 characters and 25 columns.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T18:38:37.476Z","isFirstParty":false}