如何使用JOLT转换将数组作为值的json对象flattent

hjqgdpho 于 2023-06-25 发布在其他

关注(0)|答案(1)|浏览(170)

我有一个JSON对象，格式如下：

{
  "$type": "api.something, api.somethingElse",
  "fromApi": {
    "$type": "api.something, api.somethingElse",
    "Id": "d1537a72-2e46-29c0-b119-2bac07857ka9",
    "ItemId": "d1537a72-2e46-29c0-b119-2bac07869t8",
    "Amount": 50,
    "Increased": 10,
    "Type": "increasment",
    "SourceData": "{\"isIncreasment\":true,\"ItemId\":\"d1258672-3592-29c0-b119-2bac07857ka9\",\"testID\":105,\"ListId\":18576}",
    "Date": "2023-06-12T13:47:57.66"
  }
}

我希望通过JOLT转换将其转换为扁平格式，如下所示：

{
  "type" : "api.something, api.somethingElse",
  "Id" : "d1537a72-2e46-29c0-b119-2bac07857ka9",
  "ItemId" : "a1537a72-2e46-29c0-b119-2bac07869t8",
  "Amount" : 50,
  "Increased" : 10,
  "Type" : "increasment",
  "isIncreasment" : "true",
  "ItemId" : "d1258672-3592-29c0-b119-2bac07857ka9",
  "testID" : 105,
  "ListId" : 18576,
  "Date": "2023-06-15T13:47:57.66"
}

这是可能的吗？如何做到？

JSON

来源：https://stackoverflow.com/questions/76482981/how-to-flattend-json-object-that-has-an-array-as-a-value-with-jolt-transformatio

1条答案

按热度按时间

2wnc66cl1#

没有直接的替换函数，但可以通过在modify转换中使用连续的***split***和***join***函数来模拟，例如

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "fromApi": {
        "sd0": "=split('\"',@(1,SourceData))",
        "sd1": "=join('',@(1,sd0))",
        "sd2": "=split('\\{',@(1,sd1))",
        "sd3": "=join('',@(1,sd2))",
        "sd4": "=split('\\}',@(1,sd3))",
        "sd5": "=join('',@(1,sd4))",
        "SourceData": "=split(',',@(1,sd5))"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "fromApi": {
        "\\$type": "others.type",
        "ItemId": "others.ItemId_old", // need to rename, otherwise will yield an array with 
                                       // two components as an object might not have two attributes 
                                       // with the common names
        "*": "others.&",
        "sd*":"sd.&",
        "SourceData": {
          "*": {
            "*:*": { // separate the keys and values
              "#k": "&2.&(1,1)", // piece extracted from "*:*" representation after reaching 1 upper level, till ":", eg. 1st asterisk
              "#v": "&2.&(1,2)"  // piece extracted from "*:*" representation after reaching 1 upper level, till ":", eg. 2nd asterisk
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "$": "&2.@0" // exchange keys vs. values
        }
      },
      "others": {
        "*": "&1.&"
      },
      "sd*": {
        "*": "&1.&"
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "others": {
        "*": "&"
      },
      "*": {
        "@v": "@k" // match derived keys and values as pairs
      }
    }
  }
]

赞(0）回复(0）举报 2023-06-25

我来回答

如何使用JOLT转换将数组作为值的json对象flattent

1条答案

相关问题

热门标签

最新问答