{"slug":"ultra-endpoints-com-transform-20d41c","title":"Transform JSON records or CSV uploads with typed schemas and Polars SQL","host":"ultra-endpoints.com","method":"POST","resource":"https://ultra-endpoints.com/transform","category":"other","description":"Transform JSON records or CSV uploads with typed schemas and Polars SQL. Filter, aggregate, join and reshape data. Pricing depends on input size and SQL statement count; the 402 response contains the exact USDC amount.","price_listed":null,"price_asked":null,"state":"answering","state_label":"Answering","checks_7d":1,"answered_7d":1,"latency_ms_median":876,"reported_calls_30d":1,"reported_payers_30d":1,"networks":["solana:5eykt4UsFv8P8NJdTREpY1vzqKqZKvdp"],"badge":"unverified","paid_checks_7d":0,"paid_ok_7d":0,"example_input":{"body":{"config":{"input_schema":[{"dtype":{"type":"Int64"},"name":"id","nullable":false}],"instructions":"SELECT id + 1 AS id FROM data;","output_schema":[{"dtype":{"type":"Int64"},"name":"id","nullable":false}]},"data":[{"id":1}]},"bodyType":"json","method":"POST","type":"http"},"output_schema":{"$defs":{"ColumnSpec":{"additionalProperties":false,"description":"Jedna kolumna schematu albo jedno pole wewnątrz typu ``Struct``.","properties":{"dtype":{"$ref":"#/$defs/DTypeSpec"},"name":{"maxLength":128,"minLength":1,"title":"Name","type":"string"},"nullable":{"title":"Nullable","type":"boolean"}},"required":["name","dtype","nullable"],"title":"ColumnSpec","type":"object"},"DTypeSpec":{"additionalProperties":false,"description":"Typ kolumny zapisany w schemacie, np. ``Int64`` albo ``List``.","properties":{"fields":{"anyOf":[{"items":{"$ref":"#/$defs/ColumnSpec"},"type":"array"},{"type":"null"}],"default":null,"title":"Fields"},"inner":{"anyOf":[{"$ref":"#/$defs/DTypeSpec"},{"type":"null"}],"default":null},"precision":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null,"title":"Precision"},"scale":{"anyOf":[{"type":"integer"},{"type":"null"}],"default":null,"title":"Scale"},"time_unit":{"anyOf":[{"enum":["ms","us","ns"],"type":"string"},{"type":"null"}],"default":null,"title":"Time Unit"},"time_zone":{"anyOf":[{"type":"string"},{"type":"null"}],"default":null,"title":"Time Zone"},"type":{"enum":["Boolean","Int8","Int16","Int32","Int64","Float32","Float64","Decimal","String","Date","Datetime","List","Struct"],"title":"Type","type":"string"}},"required":["type"],"title":"DTypeSpec","type":"object"},"DataSchema":{"description":"Lista kolumn wymaganych na wejściu albo wyjściu pipeline'u.","items":{"$ref":"#/$defs/ColumnSpec"},"title":"DataSchema","type":"array"},"ExecutionLimits":{"additionalProperties":false,"description":"Maksymalna długość SQL i liczba zapytań w jednym żądaniu.","properties":{"max_instruction_length":{"default":65536,"exclusiveMinimum":0,"title":"Max Instruction Length","type":"integer"},"max_statements":{"default":30,"exclusiveMinimum":0,"maximum":30,"title":"Max Statements","type":"integer"}},"title":"ExecutionLimits","type":"object"},"JsonValue":{},"PipelineConfig":{"additionalProperties":false,"description":"Pełna konfiguracja pojedynczego uruchomienia transformacji.","properties":{"input_schema":{"$ref":"#/$defs/DataSchema"},"instructions":{"description":"Polars SQL statements separated by semicolons. Each statement reads the previous result from table data; the final result is returned. Empty SQL preserves the input.","examples":["SELECT price * quantity AS total FROM data; SELECT total FROM data;"],"title":"Instructions","type":"string"},"limits":{"$ref":"#/$defs/ExecutionLimits"},"output_schema":{"$ref":"#/$defs/DataSchema"}},"required":["input_schema","instructions","output_schema"],"title":"PipelineConfig","type":"object"}},"$schema":"https://json-schema.org/draft/2020-12/schema","properties":{"input":{"additionalProperties":false,"properties":{"body":{"additionalProperties":false,"properties":{"config":{"$ref":"#/$defs/PipelineConfig"},"data":{"items":{"additionalProperties":{"$ref":"#/$defs/JsonValue"},"type":"object"},"title":"Data","type":"array"}},"required":["data","config"],"title":"TransformRequest","type":"object"},"bodyType":{"const":"json"},"method":{"const":"POST"},"type":{"const":"http"}},"required":["type","method","bodyType","body"],"type":"object"},"output":{"properties":{"example":{"items":{"type":"object"},"type":"array"},"type":{"const":"json"}},"required":["type","example"],"type":"object"}},"required":["input"],"type":"object"},"history":[{"day":"2026-10-19","reachable":true,"status":402,"valid_402":true,"asked_usdc":null,"price_match":null,"latency_ms":876,"error":null}],"description_full":"Transform JSON records or CSV uploads with typed schemas and Polars SQL. Filter, aggregate, join and reshape data. Pricing depends on input size and SQL statement count; the 402 response contains the exact USDC amount.","last_updated":"2026-10-18T22:45:06.698Z","schemes":["exact"]}