Dashboard
Transformation Studio
JSONata · Schema Validation · Lookup Tables
Expression ready
Run Preview
Save Rule
Expression Editor
Pipeline Preview
Lookup Tables
Schema Validation
Rules
Add
Select an integration to load rules.
Integration
Select...
Input
JSON payload
Example
Format
{ "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
Validate
{ "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
Copy
→ Use as Input
Waiting...
Pipeline Steps
Run
Run pipeline to see steps.
Step Detail
Input
Output
Lookup Tables
New
Loading...
Edit Lookup Table
Select a lookup table to edit.
Input Schema
JSON Schema draft-07
Example
Validate
{ "$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
Example
Validate
Not validated
New Transformation Rule
Name *
Type *
JSONata (avançado)
Field Map (simples)
Condition
Lookup
Validate Only
Execution Order
Expression *
Stop on Error
Yes (recommended)
No (continue)
Enabled
Yes
No
Description
New Lookup Table
Name *
Source *
Static (JSON)
HTTP API
Database
Config *
Cache TTL (seconds)