Extracting Data from Specified Field and Changing Related Field's Key Expression

You can extract data from a specific field within nested JSON structure and change this field’s key expression. This page includes an example of extracting nested arrays and renaming using shift operation.

Input Value

{
  "statusCode": 200,
  "statusDescription": "OK",
  "numRows": 0,
  "data": [
    {
      "CUR_X_MIKTARLARI": {
        "rowDataList": [
          {
            "KURUM_ID": "123",
            "KURUM_ADI": "aaa",
            "TOPLAM": 645
          },
          {
            "KURUM_ID": "124",
            "KURUM_ADI": "bbb",
            "TOPLAM": 645
          },
          {
            "KURUM_ID": "125",
            "KURUM_ADI": "ccc",
            "TOPLAM": 645
          }
        ],
        "columnNames": [
          "KURUM_ID",
          "KURUM_ADI",
          "TOPLAM"
        ],
        "numRows": 3
      }
    }
  ],
  "result": [],
  "elapsedTime": 4,
  "errors": []
}

JOLT Transformation Code

This example extracts the rowDataList array within CUR_X_MIKTARLARI and renames it as ModifiedList.

[
  {
    "operation": "shift",
    "spec": {
      "data": {
        "*": {
          "CUR_X_MIKTARLARI": {
            "rowDataList": "ModifiedList"
          }
        }
      }
    }
  }
]

Output Value

{
  "ModifiedList" : [
    {
      "KURUM_ID" : "123",
      "KURUM_ADI" : "aaa",
      "TOPLAM" : 645
    },
    {
      "KURUM_ID" : "124",
      "KURUM_ADI" : "bbb",
      "TOPLAM" : 645
    },
    {
      "KURUM_ID" : "125",
      "KURUM_ADI" : "ccc",
      "TOPLAM" : 645
    }
  ]
}