{"uid":"cap_PeQTtIxLs9JBQGLQmQE3O","slug":"402utils-csv-profiler-5eaf76da","name":"402utils CSV Profiler","description":"Profile a CSV before processing it: send the bytes directly or a JSON body with a public {url}. Returns per-column name, inferred type (string/int/float/bool/date/mixed), null and unique counts, min/max and samples, plus row count, detected delimiter and data-quality issues (malformed rows, inconsistent widths, duplicate headers). Query: delimiter (, ; tab |), header=false if row one is data. Max 10 MB.","url":"https://402utils.com/v1/csv-profile?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"url":{"type":"string","format":"uri","description":"Public http(s) URL of a CSV (alternative to sending bytes)."}}},"responseSchema":{"type":"json","example":{"issues":[{"rows":[17],"type":"inconsistent_columns","count":1,"message":"1 row(s) do not have the header's 2 column(s)"}],"columns":[{"max":"2026-07-01","min":"2026-06-01","name":"date","samples":["2026-06-01"],"nullCount":0,"uniqueCount":31,"inferredType":"date"},{"max":1999.99,"min":-420.5,"name":"amount","samples":["19.99"],"nullCount":2,"uniqueCount":118,"inferredType":"float"}],"rowCount":120,"delimiter":","}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.003","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":{"p10Cents":"0.3000","medianCents":"0.3000","p90Cents":"0.3000","minCents":"0.3000","maxCents":"0.3000","p95Cents":"0.3000","sampleCount":1,"varies":false,"failureChargeRate":1},"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.003/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.003","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_WJHfqqxE9bXperp51msTP","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.003","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Profiles a CSV file to return per-column statistics, inferred types, null/unique counts, and data-quality issues before processing","exampleAgentPrompt":"Before I load this CSV into the database, can you profile it for me? Here's the public URL: https://data.example.com/customers.csv — use a comma delimiter and treat the first row as a header, then tell me the column types, any nulls, and any data-quality problems.","exampleUseCases":null,"resultDescription":"Returns a JSON object with per-column metadata (name, inferred type, null count, unique count, min, max, sample values), overall row count, detected delimiter, and a list of data-quality issues such as malformed rows, inconsistent column widths, and duplicate headers.","failureModes":["File exceeds 10 MB limit — returns an error indicating size constraint","Inaccessible or private URL — returns a fetch/network error","Unparseable file (not valid CSV) — returns a parsing error","Unrecognized delimiter causes column misalignment — returns garbled or single-column profile","Timeout fetching remote URL — returns a timeout error"],"whenToPreferThis":"Use this endpoint when you need to understand the structure, types, and quality of a CSV before ingesting, transforming, or storing it. It is ideal as a pre-processing step in ETL pipelines, data validation workflows, or whenever you want to detect issues like malformed rows or duplicate headers without writing custom parsing code. Prefer this over manual inspection or general-purpose code execution when you want fast, structured column-level statistics with no setup.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-12T06:39:50.571Z","isFirstParty":false,"canonicalSlug":"402utils-csv-profiler-5eaf76da"}