{"uid":"cap_xytufUQkDuSRmSbGXQaTy","slug":"vextorium-csv-sql-query-650c82c9","name":"Vextorium CSV-SQL Query","description":"244 pay-per-call data APIs for AI agents: official statistics and economy (ECB, Fed, Eurostat, World Bank, SEC, BOE, INE), crypto prices and sentiment, Spanish public data, compliance (sanctions, VAT, IBAN, LEI), science, weather, web and developer tools and local AI text tools. Pay in USDC via x402.","url":"https://api.vextorium.com/v1/csv-sql?utm_source=zero.xyz","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"limit":{"type":"integer","description":"Max rows (default 500)"},"query":{"type":"string","description":"SELECT over table datos"},"content":{"type":"string"},"delimiter":{"type":"string"}}},"responseSchema":{"type":"json","example":{"rows":[{"city":"Madrid","total":220},{"city":"Barcelona","total":80}],"table":"datos","columns":["city","total"],"table_rows":3,"returned_rows":2,"table_columns":["city","sales"]}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.004","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.004/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.004","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_YLh6HZH5UPdTAP7iQAhWx","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.004","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Accepts CSV content and a SQL SELECT query, executes the query over the CSV data, and returns the filtered/aggregated rows as structured JSON.","exampleAgentPrompt":"I have a CSV with columns city and sales — can you run 'SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC' on it and give me up to 100 rows?","exampleUseCases":[{"title":"Summarize sales by region from CSV","prompt":"I have a CSV of sales records with columns region, product, and amount. Run this query on it: SELECT region, SUM(amount) AS total_sales FROM datos GROUP BY region ORDER BY total_sales DESC — limit to 50 rows."},{"title":"Filter CSV rows by condition","prompt":"Here's a CSV of customer data with columns name, age, and country. Give me only the rows where country is 'Germany' and age is over 30, using SQL on the data — return up to 200 rows."},{"title":"Count distinct values in CSV column","prompt":"I have a comma-separated dataset with columns product_id, category, and price. Run SELECT category, COUNT(*) AS count FROM datos GROUP BY category on it and return all results."}],"resultDescription":"A JSON object containing the query result rows as an array of objects, the list of returned column names, the table name ('datos'), the total number of rows in the CSV, and the number of rows returned by the query.","failureModes":["Invalid SQL syntax returns an error response","CSV content that cannot be parsed (wrong delimiter) causes a parse failure","Query referencing columns not in the CSV fails with a column-not-found error","Very large CSV content may time out or be truncated","Exceeding the row limit silently caps results at the specified maximum"],"whenToPreferThis":"Use this endpoint when you have raw CSV data in memory and need to run ad-hoc SQL queries (filtering, aggregation, projection) without setting up a database. Ideal for one-off analytical queries on tabular datasets, especially inside agent workflows where structured JSON output is needed and the data changes each call.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-10-28T18:45:29.063Z","isFirstParty":false,"canonicalSlug":"vextorium-csv-sql-query-650c82c9"}