Skip to main content
Input Value 
{
  "uId" : null,
  "data" : [
    {
      "id" : 2,
      "version" : 16,
      "code" : "234500001",
      "currency" : {
        "code" : "TL",
      },
      "detail" : "XXX,YYY",
      "matGroup" : {
        "id" : 676,
        "name" : "YYY",
        "otherName" : "YYY"
      },
      "matNsnCode" : null,
      "matType" : {
        "id" : 2,
        "name" : "ZZZ",
        "otherName" : "ZZZ"
      },
      "name" : "YYY / AAA",
      "prodUnit" : {
        "id" : 4,
        "otherName" : "BBB"
      },
      "matCategory" : "CCC",
      "materialCodeName" : "234500001 YYY",
      "materialUnit" : "BBB"
    }
  ],
  "total" : 11940
}
JOLT Transformation Code
This example converts nested data to a flat structure and assigns new field names. The first shift operation restructures the data, the second default operation fills missing fields with default values.
[
  {
    "operation": "shift",
    "spec": {
      "data": {
        "*": {
          "id": "data[#2].mat_id",
          "code": "data[#2].mat_code",
          "currency": {
            "code": "data[#3].mat_currency"
          },
          "detail": "data[#2].detail",
          "matGroup": {
            "id": "data[#3].matGroup_id",
            "name": "data[#3].matGroup_name"
          },
          "matNsnCode": "data[#2].matNsnCode",
          "matType": {
            "id": "data[#3].matType_id",
            "name": "data[#3].matType_name"
          },
          "prodUnit": {
            "otherName": "data[#3].prodUnit_otherName"
          },
          "matCategory": "data[#2].matCategory",
          "materialCodeName": "data[#2].mat_codeName",
          "materialUnit": "data[#2].matUnit",
          "contactInfo": {
            "email": "data[#3].source"
          }
        }
      }
    }
  },
  {
    "operation": "default",
    "spec": {
      "data[]": {
        "*": {
          "mat_id": null,
          "mat_code": null,
          "mat_currency": null,
          "detail": null,
          "matGroup_id": null,
          "matGroup_name": null,
          "matNsnCode": null,
          "matType_id": null,
          "matType_name": null,
          "prodUnit_otherName": null,
          "matCategory": null,
          "mat_codeName": null,
          "matUnit": null,
          "source": "SEM"
        }
      }
    }
  }
]
Output Value 
{
  "data" : [
    {
      "mat_id" : 2,
      "mat_code" : "234500001",
      "mat_currency" : "TL",
      "detail" : "XXX,YYY",
      "matGroup_id" : 676,
      "matGroup_name" : " YYY",
      "matNsnCode" : null,
      "matType_id" : 2,
      "matType_name" : "ZZZ",
      "prodUnit_otherName" : "BBB",
      "matCategory" : "CCC",
      "mat_codeName" : "YYY / AAA",
      "matUnit" : "BBB",
      "source" : "SEM"
    }
  ]
}