Transformation Studio — IntegrationOS

Expression Editor

Pipeline Preview

Lookup Tables

Schema Validation

Input JSON payload

{
  "orderId": "ORD-2026-001",
  "customerId": "CUST-12345",
  "amount": 1500.00,
  "currency": "EUR",
  "countryCode": "PT",
  "status": "PENDING",
  "orderDate": "2026-02-26",
  "items": [
    { "sku": "PRD-001", "description": "Produto A", "qty": 2, "price": 500.00 },
    { "sku": "PRD-002", "description": "Produto B", "qty": 1, "price": 500.00 }
  ],
  "customer": {
    "name": "Empresa XPTO Lda",
    "email": "geral@xpto.pt",
    "nif": "501234567"
  }
}

Valid JSON

Expression JSONata

{
  "pedidoId": orderId,
  "clienteId": customerId,
  "valorTotal": $sum(items.price),
  "moeda": currency,
  "estado": "Pendente",
  "dataProcessamento": $now(),
  "itens": items.{
    "codigo": sku,
    "descricao": description,
    "quantidade": qty,
    "precoUnitario": price,
    "subtotal": qty * price
  },
  "cliente": {
    "nome": customer.name,
    "nomeUppercase": $uppercase(customer.name),
    "email": customer.email,
    "nif": customer.nif
  }
}

Ready

Output transformed

Waiting...

Pipeline Steps

Run pipeline to see steps.

Step Detail

Input

Output

Lookup Tables

Edit Lookup Table

Select a lookup table to edit.

Input Schema JSON Schema draft-07

{
  "$schema": "http://json-schema.org/draft-07/schema#",
  "type": "object",
  "required": ["orderId", "customerId", "amount"],
  "properties": {
    "orderId": { "type": "string", "minLength": 1 },
    "customerId": { "type": "string" },
    "amount": { "type": "number", "minimum": 0 },
    "currency": { "type": "string", "enum": ["EUR", "USD", "GBP"] }
  }
}

Not validated

Output Schema JSON Schema draft-07

Not validated