{"api":"v1","generated_at":"2026-10-06T04:39:52.029Z","licence":{"name":"CC BY 4.0","url":"https://creativecommons.org/licenses/by/4.0/","attribution":"TOLL, with a link to the page cited"},"page":"https://tollindex.com/e/api-vextorium-com-sql-csv-pago-52edab","pinned_page":"https://tollindex.com/e/api-vextorium-com-sql-csv-pago-52edab/at/2026-10-06T00-02Z","pinned":false,"method":"https://tollindex.com/ledger/method","snapshot_at":"2026-10-06T00:02:10.461Z","snapshot_stamp":"2026-10-06T00-02Z","endpoint":{"slug":"api-vextorium-com-sql-csv-pago-52edab","canonical_url":"https://api.vextorium.com/sql-csv-pago","resource":"https://api.vextorium.com/sql-csv-pago","http_method":"POST","type":"http","x402_version":2,"registries":["cdp"],"primary_registry":"cdp","curated_by_coinbase":false,"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.","service_name":"Vextorium","declared_category":null,"declared_tags":["sql","csv","sqlite","analytics","data"],"route_template":null,"registry_updated":"2026-10-02T19:55:04.756Z"},"derived":{"note":"fields no registry supplies; TOLL derives them and marks them derived on the page","title":"sql csv pago","category":"search","first_observed_by_toll":"2026-10-02T22:12:25.127Z","last_observed_by_toll":"2026-10-06T00:02:10.461Z","observation_began":"2026-09-10"},"presence":{"listed_now":true,"first_absent_at":null,"delisting_confirmed_at":null,"events":[{"registry":"cdp","at":"2026-10-02T22:12:25.128Z","event":"listed"}]},"accepts":[{"registry":"cdp","ordinal":0,"network":"eip155:8453","asset":"0x833589fcd6edb6e08f4c7c32d4f71b54bda02913","asset_name":"USD Coin","symbol":"USDC","decimals":6,"amount_display":"0.004 USDC","amount_units":0.004,"decimals_known":true,"pay_to":"0xb9f06D2734B7E9D7b21B64C4D8b95bd774b71aCf","scheme":"exact"},{"registry":"cdp","ordinal":1,"network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","asset":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v","asset_name":null,"symbol":"USDC","decimals":6,"amount_display":"0.004 USDC","amount_units":0.004,"decimals_known":true,"pay_to":"HcjfmZLgWRZzwj4deEiS7pewc4KBYSw39mW5nTyt3pz2","scheme":"exact"}],"counters":{"observed_at":"2026-10-06T00:02:10.461Z","calls_30d":1,"unique_payers_30d":1,"last_called_at":"2026-10-02T19:55:04.524Z"},"validation":{"latest":{"observed_at":"2026-10-05T07:48:38.747Z","state":"pass","failed_checks":[],"endpoint_http_status":402,"run_id":"daily-2026-10-05"},"uptime":[{"days":7,"observed":4,"passed":4,"ratio":1},{"days":30,"observed":4,"passed":4,"ratio":1},{"days":90,"observed":4,"passed":4,"ratio":1}],"history_90d":[{"observed_at":"2026-10-05T07:48:38.747Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-05","state_changed":false},{"observed_at":"2026-10-04T10:23:55.268Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-04","state_changed":false},{"observed_at":"2026-10-03T05:21:29.441Z","state":"pass","failed_checks":[],"run_id":"daily-2026-10-03","state_changed":false},{"observed_at":"2026-10-02T22:20:38.174Z","state":"pass","failed_checks":[],"run_id":"new-after-daily-2026-10-02","state_changed":true}]},"seller":{"wallet":"0xb9f06D2734B7E9D7b21B64C4D8b95bd774b71aCf","page":"https://tollindex.com/seller/0xb9f06D2734B7E9D7b21B64C4D8b95bd774b71aCf","endpoints":957,"hosts":3},"reports":0,"registry_record":{"cdp":[{"tags":["sql","csv","sqlite","analytics","data"],"type":"http","accepts":[{"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","extra":{"name":"USD Coin","version":"2"},"payTo":"0xb9f06D2734B7E9D7b21B64C4D8b95bd774b71aCf","amount":"4000","scheme":"exact","network":"eip155:8453","maxTimeoutSeconds":300},{"asset":"EPjFWdd5AufqSSqeM2qN1xzybapC8G4wEGGkZwyTDt1v","extra":{"feePayer":"D6ZhtNQ5nT9ZnTHUbqXZsTx5MH2rPFiBBggX4hY1WePM"},"payTo":"HcjfmZLgWRZzwj4deEiS7pewc4KBYSw39mW5nTyt3pz2","amount":"4000","scheme":"exact","network":"solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp","maxTimeoutSeconds":300}],"quality":{"lastCalledAt":"2026-10-02T19:55:04.524Z","l30DaysTotalCalls":1,"l30DaysUniquePayers":1},"resource":"https://api.vextorium.com/sql-csv-pago","extensions":{"bazaar":{"info":{"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"},"type":"http","method":"POST","bodyType":"json"},"output":{"type":"json","example":{"filas":[{"city":"Madrid","total":220},{"city":"Barcelona","total":80}],"tabla":"datos","columnas":["city","total"],"filas_tabla":3,"columnas_tabla":["city","sales"],"filas_devueltas":2}}},"schema":{"type":"object","$schema":"https://json-schema.org/draft/2020-12/schema","required":["input"],"properties":{"input":{"type":"object","required":["type","method","bodyType","body"],"properties":{"body":{"required":["contenido","consulta"],"properties":{"limite":{"type":"integer","description":"Max rows (default 500)"},"consulta":{"type":"string","description":"SELECT over table datos"},"contenido":{"type":"string"},"delimitador":{"type":"string"}}},"type":{"type":"string","const":"http"},"method":{"enum":["POST"],"type":"string"},"bodyType":{"enum":["json","form-data","text"],"type":"string"}},"additionalProperties":false},"output":{"type":"object","required":["type"],"properties":{"type":{"type":"string"},"example":{"type":["object","null"],"properties":{"filas":{"type":["array","null"],"items":{"type":["null","object"],"properties":{"city":{"type":["null","string"]},"total":{"type":["null","number"]}}}},"tabla":{"type":["string","null"]},"columnas":{"type":["array","null"],"items":{"type":["null","string"]}},"filas_tabla":{"type":["number","null"]},"columnas_tabla":{"type":["array","null"],"items":{"type":["null","string"]}},"filas_devueltas":{"type":["number","null"]}}}}}}}}},"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.","lastUpdated":"2026-10-02T19:55:04.756Z","serviceName":"Vextorium","x402Version":2}]}}