{"uid":"cap_0adWLjR7hbupcHRmHGEs4","slug":"decision-data-studio-csv-cleanup-03a70c55","name":"Decision Data Studio CSV Cleanup","description":"Local-first data and agent workflow tools from Decision Data Studio, plus verified EU tender shortlists and machine-callable utilities.","url":"https://api.ikoles.dev/v1/csv-cleanup","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"rows":{"type":"array","items":{"type":"object","additionalProperties":{"type":["string","number","boolean","null"]}},"maxItems":500,"minItems":1},"keyColumns":{"type":"array","items":{"type":"string"},"maxItems":25,"minItems":1},"trimStrings":{"type":"boolean","default":true},"dropBlankRows":{"type":"boolean","default":true},"caseInsensitiveKeys":{"type":"boolean","default":true}}},"responseSchema":{"type":"json","example":{"status":"accepted"}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"2","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":"$2/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"2","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"2","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_c8VVcVFoH71z_MmXT2yes","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"2","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Cleans and normalizes tabular CSV row data by trimming strings, dropping blank rows, and standardizing column keys","exampleAgentPrompt":"Can you clean up these 200 rows of procurement export data — trim all the string fields, drop any blank rows, and normalize the column names case-insensitively, treating 'supplier_id' and 'contract_value' as the key columns?","exampleUseCases":[{"title":"Pre-processing EU tender export data","prompt":"I just exported a CSV of EU tender records and it's got trailing spaces everywhere, some blank rows, and inconsistent column casing — can you clean it up using 'tender_id' and 'authority_name' as the key columns before I run analysis on it?"},{"title":"Normalizing supplier data before database insert","prompt":"Before we insert these 350 supplier rows into the database, can you trim all the string fields, drop blank rows, and make all the column keys case-insensitive? The key columns are 'supplier_id' and 'country_code'."},{"title":"Standardizing procurement records for agent pipeline","prompt":"My agent pipeline is choking on messy column headers and whitespace in this batch of 120 procurement rows — run them through the CSV cleanup with 'contract_ref' as the key column and drop anything that's blank."}],"resultDescription":"A JSON response with a status field (e.g. 'accepted') confirming the cleanup job was received and processed. The cleaned rows are returned with trimmed strings, blank rows removed, and column keys normalized according to the specified options.","failureModes":["Rows array is empty or exceeds 500 items — returns validation error","keyColumns array is empty or exceeds 25 entries — returns schema error","Malformed row objects with non-primitive values — may cause processing failure","Payment not completed — returns HTTP 402 before processing begins","Network timeout if payload is near the 500-row limit"],"whenToPreferThis":"Choose this endpoint when you need a lightweight, paid-per-call data normalization step for tabular rows — especially when preparing procurement or tender CSV exports for downstream agent pipelines. Prefer it over custom preprocessing code when you want consistent, reproducible string trimming, blank-row removal, and case-insensitive key normalization in a single call without managing infrastructure.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T06:39:50.476Z","isFirstParty":false}