{"slug":"api-vextorium-com-sql-csv-pago-94ba46","title":"Run a read-only SQL query (SELECT/WITH, WHERE, GROUP BY, ORDER BY, window functi","host":"api.vextorium.com","method":"POST","resource":"https://api.vextorium.com/sql-csv-pago","category":"other","description":"Run a read-only SQL query (SELECT/WITH, WHERE, GROUP BY, ORDER BY, window functions...) over a CSV loaded as table «datos» in a temporary in-memory SQLite database, and get the rows as JSON.","price_listed":0.004,"price_asked":0.004,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":317,"reported_calls_30d":1,"reported_payers_30d":1,"networks":["eip155:8453","solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"consulta":"SELECT city, SUM(sales) AS total FROM datos GROUP BY city ORDER BY total DESC","contenido":"city,sales\nMadrid,100\nBarcelona,80\nMadrid,120"},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"properties":{"consulta":{"description":"SELECT over table datos","type":"string"},"contenido":{"type":"string"},"delimitador":{"type":"string"},"limite":{"description":"Max rows (default 500)","type":"integer"}},"required":["contenido","consulta"]},"bodyType":{"enum":["json","form-data","text"],"type":"string"},"method":{"enum":["POST"],"type":"string"},"type":{"const":"http","type":"string"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"properties":{"columnas":{"items":{"type":["null","string"]},"type":["array","null"]},"columnas_tabla":{"items":{"type":["null","string"]},"type":["array","null"]},"filas":{"items":{"properties":{"city":{"type":["null","string"]},"total":{"type":["null","number"]}},"type":["null","object"]},"type":["array","null"]},"filas_devueltas":{"type":["number","null"]},"filas_tabla":{"type":["number","null"]},"tabla":{"type":["string","null"]}},"type":["object","null"]},"type":{"type":"string"}},"required":["type"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-10-03","reachable":true,"status":402,"valid_402":true,"asked_usdc":0.004,"price_match":true,"latency_ms":317,"error":null}],"description_full":"Run a read-only SQL query (SELECT/WITH, WHERE, GROUP BY, ORDER BY, window functions...) over a CSV loaded as table «datos» in a temporary in-memory SQLite database, and get the rows as JSON.","last_updated":"2026-10-02T19:55:04.756Z","schemes":["exact"]}