{"uid":"cap_Z_ddMt0ARJu5aSh95scXH","slug":"api-usage-imports-invalid-row-export-ea6399f3","name":"API Usage Imports — Invalid Row Export","description":"API usage imports — Invalid row export: Invalid row export 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 invalid row export report.","url":"https://market.datapackvibe.com/x402/assistant-bx-csv-api-usage-invalid-rows?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_jns4uTxXjmDS7lEc0vojP","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 CSV of API usage import data and exports a report of all invalid/non-conforming rows, checking up to 1000 rows against declared constraints.","exampleAgentPrompt":"Check this API usage CSV for invalid rows and give me an export of just the bad ones — use a comma delimiter, flag any request_count or error_count below 0 or above 1000000, and only allow categories 'group-a' and 'group-b'.","exampleUseCases":[{"title":"Pre-import data quality gate","prompt":"Before I push this API usage CSV into our data warehouse, run it through the invalid-row validator — comma-delimited, allowed endpoint categories are 'auth', 'search', and 'ingest', and flag any numeric values outside 0 to 500000. Give me back just the rows that fail."},{"title":"Detect bad records after ETL pipeline","prompt":"Our ETL pipeline just produced a usage_imports CSV and I need to find any rows with malformed data — use semicolon as the delimiter, allow categories 'us-east', 'eu-west', and 'ap-south', and reject any request_count above 1000000. Export the invalid rows so I can fix them."},{"title":"QA check on third-party usage data","prompt":"A vendor sent us an API usage CSV and I want to validate it before we process it — comma-delimited, max cell length 500 characters, allowed categories are 'premium' and 'standard', and numeric values should be between -1 and 999999. Export any rows that don't pass."}],"resultDescription":"A report listing all rows from the submitted CSV that fail the declared validation rules, including rows with disallowed category values, numeric values outside the specified min/max range, cells exceeding the max cell length, or other structural issues. Up to 1000 rows are checked per call.","failureModes":["CSV exceeds 100,000 character limit — request rejected","CSV has fewer than 1 row of data — validation cannot proceed","Delimiter mismatch causes all rows to appear malformed","max_cell_length set below actual cell lengths causing false positives","More than 1000 rows submitted — only first 1000 processed","Malformed CSV syntax (unclosed quotes) may cause parse errors"],"whenToPreferThis":"Use this endpoint when you have a CSV of API usage import records and need to identify and export the specific rows that violate declared constraints (value ranges, allowed categories, cell length) before importing or processing the data. Prefer it over generic CSV validators when your data follows the usage_id/observed_on/endpoint_id/request_count/error_count schema and you need a structured invalid-row export rather than just a pass/fail result.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-24T00:55:07.171Z","isFirstParty":false,"canonicalSlug":"api-usage-imports-invalid-row-export-ea6399f3"}