Json 用于遮蔽卡的 Jolt 规格

发布于01月12日

如何遍历列表并替换其中的一些元素？我有这样的输入

{
  "clients": [
    {
      "clientId": "166734",
      "info": {
        "cards": [
          "378282246310005",
          "371449635398431"
        ]
      }
    }
  ]
}

我所期望的卡片会是这样的100

但在我的规范中，子字符串不起作用

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "clients": {
        "*": {
          "info": {
            "cards": {
              "*": "=substring(@(1,&),0,@(1,4))"
            }
          }
        }
      }
    }
  }
]

推荐答案

您可以使用shift个转换来驯服卡片数组，以便为modify个转换规范做准备，例如

[
  {
    "operation": "shift",
    "spec": {
      "clients": {
        "*": {
          "*": "&2[#2].&",
          "info": {
            "cards": {
              "*": {
                "@": "&5[#5].&3.&2.&"
              }
            }
          }
        }
      }
    }
  },
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "clients": {
        "*": {
          "info": {
            "cards": {
              "*": "=substring(@(1,&),0,4)"
            }
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "clients": {
        "*": {
          "*": "&2[#2].&",
          "info": {
            "cards": {
              "*": "&4[#4].&2.&1[#1]"
            }
          }
        }
      }
    }
  }
]

如果101总是只能有两个组件，那么我们可以通过使用102个函数来缩短整个规范，否则可以通过单独编写以下代码来使用100

[
  {
    "operation": "modify-overwrite-beta",
    "spec": {
      "clients": {
        "*": {
          "info": {
            "c0": "=firstElement(@(1,cards))", //or "=(@(1,cards[0]))"
            "c1": "=lastElement(@(1,cards))",  //or "=(@(1,cards[1]))"
            "cards0": "=substring(@(1,c0),0,4)",
            "cards1": "=substring(@(1,c1),0,4)"
          }
        }
      }
    }
  },
  {
    "operation": "shift",
    "spec": {
      "clients": {
        "*": {
          "*": "&2[#2].&",
          "info": {
            "*s*": "&3[#3].&1.&(0,1)s"
          }
        }
      }
    }
  }
]