{"uid":"cap_UpPXmDRNmvzOYWs_GyYZq","slug":"api-usage-imports-csv-trimmed-typed-conversion-40a44bd2","name":"API Usage Imports CSV Trimmed Typed Conversion","description":"API usage imports — Trimmed typed conversion: Trimmed typed conversion for API usage 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 trimmed typed conversion report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-api-usage-normalise?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"csv":{"type":"string","default":"usage_id,observed_on,endpoint_id,request_count,error_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_cWwUMgl6FMyhww36DP89C","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 and normalizes an API usage imports CSV table by trimming whitespace and applying typed conversion to up to 1000 rows.","exampleAgentPrompt":"Can you validate and normalize this API usage imports CSV — it has columns usage_id, observed_on, endpoint_id, request_count, and error_count — using a comma delimiter, allowing categories group-a and group-b, with values between 0 and 1000000?","exampleUseCases":[{"title":"Pre-import API usage data validation","prompt":"Before I load this API usage CSV into our data warehouse, can you run a trimmed typed conversion check on it? It has usage_id, observed_on, endpoint_id, request_count, and error_count columns, comma-delimited, and I only want to allow endpoint categories group-a and group-b."},{"title":"Catching type errors in usage logs","prompt":"I exported our API usage logs as a CSV and I'm worried some numeric fields like request_count and error_count might have bad values or whitespace issues — can you validate and type-convert it with a minimum of 0 and maximum of 50000?"},{"title":"Normalizing partner-submitted usage reports","prompt":"A partner sent us their API usage report as a semicolon-delimited CSV with up to 500 rows. Can you trim and type-convert it, restricting allowed categories to tier-1 and tier-2, so we can safely process it?"}],"resultDescription":"Returns a trimmed typed conversion report for the submitted API usage CSV, confirming validity of up to 1000 rows including quoted cells, with type-checked and whitespace-trimmed values for fields like usage_id, observed_on, endpoint_id, request_count, and error_count, along with any validation errors found.","failureModes":["CSV exceeds 1000 rows — only up to 1000 rows are supported","CSV string is empty or missing — minLength of 1 required","Cell value exceeds max_cell_length limit — default 1000 characters per cell","Numeric values outside specified minimum/maximum bounds — validation error returned","Category values not in allowed_categories list — flagged as invalid","Invalid delimiter specified — only comma, semicolon, or tab accepted","Malformed CSV structure — unbalanced quotes or mismatched column counts"],"whenToPreferThis":"Choose this endpoint when you need to validate and type-normalize a CSV specifically structured for API usage imports (with fields like usage_id, observed_on, endpoint_id, request_count, error_count) and want trimmed, typed output with category allowlist enforcement. Prefer it over generic CSV validators when the domain is API usage data and you need the specialized preset handling for this schema contract.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:54:50.414Z","isFirstParty":false,"canonicalSlug":"api-usage-imports-csv-trimmed-typed-conversion-40a44bd2"}