Operations (sample payloads)

Main operations

Transform JSON

Transform some JSON using JSONata. Sample Input

{
    "data": {
        "employees": [
            \{
                "name": "John Doe",
                "age": 30,
                "department": "Sales",
                "salary": 50000
            \},
            \{
                "name": "Jane Smith",
                "age": 35,
                "department": "Marketing",
                "salary": 60000
            \},
            \{
                "name": "Bob Johnson",
                "age": 28,
                "department": "IT",
                "salary": 55000
            \}
        ]
    },
    "query": "employees.\{\"name\": name, \"annualSalary\": salary * 12\}"
}

Sample Output

{
    "result": [
        \{
            "name": "John Doe",
            "annualSalary": 600000
        \},
        \{
            "name": "Jane Smith",
            "annualSalary": 720000
        \},
        \{
            "name": "Bob Johnson",
            "annualSalary": 660000
        \}
    ]
}