apache-nifi - NiFi中的EvaluateJsonPath返回空字符串

Question

ExecuteSqlRecord 的输出被馈送到 EvaluateJsonPath 并返回空字符串。输出ExecuteSqlRecord：

[
  {
    "X_LAST_DAY": "1618459200000",
    "X_FIRST_DAY_3MON_PREV": "1610427600000",
    "X_FIRST_DAY_1MON_PREV": "1615525200000",
    "X_LAST_DAY_1MON_PREV": "1617163200000"
  }
]

The attribute values are coming as 'Empty String Set'. Why is it coming as empty and what am I doing wrong?
In the EvaluateJsonPath, I have also tried different options like setting the following.
Return Type - auto-detect
Null Value Representation - empty string

标签： apache-nifi

Answer 1

您的数据是数组，应该拆分。SplitJson之前使用EvaluateJsonPath