Json Jolt 如何比较 if else 条件的两个值

发布于07月14日

我必须在Jolt中进行转换，条件是如果name和displayName中的值相同，则输出应将标志值displayOnUI设置为true，否则false

输入:

[
  {
    "name": "Mike Ellis",
    "email": "mike@gmail.com",
    "displayName": "MikeE"
  },
  {
    "name": "Sam Perry",
    "email": "samperry@gmail.com",
    "displayName": "Sam Perry"
  }
]

预期输出:

[
  {
    "name": "Mike Ellis",
    "email": "mike@gmail.com",
    "displayName": "MikeE",
    "displayOnUi": false
  },
  {
    "name": "Sam Perry",
    "email": "samperry@gmail.com",
    "displayName": "Sam Perry",
    "displayOnUi": true
  }
]

我试图进行转换，但无法获得正确的输出.有人能帮帮忙吗.谢谢.

推荐答案

您可以通过使用以下转换来判断属性的比较是形成数组(在本例中只生成1个元素)还是单个属性(在本例中只生成2个元素nested within the new object called Count)，例如

[
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*ame": "Cnt[&1].Count.@0"
      },
      "@": "Original" // replicate the initial JSON value
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "Cnt": {
        "*": {
          "Count": "=size(@(1,&))"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "*": {
          "Count": "&1",
          "*": "&1.&"
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "*": {
        "1": { // stands for the second component to compare
          "1": { // keep the values are equal
            "@(2,[0])": "[&3]",
            "#true": "[&3].displayOnUi"
          },
          "2": { // keep the values are UNequal
            "@(2,[0])": "[&3]",
            "#false": "[&3].displayOnUi"
          }
        }
      }
    }
  }
]

现场http://jolt-demo.appspot.com/上的101个是: