Transform JSON records or CSV uploads with typed schemas and Polars SQL

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.

Paid test badge: not yet. The checks above are free: we call the tool without paying and read the payment request it sends back. The Verified badge needs paid calls whose answers match the promised output, and nobody can buy a badge.

Endpoint

POST https://ultra-endpoints.com/transform

Our checks, last 30 days

Example input (from the provider)

{
  "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"
}

Promised output schema (from the provider)

{
  "$defs": {
    "ColumnSpec": {
      "additionalProperties": false,
      "description": "Jedna kolumna schematu albo jedno pole wewn\u0105trz 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\u015bciu albo wyj\u015bciu pipeline'u.",
      "items": {
        "$ref": "#/$defs/ColumnSpec"
      },
      "title": "DataSchema",
      "type": "array"
    },
    "ExecutionLimits": {
      "additionalProperties": false,
      "description": "Maksymalna d\u0142ugo\u015b\u0107 SQL i liczba zapyta\u0144 w jednym \u017c\u0105daniu.",
      "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\u0142na 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"
          },
 

This page as JSON