{"uid":"cap_o-QJNL2ORnnpsxN6SCOP9","slug":"foundry-csv-datetime-normalization-7728b2e9","name":"Foundry CSV Datetime Normalization","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-datetime-normalization","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","maxLength":12000,"minLength":1},"columns":{"type":"array","items":{"type":"object","required":["name","format"],"properties":{"name":{"type":"string","maxLength":100,"minLength":1},"format":{"enum":["YYYY-MM-DD","DD/MM/YYYY","MM/DD/YYYY","YYYY-MM-DD HH:mm:ss","DD/MM/YYYY HH:mm:ss","MM/DD/YYYY HH:mm:ss"],"type":"string"}},"additionalProperties":false},"maxItems":10,"minItems":1},"utc_offset_minutes":{"type":"integer","maximum":840,"minimum":-840}}},"responseSchema":{"type":"json","example":{"route":"csv-datetime-normalization","result":{"issues":[],"status":"NORMALIZED","row_count":1,"output_csv":"id,when\r\n1,2026-09-05T23:30:00.000Z","limitations":["Synthetic example hash."],"input_sha256":"0000000000000000000000000000000000000000000000000000000000000000","evidence_truncated":false,"invalid_cell_count":0,"normalized_cell_count":1},"observed_at":"2026-09-06T00:00:00Z"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.006","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.006/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.006","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.006","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_mFbOG2R08SyStiOx4dmvI","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.006","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Normalizes date and datetime columns in a CSV to ISO 8601 UTC format, reporting issues and cell-level statistics.","exampleAgentPrompt":"I have a CSV with an 'order_date' column formatted as DD/MM/YYYY and a 'shipped_at' column in MM/DD/YYYY HH:mm:ss — can you normalize both to ISO 8601 UTC, assuming UTC+60 minutes offset?","exampleUseCases":[{"title":"ETL pipeline date standardization","prompt":"I'm loading sales data from a CSV into our data warehouse and the 'sale_date' column uses MM/DD/YYYY format — please normalize it to ISO 8601 UTC so the pipeline doesn't break. The data is in Eastern Time, so use a UTC offset of -300 minutes."},{"title":"Auditing exported report dates","prompt":"I exported a report from our CRM and it has a 'created_on' column in DD/MM/YYYY format. Can you parse and normalize those dates to ISO 8601 UTC and tell me how many cells had issues?"},{"title":"Multi-column datetime cleanup before import","prompt":"This CSV has two datetime columns: 'start_time' in YYYY-MM-DD HH:mm:ss and 'end_time' in DD/MM/YYYY HH:mm:ss, both recorded in UTC+120 — normalize all the datetimes and flag any invalid values."}],"resultDescription":"Returns a JSON object containing: the normalized CSV string with all target columns converted to ISO 8601 UTC format, a list of issues per problematic cell, counts of total rows, normalized cells, and invalid cells, the SHA-256 hash of the input CSV, a status string (e.g. NORMALIZED), a flag indicating whether evidence was truncated, and an observed_at timestamp.","failureModes":["CSV exceeds 12,000 character limit — request rejected","Column name not found in CSV headers — column skipped or error returned","Unrecognized datetime values that don't match declared format — counted as invalid cells","UTC offset outside -840 to +840 range — validation error","Malformed JSON input — 400-level error","More than 10 columns specified — schema validation failure"],"whenToPreferThis":"Choose this endpoint when you need programmatic, pay-per-call CSV datetime normalization with explicit format declarations, ISO 8601 UTC output, per-cell issue reporting, and a SHA-256 input fingerprint for audit provenance — especially inside automated ETL or data-cleaning agent workflows where you want a deterministic, schema-validated result rather than a general-purpose LLM guess at date parsing.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:54:00.521Z","isFirstParty":false}