pentaho - 将 PDI 响应转换为确定的结构

问题描述

我是 PDI 的新手，我正在从 API 中恢复信息，我需要转换特定结构的信息，我不清楚如何使用连接或其他转换来实现。

这是我的回答：

[
  {
    "457": {
      "1": {
        "value": "4.1",
        "timestamp": 1534159593
      },
      "2": {
        "value": "52.2",
        "timestamp": 1534159593
      },
      "3": {
        "value": "23.0",
        "timestamp": 1534159593
      },
      "4": {
        "value": "250.0",
        "timestamp": 1534159593
      }
    }
  }
]

我需要保留这种类型的东西，通过 POST 将其发送到另一个 API

{
  "id": "457",
  "type": "greenhouse",
  "1": {
    "value": 4.1,
    "type": "Float",
    "timestamp": 1534159593
  },
  "2": {
    "value": 52.2,
    "type": "Integer",
    "timestamp": 1534159593
  },
  "3": {
    "value": 23.0,
    "type": "Integer",
    "timestamp": 1534159593
  },
  "4": {
    "value": 250.0,
    "type": "Integer",
    "timestamp": 1534159593
  }
}

谢谢您的帮助。

编辑01

再次呼啦，

我按照你说的做，我有问题。

这是我的代码：

// Script here

var data = data2;
var tests = data;


var tests3 = {"457": {"2": {"value": "54.0", "timestamp": 1534246741}, "3": {"value": "22.2", "timestamp": 1534246741}, " 4 ": {" value ":" 260.0 "," timestamp ": 1534246741}," 21 ": {" value ":" 890.0 "," timestamp ": 1534246741}," 1 ": {" value ":" 4.13 "," timestamp ": 1534246741}," 17 ": {" value ":" 194.04687499999997 "," timestamp ": 1534246741}," 5 ": {" value ":" 35.417 "," timestamp ": 1534246741}," 6 ": {" value ":" 26.299999999999997 "," timestamp ": 1534246741}," 8 ": {" value ":" 4.7 "," timestamp ": 1534246741}," 15 ": {" value ":" 0.78 "," timestamp ": 1534246741}," 10 ": {" value ":" 24.94 "," timestamp ": 1534246741}," 22 ": {" value ":" 0.0 "," timestamp ": 1534246741}," 23 ": {" value ":" 0.0 "," timestamp ": 1534246741}," 24 ": {" value ":" 0.0 "," timestamp ": 1534246741}," 26 ": {" value ":" 0.0 "," timestamp ": 1534246741}," 653 ": {" value ":" 0.0 "," timestamp ": 1534246741}," 657 ": {" value ":" - 98.0 "," timestamp ": 1518420299}, "43": {"value": "11.892947103200001", "timestamp": 1534246741}, "42": {"value": "403.61749999999995", "timestamp": 1534246741}}};

var key = Object.keys (data) [0];
var finalobj = {};
for (var and in data [key]) {
    finalobj [e] = {
        type: "float"
        , value: parseFloat (data [key] [e] .value)
        , metadata: {
            timestamp: {
                value: parseInt (data [key] [e] .timestamp)
                , type: "Integer"
            }
        }
    };
}

 var JsonOutput = JSON.stringify (finalobj);

变量data2是具有我的JSON的那个实际上是与tests3相同的信息，如果代码有效，但如果我一步将数据放入tests3，我不明白，因为数据具有相同的值并且必须工作并且JsonOutput 的响应是 {} 但如果它工作正常，我会使用 tests3 来执行此操作。

看起来它是在检索变量时，但随后我显示它具有数据和数据 2，并且与测试 3 的信息相同，我不明白会发生什么。

你能帮助我吗？

标签： pentahopentaho-spoonpentaho-data-integration

pentaho - 将 PDI 响应转换为确定的结构

问题描述

解决方案

推荐阅读