[
{
"id": "6dd63ebd.bf044",
"type": "tab",
"label": "Append",
"disabled": false,
"info": ""
},
{
"id": "11cc261f.ec82da",
"type": "tab",
"label": "Data Analysis",
"disabled": false,
"info": ""
},
{
"id": "cf595649.931658",
"type": "tab",
"label": "Data Analysis - Real time",
"disabled": false,
"info": ""
},
{
"id": "43a74ee3902ea5d5",
"type": "tab",
"label": "filesystem",
"disabled": false,
"info": "",
"env": []
},
{
"id": "955f4808.fd1898",
"type": "tab",
"label": "Host Available",
"disabled": false,
"info": ""
},
{
"id": "cf804fb2.6df8c",
"type": "tab",
"label": "Load Injector",
"disabled": false,
"info": ""
},
{
"id": "1be03be45284f9d4",
"type": "tab",
"label": "load injector",
"disabled": false,
"info": "",
"env": []
},
{
"id": "ae9957f07bd56e1b",
"type": "tab",
"label": "Matrix",
"disabled": false,
"info": "",
"env": []
},
{
"id": "fcc005d5.131ee8",
"type": "tab",
"label": "Monitor",
"disabled": false,
"info": ""
},
{
"id": "0ff935c8a42f26ae",
"type": "tab",
"label": "Monitory System",
"disabled": false,
"info": "",
"env": []
},
{
"id": "fa243279.4dbe9",
"type": "tab",
"label": "os (nodejs)",
"disabled": false,
"info": "Calls to require('os') of node.js "
},
{
"id": "22109ce1.cdbde4",
"type": "tab",
"label": "Spawn Process",
"disabled": false,
"info": ""
},
{
"id": "e4973c86.37d63",
"type": "tab",
"label": "Test",
"disabled": false,
"info": ""
},
{
"id": "d9c7ae0e.cb9a9",
"type": "tab",
"label": "Transform",
"disabled": false,
"info": ""
},
{
"id": "5866424ac23291eb",
"type": "tab",
"label": "transform array",
"disabled": false,
"info": "",
"env": []
},
{
"id": "1374c39ae82adb4e",
"type": "tab",
"label": "transform date",
"disabled": false,
"info": "",
"env": []
},
{
"id": "65b5beda2b73b7b5",
"type": "tab",
"label": "transform compression",
"disabled": false,
"info": "",
"env": []
},
{
"id": "e45553957f2b6fab",
"type": "tab",
"label": "transform json",
"disabled": false,
"info": "",
"env": []
},
{
"id": "460ae66eec4b7f8a",
"type": "tab",
"label": "transform string",
"disabled": false,
"info": "",
"env": []
},
{
"id": "924bb2b7.03fd1",
"type": "tab",
"label": "transform xlsx",
"disabled": false,
"info": ""
},
{
"id": "d98540e8ed31a4a1",
"type": "tab",
"label": "logistic Regression",
"disabled": false,
"info": "",
"env": []
},
{
"id": "8aa8799ad5afca2b",
"type": "tab",
"label": "Columnar store",
"disabled": false,
"info": "",
"env": []
},
{
"id": "680198a3be420949",
"type": "group",
"z": "1374c39ae82adb4e",
"name": "date is between",
"style": {
"label": true
},
"nodes": [
"49b2ad130416e0a0",
"8623ee29d4c12529",
"d6dab95d41cd38af",
"c81d74aeb883cd43",
"94c3bd1cdaed91d7"
],
"x": 144,
"y": -1,
"w": 762,
"h": 142
},
{
"id": "68a2c0f4427ce400",
"type": "group",
"z": "1374c39ae82adb4e",
"name": "Range Limit",
"style": {
"label": true
},
"nodes": [
"4f6a21107d3e15fe",
"7fdb40764c01f99a",
"2b4dc03c0cb6ea2b",
"06787d2f44f5d979",
"e36d78184f2c0e34",
"b9d724057624e971"
],
"x": 944,
"y": -1,
"w": 902,
"h": 142
},
{
"id": "a761e268.19bc7",
"type": "append",
"z": "6dd63ebd.bf044",
"name": "append",
"files": [
{
"value": "./testData.txt",
"type": "require"
},
{
"value": "********",
"type": "text"
}
],
"x": 300,
"y": 140,
"wires": [
[
"65aa2f4d.847f9"
]
]
},
{
"id": "64beb83a.018ed8",
"type": "inject",
"z": "6dd63ebd.bf044",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "str",
"x": 110,
"y": 140,
"wires": [
[
"a761e268.19bc7"
]
]
},
{
"id": "65aa2f4d.847f9",
"type": "debug",
"z": "6dd63ebd.bf044",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"x": 520,
"y": 140,
"wires": []
},
{
"id": "c549c07b.bc4b9",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "max",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 610,
"y": 40,
"wires": []
},
{
"id": "fe98fb5d.1e1d28",
"type": "inject",
"z": "11cc261f.ec82da",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "error input",
"payload": "",
"payloadType": "date",
"x": 160,
"y": 40,
"wires": [
[
"cc146f9a.2d96"
]
]
},
{
"id": "1e28144c.d43d5c",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "avg",
"action": "avg",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 390,
"y": 100,
"wires": [
[
"f90f769f.41f3b8",
"77385484.cf760c"
],
[]
]
},
{
"id": "f2dfe624.ec12e8",
"type": "inject",
"z": "11cc261f.ec82da",
"name": "[1,2,3,4,5]",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[1,2,3,4,5]",
"payloadType": "json",
"x": 120,
"y": 140,
"wires": [
[
"cc146f9a.2d96"
]
]
},
{
"id": "7a6e792d.b98b88",
"type": "inject",
"z": "11cc261f.ec82da",
"name": "[]",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[]",
"payloadType": "json",
"x": 110,
"y": 80,
"wires": [
[
"cc146f9a.2d96"
]
]
},
{
"id": "7a86c3e4.f3aa8c",
"type": "inject",
"z": "11cc261f.ec82da",
"name": "[1,2,3,4,5,6]",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[1,2,3,4,5,6]",
"payloadType": "json",
"x": 130,
"y": 200,
"wires": [
[
"cc146f9a.2d96"
]
]
},
{
"id": "cc146f9a.2d96",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "max",
"action": "max",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 390,
"y": 40,
"wires": [
[
"c549c07b.bc4b9",
"1e28144c.d43d5c"
],
[]
]
},
{
"id": "f90f769f.41f3b8",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "avg",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 610,
"y": 100,
"wires": []
},
{
"id": "77385484.cf760c",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "min",
"action": "min",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 390,
"y": 160,
"wires": [
[
"bc1f7e64.94177",
"ca5f5c59.94cd4"
],
[]
]
},
{
"id": "bc1f7e64.94177",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "median",
"action": "median",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 400,
"y": 220,
"wires": [
[
"31efbbf6.5ff994",
"e27973fe.8fcd9"
],
[]
]
},
{
"id": "31efbbf6.5ff994",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "range",
"action": "range",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 390,
"y": 280,
"wires": [
[
"d71f02b6.07e4a",
"ae37030c.743a"
],
[]
]
},
{
"id": "d71f02b6.07e4a",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "sum",
"action": "sum",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 390,
"y": 340,
"wires": [
[
"5d469222.b4431c",
"8d6da6fc.ab2f48"
],
[]
]
},
{
"id": "ca5f5c59.94cd4",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "min",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 610,
"y": 160,
"wires": []
},
{
"id": "e27973fe.8fcd9",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "median",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 620,
"y": 220,
"wires": []
},
{
"id": "ae37030c.743a",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "range",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 610,
"y": 260,
"wires": []
},
{
"id": "5d469222.b4431c",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "sum",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 610,
"y": 300,
"wires": []
},
{
"id": "8d6da6fc.ab2f48",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "variance",
"action": "variance",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 400,
"y": 400,
"wires": [
[
"80a318a1.8fe578",
"e2cf5bf2.9c23e8"
],
[]
]
},
{
"id": "80a318a1.8fe578",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "stdDev",
"action": "stdDev",
"outputs": 3,
"term": "3",
"keyProperty": "",
"dataProperty": "",
"dataProperties": [],
"x": 400,
"y": 460,
"wires": [
[
"9b53372d.9fcc28",
"e26ac738.0ac368"
],
[],
[]
]
},
{
"id": "9b53372d.9fcc28",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "skew",
"action": "skew",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 390,
"y": 520,
"wires": [
[
"838e4106.d42d1",
"3b9f8cb5.bad514"
],
[]
]
},
{
"id": "e2cf5bf2.9c23e8",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "variance",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 620,
"y": 340,
"wires": []
},
{
"id": "e26ac738.0ac368",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "stdDev",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 620,
"y": 380,
"wires": []
},
{
"id": "838e4106.d42d1",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "skew",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 630,
"y": 520,
"wires": []
},
{
"id": "3b9f8cb5.bad514",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "movingAvgCumulative",
"action": "movingAvgCumulative",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 420,
"y": 580,
"wires": [
[
"ac835c8.491cba",
"64eb625e.2303fc"
],
[]
]
},
{
"id": "ac835c8.491cba",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "movingAvgCumulative",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 660,
"y": 580,
"wires": []
},
{
"id": "40e08530.b2fc2c",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "movingAvgSimple",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 650,
"y": 620,
"wires": []
},
{
"id": "64eb625e.2303fc",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "movingAvgSimple",
"action": "movingAvgSimple",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 410,
"y": 640,
"wires": [
[
"40e08530.b2fc2c",
"c37806d2.a5c5f8"
],
[]
]
},
{
"id": "96fa5b66.4c61b8",
"type": "inject",
"z": "11cc261f.ec82da",
"name": "[1]",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[1]",
"payloadType": "json",
"x": 110,
"y": 260,
"wires": [
[
"cc146f9a.2d96"
]
]
},
{
"id": "3cb6979e.12f878",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "movingAvgExponential",
"action": "movingAvgExponential",
"outputs": 2,
"outliersStdDevs": "3",
"term": "0.5",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 420,
"y": 760,
"wires": [
[
"8ce2398a.805488",
"b13dd76e.d59c48"
],
[]
]
},
{
"id": "c37806d2.a5c5f8",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "movingAvgWeighted",
"action": "movingAvgWeighted",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 420,
"y": 700,
"wires": [
[
"3cb6979e.12f878",
"8a9c80eb.1a406"
],
[]
]
},
{
"id": "8a9c80eb.1a406",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "movingAvgWeighted",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 680,
"y": 700,
"wires": []
},
{
"id": "8ce2398a.805488",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "movingAvgExponential",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 680,
"y": 760,
"wires": []
},
{
"id": "b13dd76e.d59c48",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "deltas",
"action": "deltas",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 370,
"y": 820,
"wires": [
[
"8706b576.2b83e8",
"853dbd38.70d92"
],
[]
]
},
{
"id": "8706b576.2b83e8",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "deltas",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 630,
"y": 820,
"wires": []
},
{
"id": "3b8b4e1c.24e322",
"type": "inject",
"z": "11cc261f.ec82da",
"name": "[8,4,5,3,2,1]",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[8,4,5,3,2,1]",
"payloadType": "json",
"x": 130,
"y": 320,
"wires": [
[
"cc146f9a.2d96"
]
]
},
{
"id": "254df734.5b5628",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "deltaNormalised",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 640,
"y": 880,
"wires": []
},
{
"id": "853dbd38.70d92",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "deltaNormalised",
"action": "deltaNormalised",
"columns": "",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 400,
"y": 880,
"wires": [
[
"254df734.5b5628",
"369bed28.8f2102"
],
[]
]
},
{
"id": "6b313397.1721dc",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "normalise",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 620,
"y": 940,
"wires": []
},
{
"id": "ce485240.bb0fa",
"type": "debug",
"z": "11cc261f.ec82da",
"name": "standardization",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 640,
"y": 1000,
"wires": []
},
{
"id": "369bed28.8f2102",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "normalise",
"action": "normalize",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 380,
"y": 940,
"wires": [
[
"6b313397.1721dc",
"b9c0be7.93f5b4"
],
[]
]
},
{
"id": "b9c0be7.93f5b4",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "standardization",
"action": "standardize",
"columns": "",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [],
"x": 400,
"y": 1000,
"wires": [
[
"ce485240.bb0fa",
"1ffd982aa6657013"
],
[]
]
},
{
"id": "1dd23162.47096f",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "",
"action": "min",
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload.data",
"dataProperties": [],
"x": 1140,
"y": 40,
"wires": [
[
"89fa71fb.d157d"
],
[]
]
},
{
"id": "89fa71fb.d157d",
"type": "test",
"z": "11cc261f.ec82da",
"name": "",
"payload": "{\"data\":[1,2,3]}",
"payloadType": "json",
"result": "1",
"resultType": "num",
"resultProperty": "msg.result",
"topic": "",
"x": 870,
"y": 40,
"wires": [
[
"1dd23162.47096f"
],
[],
[]
]
},
{
"id": "1ffd982aa6657013",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "difference",
"action": "difference",
"columns": "",
"outputs": 2,
"outliersBase": "avg",
"outliersStdDevs": "3",
"term": "10",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [
"msg.payload[0]",
"msg.payload[1]"
],
"x": 380,
"y": 1060,
"wires": [
[
"41453a54a3914a81"
],
[]
]
},
{
"id": "41453a54a3914a81",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "difference seasonal",
"action": "differenceSeasonal",
"columns": "",
"lag": "2",
"outputs": 2,
"outliersBase": "avg",
"outliersStdDevs": "3",
"term": "10",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [
"msg.payload[0]",
"msg.payload[1]"
],
"x": 410,
"y": 1120,
"wires": [
[
"25c998531bce6e6b"
],
[]
]
},
{
"id": "25c998531bce6e6b",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "diifference second order",
"action": "differenceSecondOrder",
"columns": "",
"lag": "1",
"outputs": 2,
"outliersBase": "avg",
"outliersStdDevs": "3",
"term": "10",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [
"msg.payload[0]",
"msg.payload[1]"
],
"x": 430,
"y": 1180,
"wires": [
[
"3b47871eb15d2f72"
],
[]
]
},
{
"id": "3b47871eb15d2f72",
"type": "Data Analysis",
"z": "11cc261f.ec82da",
"name": "difference seasonal second order",
"action": "differenceSeasonalSecondOrder",
"columns": "",
"lag": "2",
"outputs": 2,
"outliersBase": "avg",
"outliersStdDevs": "3",
"term": "10",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [
"msg.payload[0]",
"msg.payload[1]"
],
"x": 460,
"y": 1240,
"wires": [
[],
[]
]
},
{
"id": "a749368e.985a18",
"type": "Data Analysis",
"z": "cf595649.931658",
"name": "",
"action": "realtime",
"columns": "",
"lag": "5",
"outputs": 3,
"outliersBase": "avg",
"outliersStdDevs": "2",
"term": "3",
"keyProperty": "msg.payload.assignedColor",
"dataProperty": "msg.payload.salary",
"dataProperties": [],
"x": 437,
"y": 80,
"wires": [
[],
[
"a6cd6306.a217c"
],
[
"a37e4b57.2a7778"
]
]
},
{
"id": "a6cd6306.a217c",
"type": "debug",
"z": "cf595649.931658",
"name": "realtime",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "result",
"targetType": "msg",
"x": 680,
"y": 120,
"wires": []
},
{
"id": "62f3c2c7.8c3b7c",
"type": "inject",
"z": "cf595649.931658",
"name": "@stats",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "@stats",
"payload": "",
"payloadType": "date",
"x": 150,
"y": 200,
"wires": [
[
"a749368e.985a18",
"770e1ad6.5fe4f4"
]
]
},
{
"id": "7f16af76.d1c2b",
"type": "Load Injector",
"z": "cf595649.931658",
"name": "",
"thinktimemin": "10",
"thinktimemax": "100",
"runtime": "60",
"payload": "",
"payloadType": "date",
"topic": "",
"topicType": "str",
"x": 150,
"y": 40,
"wires": [
[
"82a035c7.eb2198"
],
[]
]
},
{
"id": "770e1ad6.5fe4f4",
"type": "Data Analysis",
"z": "cf595649.931658",
"name": "",
"action": "pearsonR",
"columns": "",
"lag": 1,
"outputs": 2,
"outliersStdDevs": "3",
"term": "3",
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [
"msg.payload.salary",
"msg.payload.age",
"msg.payload.height"
],
"x": 430,
"y": 160,
"wires": [
[],
[
"a6cd6306.a217c"
]
]
},
{
"id": "a37e4b57.2a7778",
"type": "debug",
"z": "cf595649.931658",
"name": "outlier",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"x": 670,
"y": 200,
"wires": []
},
{
"id": "65bd1564.34a0cc",
"type": "inject",
"z": "cf595649.931658",
"name": "outiler",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "{\"name\":\"test outlier \",\"work\":\"outlier\",\"email\":\"{{email}}\",\"address\":\"{{int 1 100}} {{street}}\",\"country\":\"{{country}}\",\"salary\":700,\"assignedColor\":\"red\",\"age\":69,\"height\":2.6}",
"payloadType": "json",
"x": 130,
"y": 280,
"wires": [
[
"a749368e.985a18"
]
]
},
{
"id": "82a035c7.eb2198",
"type": "data-generator",
"z": "cf595649.931658",
"name": "",
"field": "payload",
"fieldType": "msg",
"syntax": "json",
"template": "{\n \"name\": \"{{firstName}} {{lastName}}\",\n \"work\": \"{{company}}\",\n \"email\": \"{{email}}\",\n \"address\": \"{{int 1 100}} {{street}}\",\n \"country\": \"{{country}}\",\n \"salary\": {{float 50 150 '0.00'}},\n \"assignedColor\":\"{{color}}\",\n \"age\": {{int 16 67 '0'}},\n \"height\": {{float 1.5 2.5 '0.0'}}\n}",
"x": 160,
"y": 120,
"wires": [
[
"a749368e.985a18",
"770e1ad6.5fe4f4"
]
]
},
{
"id": "b7da7a9e30699c6f",
"type": "Data Analysis",
"z": "cf595649.931658",
"name": "",
"action": "autocorrelation",
"columns": "",
"lag": 1,
"outputs": 2,
"outliersBase": "avg",
"outliersStdDevs": "3",
"term": 10,
"keyProperty": "msg.topic",
"dataProperty": "msg.payload",
"dataProperties": [
"msg.payload[0]",
"msg.payload[1]"
],
"x": 520,
"y": 420,
"wires": [
[
"542b732966669deb"
],
[]
]
},
{
"id": "114d327f05e06720",
"type": "test",
"z": "cf595649.931658",
"name": "autocovariance data",
"errorFactor": "0.001",
"escapeString": false,
"infiniteIsNull": false,
"payload": "[0.05,0.01,-0.02,0.03,-0.04,0.06,0.02,-0.01,-0.03,0.04]",
"payloadType": "json",
"result": "-0.38",
"resultType": "num",
"resultProperty": "msg.result",
"topic": "",
"x": 160,
"y": 420,
"wires": [
[
"b7da7a9e30699c6f"
],
[
"da932227f003cc83"
],
[
"74920ca767d590ba"
]
]
},
{
"id": "da932227f003cc83",
"type": "debug",
"z": "cf595649.931658",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 710,
"y": 340,
"wires": []
},
{
"id": "542b732966669deb",
"type": "Monitor Flow",
"z": "cf595649.931658",
"name": "",
"x": 390,
"y": 340,
"wires": [
[
"114d327f05e06720"
]
]
},
{
"id": "74920ca767d590ba",
"type": "Monitor Flow",
"z": "cf595649.931658",
"name": "",
"x": 370,
"y": 500,
"wires": [
[]
]
},
{
"id": "ffd72c7.5d152d",
"type": "Host Available",
"z": "955f4808.fd1898",
"name": "",
"host": "localhost",
"port": "9092",
"checkInterval": "60",
"x": 400,
"y": 60,
"wires": [
[
"be654225.78ec5"
],
[
"16439017.33e21"
]
]
},
{
"id": "a303ce7d.b0c31",
"type": "Host Available",
"z": "955f4808.fd1898",
"name": "",
"host": "localhost",
"port": "1880",
"checkInterval": "",
"x": 380,
"y": 140,
"wires": [
[
"be654225.78ec5"
],
[
"16439017.33e21"
]
]
},
{
"id": "be654225.78ec5",
"type": "debug",
"z": "955f4808.fd1898",
"name": "host ok",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"x": 620,
"y": 60,
"wires": []
},
{
"id": "16439017.33e21",
"type": "debug",
"z": "955f4808.fd1898",
"name": "host down",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"x": 630,
"y": 140,
"wires": []
},
{
"id": "3e04758.89a298a",
"type": "inject",
"z": "955f4808.fd1898",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 140,
"wires": [
[
"a303ce7d.b0c31",
"ffd72c7.5d152d"
]
]
},
{
"id": "62f6a2ef.48084c",
"type": "inject",
"z": "955f4808.fd1898",
"name": "refreshHostAvailable",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "refreshHostAvailable",
"payload": "",
"payloadType": "date",
"x": 130,
"y": 60,
"wires": [
[
"a303ce7d.b0c31",
"ffd72c7.5d152d"
]
]
},
{
"id": "4bed6788.398bc8",
"type": "Load Injector",
"z": "cf804fb2.6df8c",
"name": "",
"thinktimemin": "100",
"thinktimemax": "5000",
"runtime": "30",
"payload": "",
"payloadType": "date",
"topic": "",
"topicType": "str",
"x": 190,
"y": 100,
"wires": [
[
"df6c40ba.fb661"
],
[
"dd8f915be7585f46"
]
]
},
{
"id": "df6c40ba.fb661",
"type": "function",
"z": "cf804fb2.6df8c",
"name": "Message count",
"func": "var count = context.get('count')||0;\ncontext.set('count',++count);\nnode.status({fill:\"green\",shape:\"ring\",text:\"count: \"+count});\nreturn msg;",
"outputs": 1,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 600,
"y": 100,
"wires": [
[]
]
},
{
"id": "dd8f915be7585f46",
"type": "debug",
"z": "cf804fb2.6df8c",
"name": "debug 1",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "false",
"statusVal": "",
"statusType": "auto",
"x": 580,
"y": 160,
"wires": []
},
{
"id": "f8d6f002dbf1a0ec",
"type": "Load Injector",
"z": "1be03be45284f9d4",
"name": "gen id + json",
"thinktimemin": 1000,
"thinktimemax": 10000,
"runtime": 60,
"payload": "[\"aaa\"]",
"payloadType": "json",
"topic": "",
"topicType": "genid",
"x": 130,
"y": 140,
"wires": [
[
"06a65ce9414ae1a8"
],
[
"d75971a334c97a1d"
]
]
},
{
"id": "d75971a334c97a1d",
"type": "debug",
"z": "1be03be45284f9d4",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 570,
"y": 280,
"wires": []
},
{
"id": "06a65ce9414ae1a8",
"type": "Monitor Flow",
"z": "1be03be45284f9d4",
"name": "",
"x": 470,
"y": 120,
"wires": [
[
"d75971a334c97a1d"
]
]
},
{
"id": "ce87d1616e851eb3",
"type": "Load Injector",
"z": "1be03be45284f9d4",
"name": "timestamp+string",
"thinktimemin": 1000,
"thinktimemax": 10000,
"runtime": 60,
"payload": "abc",
"payloadType": "str",
"topic": "",
"topicType": "date",
"x": 150,
"y": 80,
"wires": [
[
"06a65ce9414ae1a8"
],
[
"d75971a334c97a1d"
]
]
},
{
"id": "f92c48ed91e841ca",
"type": "Load Injector",
"z": "1be03be45284f9d4",
"name": "number+boolean",
"thinktimemin": 1000,
"thinktimemax": 10000,
"runtime": 60,
"payload": "true",
"payloadType": "bool",
"topic": "123",
"topicType": "num",
"x": 130,
"y": 200,
"wires": [
[
"06a65ce9414ae1a8"
],
[
"d75971a334c97a1d"
]
]
},
{
"id": "273e66a15fcb86aa",
"type": "Load Injector",
"z": "1be03be45284f9d4",
"name": "jsondata+buffer",
"thinktimemin": 1000,
"thinktimemax": 10000,
"runtime": 60,
"payload": "[97,116,101,115,116]",
"payloadType": "str",
"topic": "$random()\t",
"topicType": "str",
"x": 120,
"y": 280,
"wires": [
[
"06a65ce9414ae1a8"
],
[
"d75971a334c97a1d"
]
]
},
{
"id": "6282e45766a9ca96",
"type": "Load Injector",
"z": "1be03be45284f9d4",
"name": "",
"thinktimemin": 1000,
"thinktimemax": 10000,
"runtime": 60,
"payload": "{\"users\":[ {{#repeat 2}}{\"id\": {{@index}}, \"name\": \"{{firstName}} {{lastName}}\", \"work\": \"{{company}}\", \"email\": \"{{email}}\", \"dob\": \"{{date '1900' '2000' 'YYYY'}}\", \"address\": \"{{int 1 100}} {{street}}\", \"city\": \"{{city}}\", \"optedin\": {{boolean}} } {{/repeat}} ], \"images\": [{{#repeat 3}} \"img{{@index}}.png\" {{/repeat}}], \"coordinates\": { \"x\": {{float -50 50 '0.00'}}, \"y\": {{float -25 25 '0.00'}} }, \"price\": \"${{int 0 99999 '0,0'}}\"}",
"payloadType": "genDataJSON",
"topic": "{{#repeat 3 comma=false}}hello1{{/repeat}} ",
"topicType": "genData",
"x": 110,
"y": 380,
"wires": [
[
"d75971a334c97a1d"
],
[]
]
},
{
"id": "a2aba2377f22b1af",
"type": "matrix",
"z": "ae9957f07bd56e1b",
"name": "",
"action": "define",
"args": [
"rows",
"columns",
"dataType"
],
"call": "",
"column": "",
"column-type": "num",
"columns": "3",
"columns-type": "num",
"dataType": "Float64Array",
"end": "",
"end-type": "num",
"factor": "",
"factor-type": "num",
"initialState": "setZero",
"matrix": "payload",
"matrix-type": "msg",
"precision": 3,
"precision-type": "num",
"row": 3,
"row-type": "num",
"rows": "4",
"rows-type": "num",
"rowTarget": "",
"rowTarget-type": "num",
"source": "_matrix",
"source-type": "msg",
"start": "",
"start-type": "num",
"target": "_matrix",
"target-type": "msg",
"value": "payload",
"value-type": "msg",
"vector": "payload",
"vector-type": "msg",
"x": 290,
"y": 160,
"wires": [
[
"c922cee2ef7e0546"
],
[
"bbc14559e50eb44a"
]
]
},
{
"id": "c922cee2ef7e0546",
"type": "debug",
"z": "ae9957f07bd56e1b",
"name": "debug 2",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 540,
"y": 140,
"wires": []
},
{
"id": "bbc14559e50eb44a",
"type": "debug",
"z": "ae9957f07bd56e1b",
"name": "Error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 530,
"y": 200,
"wires": []
},
{
"id": "79292cc4355e3252",
"type": "inject",
"z": "ae9957f07bd56e1b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 120,
"wires": [
[
"a2aba2377f22b1af"
]
]
},
{
"id": "b4bb7d0bf7b654d9",
"type": "matrix",
"z": "ae9957f07bd56e1b",
"name": "",
"action": "defineEmpty",
"args": [
"rows",
"columns",
"dataType"
],
"call": "",
"column": "",
"column-type": "num",
"columns": "2",
"columns-type": "num",
"dataType": "Float32Array",
"end": "",
"end-type": "num",
"factor": "",
"factor-type": "num",
"initialState": "setZero",
"matrix": "payload",
"matrix-type": "msg",
"precision": 3,
"precision-type": "num",
"row": 3,
"row-type": "num",
"rows": "3",
"rows-type": "num",
"rowTarget": "",
"rowTarget-type": "num",
"source": "_matrix",
"source-type": "msg",
"start": "",
"start-type": "num",
"target": "_matrix",
"target-type": "msg",
"value": "payload",
"value-type": "msg",
"vector": "payload",
"vector-type": "msg",
"x": 310,
"y": 260,
"wires": [
[
"c922cee2ef7e0546"
],
[
"bbc14559e50eb44a"
]
]
},
{
"id": "0da6adfb6026f53b",
"type": "inject",
"z": "ae9957f07bd56e1b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 260,
"wires": [
[
"b4bb7d0bf7b654d9"
]
]
},
{
"id": "a7479251a3e14f81",
"type": "matrix",
"z": "ae9957f07bd56e1b",
"name": "",
"action": "create",
"args": [
"initialState",
"rows",
"columns"
],
"call": "",
"column": "",
"column-type": "num",
"columns": "2",
"columns-type": "num",
"end": "",
"end-type": "num",
"factor": "",
"factor-type": "num",
"initialState": "setZero",
"matrix": "payload",
"matrix-type": "msg",
"precision": 3,
"precision-type": "num",
"row": 3,
"row-type": "num",
"rows": "3",
"rows-type": "num",
"rowTarget": "",
"rowTarget-type": "num",
"source": "payload",
"source-type": "msg",
"sourceArray": "[[1,2],[3,4],[5.6]]",
"sourceArray-type": "json",
"start": "",
"start-type": "num",
"target": "_matrix",
"target-type": "msg",
"value": "payload",
"value-type": "msg",
"vector": "payload",
"vector-type": "msg",
"x": 310,
"y": 340,
"wires": [
[
"c922cee2ef7e0546"
],
[
"bbc14559e50eb44a"
]
]
},
{
"id": "1df55e5fc034db0a",
"type": "inject",
"z": "ae9957f07bd56e1b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 140,
"y": 340,
"wires": [
[
"a7479251a3e14f81"
]
]
},
{
"id": "25c0c8c9e94083e0",
"type": "test",
"z": "ae9957f07bd56e1b",
"name": "test idenity create",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "",
"payloadType": "date",
"result": "$boolean(_matrix.toArray()=[[1,0],[0,1]])",
"resultType": "jsonata",
"resultProperty": "msg",
"topic": "",
"x": 170,
"y": 480,
"wires": [
[
"a0c8377d534977a2"
],
[
"bbc14559e50eb44a"
],
[]
]
},
{
"id": "a0c8377d534977a2",
"type": "matrix",
"z": "ae9957f07bd56e1b",
"name": "",
"action": "create",
"args": [
"initialState",
"rows",
"columns",
"dataType"
],
"call": "",
"column": "",
"column-type": "num",
"columns": "2",
"columns-type": "num",
"dataType": "Float32Array",
"end": "",
"end-type": "num",
"factor": "",
"factor-type": "num",
"initialState": "setIdentity",
"matrix": "payload",
"matrix-type": "msg",
"precision": 3,
"precision-type": "num",
"row": 3,
"row-type": "num",
"rows": "2",
"rows-type": "num",
"rowTarget": "",
"rowTarget-type": "num",
"source": "_matrix",
"source-type": "msg",
"sourceArray": "payload",
"sourceArray-type": "msg,json,flow,global",
"start": "",
"start-type": "num",
"target": "_matrix",
"target-type": "msg",
"value": "payload",
"value-type": "msg",
"vector": "payload",
"vector-type": "msg",
"x": 430,
"y": 480,
"wires": [
[
"25c0c8c9e94083e0"
],
[]
]
},
{
"id": "ae223fa13da104ff",
"type": "function",
"z": "ae9957f07bd56e1b",
"name": "function 1",
"func": "\nreturn msg;",
"outputs": 1,
"timeout": 0,
"noerr": 0,
"initialize": "",
"finalize": "",
"libs": [],
"x": 480,
"y": 580,
"wires": [
[]
]
},
{
"id": "c4e5d98c.1db6f8",
"type": "Monitor Flow",
"z": "fcc005d5.131ee8",
"name": "",
"x": 370,
"y": 60,
"wires": [
[]
]
},
{
"id": "6985d392.2b65ac",
"type": "Load Injector",
"z": "fcc005d5.131ee8",
"name": "",
"thinktimemin": 1000,
"thinktimemax": 10000,
"runtime": 60,
"payload": "",
"payloadType": "date",
"x": 150,
"y": 60,
"wires": [
[
"c4e5d98c.1db6f8"
],
[]
]
},
{
"id": "c1d0d1b5be0f10d4",
"type": "Monitor System",
"z": "0ff935c8a42f26ae",
"name": "",
"metrics": "gaugeMemory,resourceUsage,chartLineResource",
"x": 180,
"y": 240,
"wires": [
[]
]
},
{
"id": "ac811c5f2be19993",
"type": "Monitor System",
"z": "0ff935c8a42f26ae",
"name": "",
"metrics": "freeMemory,totalMemory,chartMemoryUsage",
"graphs": null,
"x": 600,
"y": 180,
"wires": [
[]
]
},
{
"id": "f9d9fffe.9c0d6",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "arch",
"x": 270,
"y": 40,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "258d203c.af111",
"type": "debug",
"z": "fa243279.4dbe9",
"name": "os out",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"x": 590,
"y": 400,
"wires": []
},
{
"id": "b612d0d4.d6af9",
"type": "inject",
"z": "fa243279.4dbe9",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 320,
"wires": [
[
"f9d9fffe.9c0d6",
"af14ce79.67da1",
"7b9e7709.a1a058",
"7e143a9e.eb16b4",
"b9995178.6ca31",
"a572aac6.59d2e8",
"10bea419.99e54c",
"98a73c5b.3e298",
"a0b1d851.af5698",
"9d89654b.a1b158",
"3fb37e05.d807c2",
"93e4f264.298b8",
"44e0bbd2.29e2b4",
"867824a3.7194d8",
"d49cda2c.33ab88",
"7bd65c52.e940d4",
"e242c49a.2de7e8",
"fe9cdcce.1175"
]
]
},
{
"id": "af14ce79.67da1",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "EOL",
"x": 270,
"y": 80,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "7b9e7709.a1a058",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "constants",
"x": 280,
"y": 120,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "7e143a9e.eb16b4",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "cpus",
"x": 270,
"y": 160,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "b9995178.6ca31",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "endianness",
"x": 290,
"y": 200,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "a572aac6.59d2e8",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "freemem",
"x": 280,
"y": 240,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "10bea419.99e54c",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "getPriority",
"x": 280,
"y": 280,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "98a73c5b.3e298",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "homedir",
"x": 280,
"y": 320,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "a0b1d851.af5698",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "hostname",
"x": 280,
"y": 360,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "9d89654b.a1b158",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "loadavg",
"x": 280,
"y": 400,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "3fb37e05.d807c2",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "networkInterfaces",
"x": 310,
"y": 440,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "93e4f264.298b8",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "release",
"x": 280,
"y": 480,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "44e0bbd2.29e2b4",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "setPriority",
"x": 280,
"y": 520,
"wires": [
[],
[
"9257111d.7fb72"
]
]
},
{
"id": "867824a3.7194d8",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "tmpdir",
"x": 270,
"y": 560,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "d49cda2c.33ab88",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "totalmem",
"x": 280,
"y": 600,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "7bd65c52.e940d4",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "type",
"x": 270,
"y": 640,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "e242c49a.2de7e8",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "uptime",
"x": 270,
"y": 680,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "fe9cdcce.1175",
"type": "os",
"z": "fa243279.4dbe9",
"name": "",
"property": "userInfo",
"x": 280,
"y": 720,
"wires": [
[
"258d203c.af111"
],
[]
]
},
{
"id": "9257111d.7fb72",
"type": "debug",
"z": "fa243279.4dbe9",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"x": 580,
"y": 480,
"wires": []
},
{
"id": "17012eaf.209341",
"type": "debug",
"z": "22109ce1.cdbde4",
"name": "ok",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"x": 590,
"y": 60,
"wires": []
},
{
"id": "44f9d218.ea49bc",
"type": "inject",
"z": "22109ce1.cdbde4",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "start",
"payload": "",
"payloadType": "date",
"x": 160,
"y": 120,
"wires": [
[
"4d7e523d.bf906c",
"b3595576.0a49a8",
"1ae819ca.83db56",
"c72d83e4.f9c84"
]
]
},
{
"id": "4d7e523d.bf906c",
"type": "Spawn Process",
"z": "22109ce1.cdbde4",
"name": "",
"process": "ls",
"os": "Linux",
"autoStart": "false",
"workingDirectory": "",
"arguments": "",
"x": 350,
"y": 120,
"wires": [
[
"17012eaf.209341"
],
[
"59abb3e0.dbab4c"
],
[
"6ce6505f.ded13"
]
]
},
{
"id": "b3595576.0a49a8",
"type": "Spawn Process",
"z": "22109ce1.cdbde4",
"name": "",
"process": "ping",
"os": "Windows_NT",
"autoStart": "false",
"workingDirectory": "",
"arguments": "127.0.0.1",
"x": 350,
"y": 40,
"wires": [
[
"17012eaf.209341"
],
[
"59abb3e0.dbab4c"
],
[
"6ce6505f.ded13"
]
]
},
{
"id": "1ae819ca.83db56",
"type": "Spawn Process",
"z": "22109ce1.cdbde4",
"name": "",
"process": "failAsNotFound",
"os": "",
"autoStart": "true",
"workingDirectory": "",
"arguments": "",
"x": 360,
"y": 240,
"wires": [
[
"17012eaf.209341"
],
[
"59abb3e0.dbab4c"
],
[
"6ce6505f.ded13"
]
]
},
{
"id": "59abb3e0.dbab4c",
"type": "debug",
"z": "22109ce1.cdbde4",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"x": 590,
"y": 160,
"wires": []
},
{
"id": "6ce6505f.ded13",
"type": "debug",
"z": "22109ce1.cdbde4",
"name": "exit",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"x": 590,
"y": 240,
"wires": []
},
{
"id": "c72d83e4.f9c84",
"type": "Spawn Process",
"z": "22109ce1.cdbde4",
"name": "windows cmd.exe",
"process": "cmd.exe",
"os": "Windows_NT",
"autoStart": "true",
"workingDirectory": "../",
"arguments": "/c echo %cd% %ENV1% %ENV2aa%",
"env": {
"ENV1": "t1",
"ENV2aa": "t2"
},
"x": 360,
"y": 340,
"wires": [
[
"17012eaf.209341"
],
[
"59abb3e0.dbab4c"
],
[
"6ce6505f.ded13"
]
]
},
{
"id": "e6c7ffb7.9947e",
"type": "test",
"z": "e4973c86.37d63",
"name": "",
"payload": "testdata",
"payloadType": "str",
"result": "testdata",
"resultType": "str",
"topic": "",
"x": 340,
"y": 20,
"wires": [
[
"505ec37a.ba24ac",
"ca221cf9.acd4b"
],
[],
[]
]
},
{
"id": "505ec37a.ba24ac",
"type": "debug",
"z": "e4973c86.37d63",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"x": 590,
"y": 20,
"wires": []
},
{
"id": "ca221cf9.acd4b",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "5",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"outputs": 1,
"x": 320,
"y": 80,
"wires": [
[
"e6c7ffb7.9947e"
]
]
},
{
"id": "8c1d482d.3797f8",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "5",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"outputs": 1,
"x": 320,
"y": 200,
"wires": [
[
"f6d80561.d80d08"
]
]
},
{
"id": "f6d80561.d80d08",
"type": "test",
"z": "e4973c86.37d63",
"name": "Fail expected",
"errorFactor": "",
"escapeString": false,
"payload": "testa",
"payloadType": "str",
"result": "testb",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 330,
"y": 140,
"wires": [
[
"8c1d482d.3797f8"
],
[
"505ec37a.ba24ac"
],
[]
]
},
{
"id": "706f9c15.e56864",
"type": "inject",
"z": "e4973c86.37d63",
"name": "",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 20,
"wires": [
[
"e6c7ffb7.9947e",
"f6d80561.d80d08",
"7424fbe5.b21ea4",
"575b7f19.b17d5",
"c9ec0f06.98cf3",
"2e00eb75.23c2c4",
"6f443ba6947c687c",
"f942a87fe0ced9b0",
"d2d20c34deec31b5",
"8c1f54f93ac4630b"
]
]
},
{
"id": "7424fbe5.b21ea4",
"type": "test",
"z": "e4973c86.37d63",
"name": "",
"payload": "{\"a\":1,\"b\":\"two\"}",
"payloadType": "json",
"result": "{\"a\":1,\"b\":\"two\"}",
"resultType": "json",
"topic": "",
"x": 340,
"y": 260,
"wires": [
[
"affb8557.b1c5a8"
],
[],
[]
]
},
{
"id": "affb8557.b1c5a8",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "5",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"outputs": 1,
"x": 340,
"y": 320,
"wires": [
[
"7424fbe5.b21ea4"
]
]
},
{
"id": "575b7f19.b17d5",
"type": "test",
"z": "e4973c86.37d63",
"name": "fail expected",
"errorFactor": "0",
"escapeString": false,
"payload": "{\"a\":1,\"b\":\"two\"}",
"payloadType": "str",
"result": "{\"a\":1,\"b\":\"three\"}",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 300,
"y": 380,
"wires": [
[
"b1ee7e8.71a4e8"
],
[
"505ec37a.ba24ac"
],
[]
]
},
{
"id": "b1ee7e8.71a4e8",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "5",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"outputs": 1,
"x": 340,
"y": 440,
"wires": [
[
"575b7f19.b17d5"
]
]
},
{
"id": "41c3903b.ca8a3",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "5",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"outputs": 1,
"x": 340,
"y": 560,
"wires": [
[
"c9ec0f06.98cf3"
]
]
},
{
"id": "c9ec0f06.98cf3",
"type": "test",
"z": "e4973c86.37d63",
"name": "",
"payload": "{\"a\":1,\"b\":[1,2,3,4]}",
"payloadType": "str",
"result": "{\"a\":1,\"b\":[1,2,3,4]}",
"resultType": "str",
"topic": "",
"x": 350,
"y": 500,
"wires": [
[
"41c3903b.ca8a3"
],
[],
[]
]
},
{
"id": "2e00eb75.23c2c4",
"type": "test",
"z": "e4973c86.37d63",
"name": "",
"payload": "",
"payloadType": "date",
"result": "",
"resultType": "date",
"resultProperty": "msg.testResult",
"topic": "",
"x": 320,
"y": 640,
"wires": [
[
"ee190293.d97ed"
],
[],
[]
]
},
{
"id": "ee190293.d97ed",
"type": "function",
"z": "e4973c86.37d63",
"name": "",
"func": "msg.testResult=msg.payload\nreturn msg;",
"outputs": 1,
"noerr": 0,
"x": 570,
"y": 640,
"wires": [
[
"2e00eb75.23c2c4"
]
]
},
{
"id": "6f443ba6947c687c",
"type": "test",
"z": "e4973c86.37d63",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"p1\":\"p1data\",\"p2\":2,\"p3\":3}",
"payloadType": "json",
"result": "$boolean(payload.p2=2)\t\t",
"resultType": "jsonata",
"resultProperty": "msg.payload",
"topic": "",
"x": 310,
"y": 740,
"wires": [
[
"febdd5455965bcb4"
],
[],
[]
]
},
{
"id": "febdd5455965bcb4",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "1",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"allowrate": false,
"outputs": 1,
"x": 300,
"y": 820,
"wires": [
[
"6f443ba6947c687c"
]
]
},
{
"id": "f942a87fe0ced9b0",
"type": "test",
"z": "e4973c86.37d63",
"name": "Fail expected",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"p1\":\"p1data\",\"p2\":2,\"p3\":3}",
"payloadType": "json",
"result": "$boolean(payload.p2=3)\t\t",
"resultType": "jsonata",
"resultProperty": "msg.payload",
"topic": "",
"x": 290,
"y": 880,
"wires": [
[
"df55e5dc0a75a50a"
],
[],
[]
]
},
{
"id": "df55e5dc0a75a50a",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "1",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"allowrate": false,
"outputs": 1,
"x": 320,
"y": 1000,
"wires": [
[
"f942a87fe0ced9b0"
]
]
},
{
"id": "d2d20c34deec31b5",
"type": "test",
"z": "e4973c86.37d63",
"name": "succss expected",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[0,1,[1,2]]",
"payloadType": "json",
"result": "$boolean(payload=[0,1,[1,2]])\t",
"resultType": "jsonata",
"resultProperty": "msg.payload",
"topic": "",
"x": 330,
"y": 1060,
"wires": [
[
"6665281886747d77"
],
[],
[]
]
},
{
"id": "6665281886747d77",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "1",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"allowrate": false,
"outputs": 1,
"x": 340,
"y": 1180,
"wires": [
[
"d2d20c34deec31b5"
]
]
},
{
"id": "8c1f54f93ac4630b",
"type": "test",
"z": "e4973c86.37d63",
"name": "Fail expected",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[0,1,[1,2]]",
"payloadType": "json",
"result": "$boolean(payload=[0,1,[2,2]])\t",
"resultType": "jsonata",
"resultProperty": "msg.payload",
"topic": "",
"x": 310,
"y": 1240,
"wires": [
[
"afe22943eebfc180"
],
[],
[]
]
},
{
"id": "afe22943eebfc180",
"type": "delay",
"z": "e4973c86.37d63",
"name": "",
"pauseType": "delay",
"timeout": "1",
"timeoutUnits": "seconds",
"rate": "1",
"nbRateUnits": "1",
"rateUnits": "second",
"randomFirst": "1",
"randomLast": "5",
"randomUnits": "seconds",
"drop": false,
"allowrate": false,
"outputs": 1,
"x": 340,
"y": 1360,
"wires": [
[
"8c1f54f93ac4630b"
]
]
},
{
"id": "d9a04503.7fc3a8",
"type": "debug",
"z": "d9c7ae0e.cb9a9",
"name": "",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"x": 730,
"y": 340,
"wires": []
},
{
"id": "df3844b8.d62658",
"type": "test",
"z": "d9c7ae0e.cb9a9",
"name": "",
"payload": "{\"a\":1,\"b\":1}",
"payloadType": "str",
"result": "{\"a\":1,\"b\":1}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 300,
"y": 220,
"wires": [
[
"7c0de4f5.afbe7c"
],
[],
[]
]
},
{
"id": "7c0de4f5.afbe7c",
"type": "transform",
"z": "d9c7ae0e.cb9a9",
"name": "",
"actionSource": "String",
"actionTarget": "JSON",
"delimiter": ",",
"x": 560,
"y": 160,
"wires": [
[
"df3844b8.d62658"
],
[]
]
},
{
"id": "eaa68e41.81cce",
"type": "transform",
"z": "d9c7ae0e.cb9a9",
"name": "",
"actionSource": "JSON",
"actionTarget": "Array",
"delimiter": ",",
"x": 560,
"y": 240,
"wires": [
[
"d9a04503.7fc3a8",
"1996fa8b.414205"
],
[]
]
},
{
"id": "1996fa8b.414205",
"type": "test",
"z": "d9c7ae0e.cb9a9",
"name": "",
"escapeString": false,
"payload": "{\"a\":1,\"b\":\"two\"}",
"payloadType": "json",
"result": "[[\"a\",1],[\"b\",\"two\"]]",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 300,
"y": 300,
"wires": [
[
"eaa68e41.81cce",
"c1be8cd5.2856e"
],
[],
[]
]
},
{
"id": "c56f126c.f8cf6",
"type": "inject",
"z": "d9c7ae0e.cb9a9",
"name": "ISO8385 message",
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "[49,50,51,52,68,48,50,48,48,48,48,48,48,50,67,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,48,56,49,54,49,50,51,52,53,54,55,56,57,48,49,50,51,52,53,54,48,48,48,48,48,48,48,48,53,54,57,57,48,48,48,50,51,52,48,48,48,52,51,49,51,50,51,51,51,52,51,53,50,48,50,48,50,48,51,54,51,55,51,56,51,57,51,48,51,49,51,50,51,51,51,52,50,48,50,48,50,48,50,48,50,48,50,48,48,48,48,57,52,50,52,67,52,49,52,56,50,48,52,50,52,67,52,49,52,56]",
"payloadType": "bin",
"x": 170,
"y": 420,
"wires": [
[
"1ff5bd86.f88092"
]
]
},
{
"id": "1ff5bd86.f88092",
"type": "transform",
"z": "d9c7ae0e.cb9a9",
"name": "",
"actionSource": "ISO8385",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "JSON",
"sourceProperty": "",
"targetProperty": "",
"topicProperty": "",
"JSONataSource": "",
"JSONataTarget": "",
"index": "",
"maxMessages": "",
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": "",
"schema": "",
"schemaType": "str",
"skipLeading": "",
"skipTrailing": "",
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 420,
"wires": [
[
"d9a04503.7fc3a8"
],
[]
]
},
{
"id": "5fef790b.8b87d8",
"type": "comment",
"z": "d9c7ae0e.cb9a9",
"name": "Experimental",
"info": "# Experimental",
"x": 310,
"y": 40,
"wires": []
},
{
"id": "c1be8cd5.2856e",
"type": "transform",
"z": "d9c7ae0e.cb9a9",
"name": "",
"actionSource": "JSON",
"actionTarget": "HTML",
"delimiter": ",",
"x": 540,
"y": 320,
"wires": [
[
"d9a04503.7fc3a8"
],
[]
]
},
{
"id": "4442914142aea731",
"type": "file in",
"z": "d9c7ae0e.cb9a9",
"name": "int2matrix2x3.npy",
"filename": "test/data/int2matrix2x3.npy",
"filenameType": "str",
"format": "",
"chunk": false,
"sendError": false,
"encoding": "none",
"allProps": false,
"x": 310,
"y": 640,
"wires": [
[
"d9a04503.7fc3a8",
"b1411e5351c0347e"
]
]
},
{
"id": "e8f8458f9e31476a",
"type": "inject",
"z": "d9c7ae0e.cb9a9",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 640,
"wires": [
[
"4442914142aea731"
]
]
},
{
"id": "b1411e5351c0347e",
"type": "transform",
"z": "d9c7ae0e.cb9a9",
"name": "",
"actionSource": "npy",
"actionTarget": "JSON",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 570,
"y": 640,
"wires": [
[
"d9a04503.7fc3a8"
],
[]
]
},
{
"id": "7d7f98d9f9c42629",
"type": "link call",
"z": "d9c7ae0e.cb9a9",
"name": "",
"links": [
"2605139b45f1f105"
],
"linkType": "static",
"timeout": "30",
"x": 340,
"y": 820,
"wires": [
[
"39f69c675d39c38c"
]
]
},
{
"id": "93648bfe54fe290b",
"type": "inject",
"z": "d9c7ae0e.cb9a9",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 120,
"y": 740,
"wires": [
[
"455bee5a8bfcd16f"
]
]
},
{
"id": "44ba2e4231a7cf77",
"type": "link call",
"z": "d9c7ae0e.cb9a9",
"name": "",
"links": [
"e057797d0b796145"
],
"linkType": "static",
"timeout": "30",
"x": 670,
"y": 100,
"wires": [
[]
]
},
{
"id": "455bee5a8bfcd16f",
"type": "link call",
"z": "d9c7ae0e.cb9a9",
"name": "",
"links": [
"ef3c3bb841e5b85a"
],
"linkType": "static",
"timeout": "30",
"x": 320,
"y": 740,
"wires": [
[
"52839bfb05b91f4c"
]
]
},
{
"id": "810e0fa7d63baab2",
"type": "link call",
"z": "d9c7ae0e.cb9a9",
"name": "",
"links": [
"e057797d0b796145"
],
"linkType": "static",
"timeout": "30",
"x": 350,
"y": 940,
"wires": [
[
"6bda6a7cf990884d"
]
]
},
{
"id": "6bda6a7cf990884d",
"type": "debug",
"z": "d9c7ae0e.cb9a9",
"name": "Done",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 570,
"y": 960,
"wires": []
},
{
"id": "52839bfb05b91f4c",
"type": "Monitor Flow",
"z": "d9c7ae0e.cb9a9",
"name": "",
"x": 550,
"y": 740,
"wires": [
[
"11ca1573aaaf8288"
]
]
},
{
"id": "39f69c675d39c38c",
"type": "Monitor Flow",
"z": "d9c7ae0e.cb9a9",
"name": "",
"x": 550,
"y": 820,
"wires": [
[
"6fe703fe6cf5f12d"
]
]
},
{
"id": "6fe703fe6cf5f12d",
"type": "link call",
"z": "d9c7ae0e.cb9a9",
"name": "",
"links": [
"8bc4d0adfbe612e5"
],
"linkType": "static",
"timeout": "30",
"x": 330,
"y": 880,
"wires": [
[
"810e0fa7d63baab2"
]
]
},
{
"id": "11ca1573aaaf8288",
"type": "link call",
"z": "d9c7ae0e.cb9a9",
"name": "",
"links": [
"0c1e0f0f3543e49e"
],
"linkType": "static",
"timeout": "30",
"x": 340,
"y": 780,
"wires": [
[
"7d7f98d9f9c42629"
]
]
},
{
"id": "93c7047f87bbf964",
"type": "debug",
"z": "5866424ac23291eb",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 970,
"y": 200,
"wires": []
},
{
"id": "de625a76baddbeab",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "JSON",
"actionTarget": "CSV",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 630,
"y": 280,
"wires": [
[
"b8a38eb268a6e0c8"
],
[]
]
},
{
"id": "911d448d61a99628",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "Array",
"actionTarget": "HTML",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 640,
"y": 360,
"wires": [
[
"238111a6a4d2eb17"
],
[]
]
},
{
"id": "238111a6a4d2eb17",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[[1,2],[3,4]]",
"payloadType": "json",
"result": "",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 350,
"y": 360,
"wires": [
[
"911d448d61a99628"
],
[
"93c7047f87bbf964"
],
[
"4a732ba4ce49193b"
]
]
},
{
"id": "4a732ba4ce49193b",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[[1,2],[3,4]]",
"payloadType": "json",
"result": "[[\"0\",[[\"0\",1],[\"1\",2]]],[\"1\",[[\"0\",3],[\"1\",4]]]]",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 340,
"y": 440,
"wires": [
[
"dd65575382bcf216"
],
[
"93c7047f87bbf964"
],
[
"b12a345acca22450"
]
]
},
{
"id": "dd65575382bcf216",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "JSON",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Array",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"index": "",
"maxMessages": "10",
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": "",
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 640,
"y": 440,
"wires": [
[
"4a732ba4ce49193b"
],
[
"93c7047f87bbf964"
]
]
},
{
"id": "b12a345acca22450",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"item\":\"aaa\",\"item-2\":\"bbbb\",\"item-3\":{\"a\":1,\"item\":0}}",
"payloadType": "json",
"result": "[[\"item\",\"aaa\"],[\"item-2\",\"bbbb\"],[\"item-3\",[[\"a\",1],[\"item\",0]]]]",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 350,
"y": 520,
"wires": [
[
"0ce4bc8bf5d5705a"
],
[
"93c7047f87bbf964"
],
[
"3c77d5233e994214"
]
]
},
{
"id": "0ce4bc8bf5d5705a",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "JSON",
"actionTarget": "Array",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": "10",
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 640,
"y": 520,
"wires": [
[
"b12a345acca22450"
],
[
"93c7047f87bbf964"
]
]
},
{
"id": "16fb26ead524acd9",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"item\":\"aaa\",\"item-2\":\"bbbb\",\"item-3\":{\"a\":1,\"item\":0}}",
"payloadType": "json",
"result": "{\"item\":\"aaa\",\"item-2\":\"bbbb\",\"item-3\":{\"a\":1,\"item\":0}}",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 350,
"y": 40,
"wires": [
[
"22615f5fec6c0175"
],
[
"93c7047f87bbf964"
],
[
"2d70fc47c71dc4a7"
]
]
},
{
"id": "22615f5fec6c0175",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "JSON",
"actionTarget": "CSV",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 630,
"y": 40,
"wires": [
[
"16fb26ead524acd9"
],
[
"93c7047f87bbf964"
]
]
},
{
"id": "2d70fc47c71dc4a7",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "[[1,2],[2,3]]",
"payloadType": "json",
"result": "1,2\\n2,3",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 330,
"y": 120,
"wires": [
[
"e2379b2107153487"
],
[
"93c7047f87bbf964"
],
[
"2a05da2094352897"
]
]
},
{
"id": "e2379b2107153487",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "JSON",
"actionTarget": "CSV",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 630,
"y": 120,
"wires": [
[
"2d70fc47c71dc4a7"
],
[
"93c7047f87bbf964"
]
]
},
{
"id": "bb791331d4215f9d",
"type": "transform",
"z": "5866424ac23291eb",
"name": "",
"actionSource": "Array",
"actionTarget": "HTML",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 640,
"y": 200,
"wires": [
[
"2a05da2094352897"
],
[
"93c7047f87bbf964"
]
]
},
{
"id": "2a05da2094352897",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[[1,2],[2,3]]",
"payloadType": "json",
"result": "",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 350,
"y": 200,
"wires": [
[
"bb791331d4215f9d"
],
[
"93c7047f87bbf964"
],
[
"b8a38eb268a6e0c8"
]
]
},
{
"id": "b8a38eb268a6e0c8",
"type": "test",
"z": "5866424ac23291eb",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "[{\"item\":\"1\",\"item-2\":\"2\"},{\"item\":\"3\",\"item-1\":\"4\"},\"test\",[1,2,3]]",
"payloadType": "json",
"result": "item,item-1,item-2\\n1,,2\\n3,4,\\n,,,\"test\"\\n,,,[1,2,3]",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 350,
"y": 280,
"wires": [
[
"de625a76baddbeab"
],
[
"93c7047f87bbf964"
],
[
"238111a6a4d2eb17"
]
]
},
{
"id": "ef3c3bb841e5b85a",
"type": "link in",
"z": "5866424ac23291eb",
"name": "transform array",
"links": [],
"x": 105,
"y": 40,
"wires": [
[
"16fb26ead524acd9"
]
]
},
{
"id": "3c77d5233e994214",
"type": "link out",
"z": "5866424ac23291eb",
"name": "transform array finished",
"mode": "return",
"links": [],
"x": 555,
"y": 620,
"wires": []
},
{
"id": "49b2ad130416e0a0",
"type": "transform",
"z": "1374c39ae82adb4e",
"g": "680198a3be420949",
"name": "",
"actionSource": "String",
"deleteSource": "false",
"deleteSourceType": "bool",
"actionTarget": "Date",
"sourceProperty": "msg.payload.testDate",
"targetProperty": "msg.payload.typedDate",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 350,
"y": 60,
"wires": [
[
"8623ee29d4c12529"
],
[]
]
},
{
"id": "8623ee29d4c12529",
"type": "transform",
"z": "1374c39ae82adb4e",
"g": "680198a3be420949",
"name": "",
"actionSource": "Date",
"deleteSource": "false",
"deleteSourceType": "bool",
"actionTarget": "isBetween",
"sourceProperty": "msg.payload.typedDate",
"targetProperty": "msg.payload.result",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "2025-04-29",
"minDate": "2025-04-21",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 590,
"y": 80,
"wires": [
[
"c81d74aeb883cd43"
],
[
"94c3bd1cdaed91d7"
]
]
},
{
"id": "d6dab95d41cd38af",
"type": "link in",
"z": "1374c39ae82adb4e",
"g": "680198a3be420949",
"name": "is Between",
"links": [],
"x": 185,
"y": 60,
"wires": [
[
"49b2ad130416e0a0"
]
]
},
{
"id": "c81d74aeb883cd43",
"type": "link out",
"z": "1374c39ae82adb4e",
"g": "680198a3be420949",
"name": "link out 1",
"mode": "return",
"links": [],
"x": 865,
"y": 40,
"wires": []
},
{
"id": "94c3bd1cdaed91d7",
"type": "debug",
"z": "1374c39ae82adb4e",
"g": "680198a3be420949",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 790,
"y": 100,
"wires": []
},
{
"id": "cafcd8870a79cace",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"d6dab95d41cd38af"
],
"linkType": "static",
"timeout": "30",
"x": 470,
"y": 240,
"wires": [
[
"d96341af5b44e199"
]
]
},
{
"id": "d96341af5b44e199",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-03-01",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-03-01\"}",
"payloadType": "json",
"result": "false",
"resultType": "bool",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 190,
"y": 240,
"wires": [
[
"cafcd8870a79cace"
],
[
"b60875427c4e1dab"
],
[
"98edd0a964987b88"
]
]
},
{
"id": "b60875427c4e1dab",
"type": "debug",
"z": "1374c39ae82adb4e",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 450,
"y": 180,
"wires": []
},
{
"id": "003f183644c0d375",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"d6dab95d41cd38af"
],
"linkType": "static",
"timeout": "30",
"x": 470,
"y": 340,
"wires": [
[
"98edd0a964987b88"
]
]
},
{
"id": "98edd0a964987b88",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-21",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-21\"}",
"payloadType": "json",
"result": "true",
"resultType": "bool",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 190,
"y": 340,
"wires": [
[
"003f183644c0d375"
],
[
"b60875427c4e1dab"
],
[
"0fa488a51c3f56c4"
]
]
},
{
"id": "4cf4ccedc39cf6e8",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"d6dab95d41cd38af"
],
"linkType": "static",
"timeout": "30",
"x": 470,
"y": 440,
"wires": [
[
"0fa488a51c3f56c4"
]
]
},
{
"id": "0fa488a51c3f56c4",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-24",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-24\"}",
"payloadType": "json",
"result": "true",
"resultType": "bool",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 190,
"y": 440,
"wires": [
[
"4cf4ccedc39cf6e8"
],
[
"b60875427c4e1dab"
],
[
"332ab8ee7e19c841"
]
]
},
{
"id": "c9df9f01c0c55032",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"d6dab95d41cd38af"
],
"linkType": "static",
"timeout": "30",
"x": 470,
"y": 520,
"wires": [
[
"332ab8ee7e19c841"
]
]
},
{
"id": "332ab8ee7e19c841",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-29",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-29\"}",
"payloadType": "json",
"result": "true",
"resultType": "bool",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 190,
"y": 520,
"wires": [
[
"c9df9f01c0c55032"
],
[
"b60875427c4e1dab"
],
[
"0b4da0663cfc792f"
]
]
},
{
"id": "559cd028a850dd99",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"d6dab95d41cd38af"
],
"linkType": "static",
"timeout": "30",
"x": 470,
"y": 600,
"wires": [
[
"0b4da0663cfc792f"
]
]
},
{
"id": "0b4da0663cfc792f",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-30",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-30\"}",
"payloadType": "json",
"result": "false",
"resultType": "bool",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 190,
"y": 600,
"wires": [
[
"559cd028a850dd99"
],
[
"b60875427c4e1dab"
],
[
"731e0f954b971546"
]
]
},
{
"id": "a411a1f479258d72",
"type": "debug",
"z": "1374c39ae82adb4e",
"name": "All OK",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "payload",
"targetType": "msg",
"statusVal": "",
"statusType": "auto",
"x": 1070,
"y": 720,
"wires": []
},
{
"id": "4f6a21107d3e15fe",
"type": "transform",
"z": "1374c39ae82adb4e",
"g": "68a2c0f4427ce400",
"name": "",
"actionSource": "String",
"deleteSource": "false",
"deleteSourceType": "bool",
"actionTarget": "Date",
"sourceProperty": "msg.payload.testDate",
"targetProperty": "msg.payload.typedDate",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 1150,
"y": 40,
"wires": [
[
"7fdb40764c01f99a"
],
[]
]
},
{
"id": "7fdb40764c01f99a",
"type": "transform",
"z": "1374c39ae82adb4e",
"g": "68a2c0f4427ce400",
"name": "",
"actionSource": "Date",
"deleteSource": "false",
"deleteSourceType": "bool",
"actionTarget": "RangeLimit",
"sourceProperty": "msg.payload.typedDate",
"targetProperty": "msg.payload.dateString",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "2025-04-29",
"minDate": "2025-04-21",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 1450,
"y": 60,
"wires": [
[
"b9d724057624e971"
],
[
"e36d78184f2c0e34"
]
]
},
{
"id": "2b4dc03c0cb6ea2b",
"type": "link in",
"z": "1374c39ae82adb4e",
"g": "68a2c0f4427ce400",
"name": "link range limit",
"links": [],
"x": 985,
"y": 40,
"wires": [
[
"4f6a21107d3e15fe"
]
]
},
{
"id": "06787d2f44f5d979",
"type": "link out",
"z": "1374c39ae82adb4e",
"g": "68a2c0f4427ce400",
"name": "link out 2",
"mode": "return",
"links": [],
"x": 1805,
"y": 40,
"wires": []
},
{
"id": "e36d78184f2c0e34",
"type": "debug",
"z": "1374c39ae82adb4e",
"g": "68a2c0f4427ce400",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 1750,
"y": 100,
"wires": []
},
{
"id": "5a7a5a372e739058",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"2b4dc03c0cb6ea2b"
],
"linkType": "static",
"timeout": "30",
"x": 1260,
"y": 260,
"wires": [
[
"731e0f954b971546"
]
]
},
{
"id": "731e0f954b971546",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-03-01",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-03-01\"}",
"payloadType": "json",
"result": "2025-04-21",
"resultType": "str",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 970,
"y": 260,
"wires": [
[
"5a7a5a372e739058"
],
[
"3113b8a9e4b92296"
],
[
"435e5493c2006354"
]
]
},
{
"id": "3113b8a9e4b92296",
"type": "debug",
"z": "1374c39ae82adb4e",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 1230,
"y": 200,
"wires": []
},
{
"id": "d4b337a35727cf8a",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"2b4dc03c0cb6ea2b"
],
"linkType": "static",
"timeout": "30",
"x": 1260,
"y": 360,
"wires": [
[
"435e5493c2006354"
]
]
},
{
"id": "435e5493c2006354",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-21",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-21\"}",
"payloadType": "json",
"result": "2025-04-21",
"resultType": "str",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 970,
"y": 360,
"wires": [
[
"d4b337a35727cf8a"
],
[
"3113b8a9e4b92296"
],
[
"157fd5a634598f9a"
]
]
},
{
"id": "79501eafa56bfb4e",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"2b4dc03c0cb6ea2b"
],
"linkType": "static",
"timeout": "30",
"x": 1260,
"y": 460,
"wires": [
[
"157fd5a634598f9a"
]
]
},
{
"id": "157fd5a634598f9a",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-24",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-24\"}",
"payloadType": "json",
"result": "2025-04-24",
"resultType": "str",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 970,
"y": 460,
"wires": [
[
"79501eafa56bfb4e"
],
[
"3113b8a9e4b92296"
],
[
"aae098ae4b670f43"
]
]
},
{
"id": "fc891c3bc02aafd5",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"2b4dc03c0cb6ea2b"
],
"linkType": "static",
"timeout": "30",
"x": 1260,
"y": 540,
"wires": [
[
"aae098ae4b670f43"
]
]
},
{
"id": "aae098ae4b670f43",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-29",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-29\"}",
"payloadType": "json",
"result": "2025-04-29",
"resultType": "str",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 970,
"y": 540,
"wires": [
[
"fc891c3bc02aafd5"
],
[
"3113b8a9e4b92296"
],
[
"e1fae4560b677429"
]
]
},
{
"id": "d0240939763a6c79",
"type": "link call",
"z": "1374c39ae82adb4e",
"name": "",
"links": [
"2b4dc03c0cb6ea2b"
],
"linkType": "static",
"timeout": "30",
"x": 1260,
"y": 620,
"wires": [
[
"e1fae4560b677429"
]
]
},
{
"id": "e1fae4560b677429",
"type": "test",
"z": "1374c39ae82adb4e",
"name": "2025-04-30",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"testDate\":\"2025-04-30\"}",
"payloadType": "json",
"result": "2025-04-29",
"resultType": "str",
"resultProperty": "msg.payload.result",
"topic": "",
"x": 970,
"y": 620,
"wires": [
[
"d0240939763a6c79"
],
[
"3113b8a9e4b92296"
],
[
"a411a1f479258d72",
"d8e481b0d9a11465"
]
]
},
{
"id": "b9d724057624e971",
"type": "transform",
"z": "1374c39ae82adb4e",
"g": "68a2c0f4427ce400",
"name": "",
"actionSource": "Date",
"deleteSource": "false",
"deleteSourceType": "bool",
"actionTarget": "ISODate",
"sourceProperty": "msg.payload.dateString",
"targetProperty": "msg.payload.result",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 1640,
"y": 40,
"wires": [
[
"06787d2f44f5d979"
],
[]
]
},
{
"id": "2605139b45f1f105",
"type": "link in",
"z": "1374c39ae82adb4e",
"name": "transform date",
"links": [],
"x": 75,
"y": 160,
"wires": [
[
"d96341af5b44e199"
]
]
},
{
"id": "d8e481b0d9a11465",
"type": "link out",
"z": "1374c39ae82adb4e",
"name": "trans form date finish",
"mode": "return",
"links": [],
"x": 1235,
"y": 680,
"wires": []
},
{
"id": "ee2d5b0149699bfd",
"type": "transform",
"z": "65b5beda2b73b7b5",
"name": "",
"actionSource": "Buffer",
"actionTarget": "Compressed",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 80,
"wires": [
[
"5dcab80a65f78002"
],
[
"10a0adbf5535121a"
]
]
},
{
"id": "8137c393bddb08a1",
"type": "debug",
"z": "65b5beda2b73b7b5",
"name": "debug",
"active": false,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 830,
"y": 260,
"wires": []
},
{
"id": "10a0adbf5535121a",
"type": "debug",
"z": "65b5beda2b73b7b5",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 850,
"y": 180,
"wires": []
},
{
"id": "aba26b9c6499adb1",
"type": "transform",
"z": "65b5beda2b73b7b5",
"name": "",
"actionSource": "Compressed",
"actionTarget": "Buffer",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 560,
"y": 200,
"wires": [
[
"2102f58ce572e09a"
],
[
"10a0adbf5535121a"
]
]
},
{
"id": "d38095883a4a54ac",
"type": "test",
"z": "65b5beda2b73b7b5",
"name": "test gzip",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[49,50,51,52,53,54,55,56,57,48,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,85,82,83,84,85,86,87,88,89,90,33,64,35,36,37,94,38,42,40,41,95,45,43,61,123,91,125,93,124,92,58,34,39,60,44,62,46,63,47,125]",
"payloadType": "bin",
"result": "[49,50,51,52,53,54,55,56,57,48,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,85,82,83,84,85,86,87,88,89,90,33,64,35,36,37,94,38,42,40,41,95,45,43,61,123,91,125,93,124,92,58,34,39,60,44,62,46,63,47,125]",
"resultType": "bin",
"resultProperty": "msg.payload",
"topic": "test gzip",
"x": 100,
"y": 100,
"wires": [
[
"f5ec776c8d6d933f"
],
[
"10a0adbf5535121a"
],
[
"95a62d934bb57fcd"
]
]
},
{
"id": "50672d0a987880df",
"type": "transform",
"z": "65b5beda2b73b7b5",
"name": "",
"actionSource": "Buffer",
"actionTarget": "Compressed",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzipSpeed",
"x": 360,
"y": 340,
"wires": [
[
"7a65c34df4ae2ce4"
],
[
"10a0adbf5535121a"
]
]
},
{
"id": "7a65c34df4ae2ce4",
"type": "transform",
"z": "65b5beda2b73b7b5",
"name": "",
"actionSource": "Compressed",
"actionTarget": "Buffer",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 380,
"y": 420,
"wires": [
[
"95a62d934bb57fcd"
],
[
"10a0adbf5535121a"
]
]
},
{
"id": "95a62d934bb57fcd",
"type": "test",
"z": "65b5beda2b73b7b5",
"name": "test gzip speed",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[49,50,51,52,53,54,55,56,57,48,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,85,82,83,84,85,86,87,88,89,90,33,64,35,36,37,94,38,42,40,41,95,45,43,61,123,91,125,93,124,92,58,34,39,60,44,62,46,63,47,125]",
"payloadType": "bin",
"result": "[49,50,51,52,53,54,55,56,57,48,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,85,82,83,84,85,86,87,88,89,90,33,64,35,36,37,94,38,42,40,41,95,45,43,61,123,91,125,93,124,92,58,34,39,60,44,62,46,63,47,125]",
"resultType": "bin",
"resultProperty": "msg.payload",
"topic": "test gzip speed",
"x": 120,
"y": 480,
"wires": [
[
"50672d0a987880df"
],
[
"10a0adbf5535121a"
],
[
"065ac327fbf17d38"
]
]
},
{
"id": "44b0be1b07c2ccc2",
"type": "transform",
"z": "65b5beda2b73b7b5",
"name": "",
"actionSource": "Buffer",
"actionTarget": "Compressed",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzipCompression",
"x": 400,
"y": 540,
"wires": [
[
"1a31abc23d7473a0"
],
[]
]
},
{
"id": "1a31abc23d7473a0",
"type": "transform",
"z": "65b5beda2b73b7b5",
"name": "",
"actionSource": "Compressed",
"actionTarget": "Buffer",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"maxMessages": 1000,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "json",
"skipLeading": 0,
"skipTrailing": 0,
"delimiter": ",",
"compressionType": "setGzip",
"x": 420,
"y": 620,
"wires": [
[
"065ac327fbf17d38"
],
[]
]
},
{
"id": "065ac327fbf17d38",
"type": "test",
"z": "65b5beda2b73b7b5",
"name": "test gzip compress",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[49,50,51,52,53,54,55,56,57,48,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,85,82,83,84,85,86,87,88,89,90,33,64,35,36,37,94,38,42,40,41,95,45,43,61,123,91,125,93,124,92,58,34,39,60,44,62,46,63,47,125]",
"payloadType": "bin",
"result": "[49,50,51,52,53,54,55,56,57,48,97,98,99,100,101,102,103,104,105,106,108,109,110,111,112,113,114,115,116,117,118,119,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,85,82,83,84,85,86,87,88,89,90,33,64,35,36,37,94,38,42,40,41,95,45,43,61,123,91,125,93,124,92,58,34,39,60,44,62,46,63,47,125]",
"resultType": "bin",
"resultProperty": "msg.payload",
"topic": "test gzip compress",
"x": 170,
"y": 680,
"wires": [
[
"44b0be1b07c2ccc2"
],
[
"10a0adbf5535121a"
],
[
"84bf5aaa74b38e59"
]
]
},
{
"id": "f5ec776c8d6d933f",
"type": "Monitor Flow",
"z": "65b5beda2b73b7b5",
"name": "",
"x": 310,
"y": 80,
"wires": [
[
"ee2d5b0149699bfd"
]
]
},
{
"id": "5dcab80a65f78002",
"type": "Monitor Flow",
"z": "65b5beda2b73b7b5",
"name": "",
"x": 330,
"y": 200,
"wires": [
[
"aba26b9c6499adb1"
]
]
},
{
"id": "2102f58ce572e09a",
"type": "Monitor Flow",
"z": "65b5beda2b73b7b5",
"name": "",
"x": 130,
"y": 280,
"wires": [
[
"d38095883a4a54ac",
"8137c393bddb08a1"
]
]
},
{
"id": "0c1e0f0f3543e49e",
"type": "link in",
"z": "65b5beda2b73b7b5",
"name": "transform compress",
"links": [],
"x": 75,
"y": 40,
"wires": [
[
"d38095883a4a54ac"
]
]
},
{
"id": "84bf5aaa74b38e59",
"type": "link out",
"z": "65b5beda2b73b7b5",
"name": "transform compress finished",
"mode": "return",
"links": [],
"x": 305,
"y": 760,
"wires": []
},
{
"id": "5ac2ef6c.d0953",
"type": "test",
"z": "e45553957f2b6fab",
"name": "",
"errorFactor": "",
"escapeString": false,
"payload": "{\"a\":1,\"b\":1}",
"payloadType": "json",
"result": "{\"a\":1,\"b\":1}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 280,
"y": 100,
"wires": [
[
"2ce3786.acae688"
],
[
"039806dcd68d6ff2"
],
[
"d49331e9f6193c4f"
]
]
},
{
"id": "2ce3786.acae688",
"type": "transform",
"z": "e45553957f2b6fab",
"name": "",
"actionSource": "JSON",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "JSON",
"sourceProperty": "",
"targetProperty": "",
"topicProperty": "",
"JSONataSource": "",
"JSONataTarget": "",
"index": "",
"maxMessages": "",
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": "",
"schema": "",
"schemaType": "str",
"skipLeading": "",
"skipTrailing": "",
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 640,
"y": 20,
"wires": [
[
"5ac2ef6c.d0953"
],
[
"039806dcd68d6ff2"
]
]
},
{
"id": "d49331e9f6193c4f",
"type": "test",
"z": "e45553957f2b6fab",
"name": "",
"errorFactor": "",
"escapeString": false,
"payload": "{\"in\":{\"a\":1,\"b\":1}}",
"payloadType": "json",
"result": "1",
"resultType": "num",
"resultProperty": "msg.payload",
"topic": "",
"x": 270,
"y": 240,
"wires": [
[
"670969e02ee29ad1"
],
[
"039806dcd68d6ff2"
],
[
"5e2a7ceef9de11bf"
]
]
},
{
"id": "670969e02ee29ad1",
"type": "transform",
"z": "e45553957f2b6fab",
"name": "",
"actionSource": "JSON",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "JSON",
"sourceProperty": "",
"targetProperty": "",
"topicProperty": "",
"JSONataSource": "in.a",
"JSONataSourceType": "jsonata",
"JSONataTarget": "",
"JSONataTargetType": "jsonata",
"index": "",
"maxMessages": "",
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": "",
"schema": "",
"schemaType": "str",
"skipLeading": "",
"skipTrailing": "",
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 640,
"y": 160,
"wires": [
[
"d49331e9f6193c4f"
],
[
"039806dcd68d6ff2"
]
]
},
{
"id": "039806dcd68d6ff2",
"type": "debug",
"z": "e45553957f2b6fab",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 930,
"y": 220,
"wires": []
},
{
"id": "b02379a693c4f95d",
"type": "link out",
"z": "e45553957f2b6fab",
"name": "link out 4",
"mode": "return",
"links": [],
"x": 545,
"y": 380,
"wires": []
},
{
"id": "8bc4d0adfbe612e5",
"type": "link in",
"z": "e45553957f2b6fab",
"name": "transform json",
"links": [],
"x": 75,
"y": 40,
"wires": [
[
"5ac2ef6c.d0953"
]
]
},
{
"id": "5e2a7ceef9de11bf",
"type": "test",
"z": "e45553957f2b6fab",
"name": "",
"errorFactor": "",
"escapeString": false,
"payload": "{\"in\":{\"a\":1,\"b\":1}}",
"payloadType": "json",
"result": "1",
"resultType": "num",
"resultProperty": "msg.payload",
"topic": "",
"x": 290,
"y": 360,
"wires": [
[
"96f0fb80a916acba"
],
[
"039806dcd68d6ff2"
],
[
"b02379a693c4f95d"
]
]
},
{
"id": "96f0fb80a916acba",
"type": "transform",
"z": "e45553957f2b6fab",
"name": "",
"actionSource": "JSON",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "JSON",
"sourceProperty": "",
"targetProperty": "",
"topicProperty": "",
"JSONataSource": "",
"JSONataSourceType": "jsonata",
"JSONataTarget": "in.a",
"JSONataTargetType": "jsonata",
"index": "",
"maxMessages": "",
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": "",
"schema": "",
"schemaType": "str",
"skipLeading": "",
"skipTrailing": "",
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 660,
"y": 280,
"wires": [
[
"5e2a7ceef9de11bf"
],
[
"039806dcd68d6ff2"
]
]
},
{
"id": "47a287530ed838e7",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Append",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "atest",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 40,
"wires": [
[
"9ec96a604b0f3e20"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "9ec96a604b0f3e20",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "abc",
"payloadType": "str",
"result": "abcatest",
"resultType": "str",
"resultProperty": "msg.payload",
"topic": "",
"x": 240,
"y": 40,
"wires": [
[
"47a287530ed838e7"
],
[
"925117734d8e96b5"
],
[
"8d8bb2e1192b3a8c"
]
]
},
{
"id": "925117734d8e96b5",
"type": "debug",
"z": "460ae66eec4b7f8a",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 890,
"y": 80,
"wires": []
},
{
"id": "8d8bb2e1192b3a8c",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"test\"}",
"payloadType": "json",
"result": "{\"b\":\"t\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 160,
"y": 120,
"wires": [
[
"517c89e4609e0e70"
],
[
"925117734d8e96b5"
],
[
"f78d540c53a64514"
]
]
},
{
"id": "517c89e4609e0e70",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "CharAt",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "a",
"stringType": "msg",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 120,
"wires": [
[
"8d8bb2e1192b3a8c"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "88582559dcf028bb",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "false",
"deleteSourceType": "bool",
"actionTarget": "Append",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "=>",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 200,
"wires": [
[
"f78d540c53a64514"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "f78d540c53a64514",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"test\"}",
"payloadType": "json",
"result": "{\"a\":\"test\",\"b\":\"test=>\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 200,
"wires": [
[
"88582559dcf028bb"
],
[
"925117734d8e96b5"
],
[
"270a0e8c4f3d5172"
]
]
},
{
"id": "270a0e8c4f3d5172",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"a test b\"}",
"payloadType": "json",
"result": "{\"b\":\"aTestB\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 280,
"wires": [
[
"daeadb001d8ec243"
],
[
"925117734d8e96b5"
],
[
"c64612fcd16ee4c2"
]
]
},
{
"id": "daeadb001d8ec243",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Camelize",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "=>",
"stringType": "msg",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 280,
"wires": [
[
"270a0e8c4f3d5172"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "c64612fcd16ee4c2",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"a test b\"}",
"payloadType": "json",
"result": "{\"b\":\"a test b<=>\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 360,
"wires": [
[
"4314006f6dc95d97"
],
[
"925117734d8e96b5"
],
[
"7c1ffb0b49742528"
]
]
},
{
"id": "4314006f6dc95d97",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Concat",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "<=>",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 360,
"wires": [
[
"c64612fcd16ee4c2"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "5a4cf5bbdd78ca08",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "CharCodeAt",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": "1",
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 440,
"wires": [
[
"7c1ffb0b49742528"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "d950412c4738c78f",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "CodePointAt",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": "1",
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 520,
"wires": [
[
"2a5e51b612e3b1f8"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "072e7d19acea716f",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "DateLocal",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"JSONataSource": "",
"JSONataTarget": "",
"index": "1",
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 600,
"wires": [
[
"dc4920acde5f87e4"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "9ccff6c8a9b460b8",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "DelimiterOnCase",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"JSONataSource": "",
"JSONataSourceType": "jsonata",
"JSONataTarget": "",
"JSONataTargetType": "jsonata",
"index": "1",
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 530,
"y": 680,
"wires": [
[
"71bde3f27fe075fc"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "dcbfe2ea6795fcb4",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "EndsWith",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": "1",
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "def",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 760,
"wires": [
[
"8c10fe666d441dac"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "4c20187ba4f4d732",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Prepend",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": "1",
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "=>",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 840,
"wires": [
[
"ebeebbbddab24c44"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "34db4f79e104b88d",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Integer",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": "1",
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 920,
"wires": [
[
"186e62ee33add8f7"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "fd3ddc020e4e4dd5",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "LowerCase",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": "1",
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 1000,
"wires": [
[
"1c3dd74d3d062367"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "7c1ffb0b49742528",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"abcde\"}",
"payloadType": "json",
"result": "{\"b\":98}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 170,
"y": 440,
"wires": [
[
"5a4cf5bbdd78ca08"
],
[
"925117734d8e96b5"
],
[
"2a5e51b612e3b1f8"
]
]
},
{
"id": "2a5e51b612e3b1f8",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"a test b\"}",
"payloadType": "json",
"result": "{\"b\":32}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 170,
"y": 520,
"wires": [
[
"d950412c4738c78f"
],
[
"925117734d8e96b5"
],
[
"dc4920acde5f87e4"
]
]
},
{
"id": "dc4920acde5f87e4",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"1/1/2001\"}",
"payloadType": "json",
"result": "$boolean(b.toLocaleDateString()=\"01/01/2001\")",
"resultType": "jsonata",
"resultProperty": "msg.payload",
"topic": "",
"x": 170,
"y": 600,
"wires": [
[
"072e7d19acea716f"
],
[
"925117734d8e96b5"
],
[
"71bde3f27fe075fc"
]
]
},
{
"id": "71bde3f27fe075fc",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"aBcdEFghIK\"}",
"payloadType": "json",
"result": "{\"b\": \"a,bcd,e,fgh,i,k\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 680,
"wires": [
[
"9ccff6c8a9b460b8"
],
[
"925117734d8e96b5"
],
[
"8c10fe666d441dac"
]
]
},
{
"id": "8c10fe666d441dac",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"abd1def\"}",
"payloadType": "json",
"result": "{\"b\":true}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 760,
"wires": [
[
"dcbfe2ea6795fcb4"
],
[
"925117734d8e96b5"
],
[
"ebeebbbddab24c44"
]
]
},
{
"id": "ebeebbbddab24c44",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"abc\"}",
"payloadType": "json",
"result": "{\"b\":\"=>abc\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 840,
"wires": [
[
"4c20187ba4f4d732"
],
[
"925117734d8e96b5"
],
[
"186e62ee33add8f7"
]
]
},
{
"id": "186e62ee33add8f7",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"2\"}",
"payloadType": "json",
"result": "{\"b\":2}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 150,
"y": 920,
"wires": [
[
"34db4f79e104b88d"
],
[],
[
"1c3dd74d3d062367"
]
]
},
{
"id": "1c3dd74d3d062367",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"aB cDE\"}",
"payloadType": "json",
"result": "{\"b\":\"ab cde\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 1000,
"wires": [
[
"fd3ddc020e4e4dd5"
],
[
"925117734d8e96b5"
],
[
"dcc18294163735c9"
]
]
},
{
"id": "b732e54471eaf713",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Number",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 1080,
"wires": [
[
"dcc18294163735c9"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "82f01872c3438970",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Prepend",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "=>",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 1160,
"wires": [
[
"17ef03a12d2fd756"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "8d73196a973a986c",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "JSON",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 500,
"y": 1240,
"wires": [
[
"a923ee497b800af4"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "5d5a3f0c8be254da",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Split",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "c",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 490,
"y": 1320,
"wires": [
[
"d99bc55ce55d29c4"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "2fd3ea0697259d9f",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "StartsWith",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 1400,
"wires": [
[
"43a88afb923333b5"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "df13affa93676080",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "StartsWith",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "cba",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 1480,
"wires": [
[
"22baecbb272c0ce0"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "022939c0c11b13d3",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Trim",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 490,
"y": 1560,
"wires": [
[
"96cf6753b9b42df8"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "20c87f4f42eeb3a9",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "TrimEnd",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 1640,
"wires": [
[
"c7d663c8e599aa49"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "48a74d7f7044b629",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "TrimStart",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 1720,
"wires": [
[
"045e7a72b5b8a9a0"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "c248c9dac1aed77b",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "UpperCase",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 1800,
"wires": [
[
"03f40508ed9626ba"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "dcc18294163735c9",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"2\"}",
"payloadType": "json",
"result": "{\"b\":2}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 150,
"y": 1080,
"wires": [
[
"b732e54471eaf713"
],
[
"925117734d8e96b5"
],
[
"17ef03a12d2fd756"
]
]
},
{
"id": "17ef03a12d2fd756",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": 0,
"escapeString": true,
"infiniteIsNull": false,
"payload": "{\"a\":\"2\"}",
"payloadType": "json",
"result": "{\"b\":\"=>2\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 160,
"y": 1160,
"wires": [
[
"82f01872c3438970"
],
[
"925117734d8e96b5"
],
[
"a923ee497b800af4"
]
]
},
{
"id": "a923ee497b800af4",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"[{\\\"a\\\":1}]\"}",
"payloadType": "json",
"result": "{\"b\":[{\"a\":1}]}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 1240,
"wires": [
[
"8d73196a973a986c"
],
[
"925117734d8e96b5"
],
[
"d99bc55ce55d29c4"
]
]
},
{
"id": "d99bc55ce55d29c4",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"abcde\"}",
"payloadType": "json",
"result": "{\"b\":[\"ab\",\"de\"]}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 1320,
"wires": [
[
"5d5a3f0c8be254da"
],
[
"925117734d8e96b5"
],
[
"43a88afb923333b5"
]
]
},
{
"id": "43a88afb923333b5",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"abcde\"}",
"payloadType": "json",
"result": "{\"b\":true}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 170,
"y": 1400,
"wires": [
[
"2fd3ea0697259d9f"
],
[
"925117734d8e96b5"
],
[
"22baecbb272c0ce0"
]
]
},
{
"id": "22baecbb272c0ce0",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"abcde\"}",
"payloadType": "json",
"result": "{\"b\":false}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 1480,
"wires": [
[
"df13affa93676080"
],
[
"925117734d8e96b5"
],
[
"96cf6753b9b42df8"
]
]
},
{
"id": "96cf6753b9b42df8",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\" abcde \"}",
"payloadType": "json",
"result": "{\"b\":\"abcde\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 1560,
"wires": [
[
"022939c0c11b13d3"
],
[
"925117734d8e96b5"
],
[
"c7d663c8e599aa49"
]
]
},
{
"id": "c7d663c8e599aa49",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\" abcde \"}",
"payloadType": "json",
"result": "{\"b\":\" abcde\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 1640,
"wires": [
[
"20c87f4f42eeb3a9"
],
[
"925117734d8e96b5"
],
[
"045e7a72b5b8a9a0"
]
]
},
{
"id": "045e7a72b5b8a9a0",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\" abcde \"}",
"payloadType": "json",
"result": "{\"b\":\"abcde \"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 1720,
"wires": [
[
"48a74d7f7044b629"
],
[
"925117734d8e96b5"
],
[
"03f40508ed9626ba"
]
]
},
{
"id": "03f40508ed9626ba",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"aBcDe \"}",
"payloadType": "json",
"result": "{\"b\":\"ABCDE \"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 200,
"y": 1800,
"wires": [
[
"c248c9dac1aed77b"
],
[
"925117734d8e96b5"
],
[
"c15c5c00703885bf"
]
]
},
{
"id": "0b537acc6037c2fa",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Capitalize",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 510,
"y": 1880,
"wires": [
[
"c15c5c00703885bf"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "c15c5c00703885bf",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"test woRD\"}",
"payloadType": "json",
"result": "{\"b\":\"Test woRD\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 1880,
"wires": [
[
"0b537acc6037c2fa"
],
[
"925117734d8e96b5"
],
[
"9480159a4a5fbe51"
]
]
},
{
"id": "30c617bfafa92ac9",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "Deunderscore",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 1960,
"wires": [
[
"9480159a4a5fbe51"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "9480159a4a5fbe51",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"testing_change_again\"}",
"payloadType": "json",
"result": "{\"b\":\"testing change again\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 1960,
"wires": [
[
"30c617bfafa92ac9"
],
[
"925117734d8e96b5"
],
[
"985b4d8a6a9d4b61"
]
]
},
{
"id": "c5a6c9d55ea9668f",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "DeunderscoreCapitilize",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 550,
"y": 2040,
"wires": [
[
"985b4d8a6a9d4b61"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "985b4d8a6a9d4b61",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"a_sentence_with_underscore\"}",
"payloadType": "json",
"result": "{\"b\":\"A Sentence With Underscore\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 190,
"y": 2040,
"wires": [
[
"c5a6c9d55ea9668f"
],
[
"925117734d8e96b5"
],
[
"1f88e3bbc985ab53"
]
]
},
{
"id": "47657776668b794b",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "DropSquareBracketPrefix",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 560,
"y": 2120,
"wires": [
[
"1f88e3bbc985ab53"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "1f88e3bbc985ab53",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"[a] Atest\"}",
"payloadType": "json",
"result": "{\"b\":\"Atest\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 2120,
"wires": [
[
"47657776668b794b"
],
[
"925117734d8e96b5"
],
[
"e3bf18165cc21384"
]
]
},
{
"id": "972d66bf01ceaff7",
"type": "transform",
"z": "460ae66eec4b7f8a",
"name": "",
"actionSource": "String",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "RangeLimit",
"sourceProperty": "msg.payload.a",
"targetProperty": "msg.payload.b",
"topicProperty": "msg.topic",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": "",
"minNumber": "",
"maxString": "bc",
"minString": "a",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "abc",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 2200,
"wires": [
[
"e3bf18165cc21384"
],
[
"925117734d8e96b5"
]
]
},
{
"id": "e3bf18165cc21384",
"type": "test",
"z": "460ae66eec4b7f8a",
"name": "",
"errorFactor": "-1",
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"a\":\"atest\"}",
"payloadType": "json",
"result": "{\"b\":\"atest\"}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 180,
"y": 2200,
"wires": [
[
"972d66bf01ceaff7"
],
[
"925117734d8e96b5"
],
[
"bee4fdd51ea59704"
]
]
},
{
"id": "e057797d0b796145",
"type": "link in",
"z": "460ae66eec4b7f8a",
"name": "transform string in",
"links": [],
"x": 55,
"y": 40,
"wires": [
[
"9ec96a604b0f3e20"
]
]
},
{
"id": "bee4fdd51ea59704",
"type": "link out",
"z": "460ae66eec4b7f8a",
"name": "transform string",
"mode": "return",
"links": [],
"x": 335,
"y": 2340,
"wires": []
},
{
"id": "3db2b919.ea68d6",
"type": "debug",
"z": "924bb2b7.03fd1",
"name": "error",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 730,
"y": 420,
"wires": []
},
{
"id": "32a48f00e9c32747",
"type": "Monitor Flow",
"z": "924bb2b7.03fd1",
"name": "",
"x": 590,
"y": 20,
"wires": [
[
"7794ab9c1ff64390"
]
]
},
{
"id": "4e471cf4f77579e9",
"type": "link out",
"z": "924bb2b7.03fd1",
"name": "transform xlsx finish",
"mode": "return",
"links": [],
"x": 745,
"y": 60,
"wires": []
},
{
"id": "0e4f57304e89edb8",
"type": "test",
"z": "924bb2b7.03fd1",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"worksheet1\":[[11,12],[21,22],[31,32]],\"worksheet2\":[[11,12],[21,22]]}",
"payloadType": "json",
"result": "{\"worksheet1\":[[11,12],[21,22],[31,32]],\"worksheet2\":[[11,12],[21,22]]}",
"resultType": "json",
"resultProperty": "msg.payload",
"topic": "",
"x": 260,
"y": 40,
"wires": [
[
"32a48f00e9c32747"
],
[
"3db2b919.ea68d6"
],
[
"4e471cf4f77579e9"
]
]
},
{
"id": "7794ab9c1ff64390",
"type": "transform",
"z": "924bb2b7.03fd1",
"name": "",
"actionSource": "Array",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "XLSX",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"JSONataSource": "",
"JSONataSourceType": "jsonata",
"JSONataTarget": "",
"JSONataTargetType": "jsonata",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 520,
"y": 140,
"wires": [
[
"69cf00efd482d012"
],
[
"3db2b919.ea68d6"
]
]
},
{
"id": "000cda4258683bde",
"type": "transform",
"z": "924bb2b7.03fd1",
"name": "",
"actionSource": "XLSX",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "XLSXObject",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"JSONataSource": "",
"JSONataSourceType": "jsonata",
"JSONataTarget": "",
"JSONataTargetType": "jsonata",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 380,
"y": 220,
"wires": [
[
"7208e9201d7f1fcf"
],
[
"3db2b919.ea68d6"
]
]
},
{
"id": "dd556f2fb8c84838",
"type": "transform",
"z": "924bb2b7.03fd1",
"name": "",
"actionSource": "XLSXObject",
"deleteSource": "true",
"deleteSourceType": "bool",
"actionTarget": "JSON",
"sourceProperty": "msg.payload",
"targetProperty": "msg.payload",
"topicProperty": "msg.topic",
"JSONataSource": "",
"JSONataSourceType": "jsonata",
"JSONataTarget": "",
"JSONataTargetType": "jsonata",
"index": 0,
"maxMessages": 1000,
"maxDate": "",
"minDate": "",
"maxNumber": 0,
"minNumber": 0,
"maxString": "",
"minString": "",
"radix": 10,
"schema": "{\"type\":\"record\",\"fields\":[{\"name\":\"name\",\"type\":\"string\"}]}",
"schemaType": "str",
"skipLeading": 0,
"skipTrailing": 0,
"string": "",
"stringType": "str",
"delimiter": ",",
"compressionType": "setGzip",
"x": 160,
"y": 320,
"wires": [
[
"0e4f57304e89edb8"
],
[
"3db2b919.ea68d6"
]
]
},
{
"id": "7208e9201d7f1fcf",
"type": "Monitor Flow",
"z": "924bb2b7.03fd1",
"name": "",
"x": 750,
"y": 220,
"wires": [
[
"dd556f2fb8c84838"
]
]
},
{
"id": "69cf00efd482d012",
"type": "Monitor Flow",
"z": "924bb2b7.03fd1",
"name": "",
"x": 750,
"y": 140,
"wires": [
[
"000cda4258683bde"
]
]
},
{
"id": "6ed524d3e461526d",
"type": "link in",
"z": "924bb2b7.03fd1",
"name": "transform xlsx",
"links": [],
"x": 45,
"y": 40,
"wires": [
[
"0e4f57304e89edb8"
]
]
},
{
"id": "835d891c3b7b9451",
"type": "debug",
"z": "d98540e8ed31a4a1",
"name": "debug 3",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 740,
"y": 420,
"wires": []
},
{
"id": "b850a29956571494",
"type": "logisticRegression",
"z": "d98540e8ed31a4a1",
"name": "",
"modelName": "test",
"action": "fit",
"learningRate": 0.1,
"iterations": 2000,
"fitIntercept": true,
"l2": 0,
"tolerance": 1e-7,
"verbose": false,
"threshold": 0.5,
"x": 420,
"y": 180,
"wires": [
[
"835d891c3b7b9451",
"1c969461651d15fa"
]
]
},
{
"id": "1c969461651d15fa",
"type": "test",
"z": "d98540e8ed31a4a1",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "{\"X\":[[0,0],[0,1],[1,0],[1,1]],\"y\":[0,1,1,1]}",
"payloadType": "json",
"result": "Model fitted and stored as: test",
"resultType": "str",
"resultProperty": "msg.result",
"topic": "",
"x": 180,
"y": 80,
"wires": [
[
"b850a29956571494"
],
[],
[
"f903d1b11568c38c"
]
]
},
{
"id": "a4ff87db6b6a4889",
"type": "logisticRegression",
"z": "d98540e8ed31a4a1",
"name": "",
"modelName": "test",
"action": "predict",
"learningRate": 0.1,
"iterations": 2000,
"fitIntercept": true,
"l2": 0,
"tolerance": 1e-7,
"verbose": false,
"threshold": 0.5,
"x": 460,
"y": 360,
"wires": [
[
"835d891c3b7b9451",
"f903d1b11568c38c",
"21167b6b6f5c0cbc"
]
]
},
{
"id": "f903d1b11568c38c",
"type": "test",
"z": "d98540e8ed31a4a1",
"name": "",
"errorFactor": 0,
"escapeString": false,
"infiniteIsNull": false,
"payload": "[[0, 0], [1, 1], [0.5, 0.5]]",
"payloadType": "json",
"result": "[0,1,1]",
"resultType": "json",
"resultProperty": "msg.result",
"topic": "",
"x": 140,
"y": 280,
"wires": [
[
"a4ff87db6b6a4889"
],
[],
[]
]
},
{
"id": "21167b6b6f5c0cbc",
"type": "logisticRegression",
"z": "d98540e8ed31a4a1",
"name": "",
"modelName": "test",
"action": "predictProba",
"learningRate": 0.1,
"iterations": 2000,
"fitIntercept": true,
"l2": 0,
"tolerance": 1e-7,
"verbose": false,
"threshold": 0.5,
"x": 440,
"y": 480,
"wires": [
[
"835d891c3b7b9451"
]
]
},
{
"id": "6dcc4342cb95db99",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "appendFile",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"x": 350,
"y": 180,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "f7056a42ba573367",
"type": "debug",
"z": "8aa8799ad5afca2b",
"name": "debug 4",
"active": true,
"tosidebar": true,
"console": false,
"tostatus": false,
"complete": "true",
"targetType": "full",
"statusVal": "",
"statusType": "auto",
"x": 700,
"y": 360,
"wires": []
},
{
"id": "69adf3d24df340b6",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "{\"records\":[{\"name\":\"John\",\"age\":30,\"city\":\"NYC\"},{\"name\":\"Jane\",\"age\":25,\"city\":\"LA\"}]}",
"payloadType": "json",
"x": 90,
"y": 180,
"wires": [
[
"6dcc4342cb95db99"
]
]
},
{
"id": "c4db16448a22def4",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 100,
"y": 280,
"wires": [
[
"cb96c887a71c3cba"
]
]
},
{
"id": "cb96c887a71c3cba",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "readFile",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"x": 340,
"y": 280,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "a7c85ce48c4baa7b",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "sqlQuery",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"sqlQuery": "select * from ? limit 4",
"outputProperty": "",
"x": 340,
"y": 360,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "17aa1ae56c2be540",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "{\"sql\":\"SELECT COUNT(*) AS cnt FROM ? a LIMIT 10\"}",
"payloadType": "json",
"x": 90,
"y": 360,
"wires": [
[
"a7c85ce48c4baa7b"
]
]
},
{
"id": "50413b0ca082d563",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "sqlQuery",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"sqlQuery": "SELECT \"a1\" as test,:msg.payload as name,COUNT(*) AS cnt1 FROM ? a where name= :msg.payload",
"outputProperty": "payload",
"parameterMappings": [
{
"paramName": "name",
"msgPath": "payload"
}
],
"x": 370,
"y": 500,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "34909ff6e5e0f6a7",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "John",
"payloadType": "str",
"x": 90,
"y": 520,
"wires": [
[
"50413b0ca082d563",
"a1caf329e4e87dbc"
]
]
},
{
"id": "a1caf329e4e87dbc",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "sqlQuery",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"sqlQuery": "SELECT :msg.payload as tes from ? limit 5",
"outputProperty": "payload",
"parameterMappings": [
{
"paramName": "name",
"msgPath": "payload"
}
],
"x": 370,
"y": 580,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "ce0e3fb3e004b4af",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "sqlQuery",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"sqlQuery": "SELECT a.name,COUNT(*) AS cnt FROM ? a group by name",
"outputProperty": "payload",
"parameterMappings": [
{
"paramName": "name",
"msgPath": "payload"
}
],
"x": 420,
"y": 740,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "343f59f36e7293df",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "sqlQuery",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"sqlQuery": "select a.name from ? a where name=\"John\" limit 4",
"outputProperty": "",
"x": 420,
"y": 660,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "babd195c3d0980dd",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "",
"payloadType": "date",
"x": 120,
"y": 660,
"wires": [
[
"343f59f36e7293df",
"ce0e3fb3e004b4af"
]
]
},
{
"id": "0960f3c3ca9ba2dc",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "John",
"payloadType": "str",
"x": 90,
"y": 480,
"wires": [
[
"50413b0ca082d563"
]
]
},
{
"id": "a61df296c3a578e2",
"type": "columnar",
"z": "8aa8799ad5afca2b",
"name": "",
"action": "sqlQuery",
"filePath": "C:\\Users\\peter\\data\\columnarStore\\test",
"sqlQuery": "SELECT \"a1\" as test,:msg.payload as name, FROM ? a where name= :msg.payload",
"outputProperty": "payload",
"parameterMappings": [
{
"paramName": "name",
"msgPath": "payload"
}
],
"x": 370,
"y": 440,
"wires": [
[
"f7056a42ba573367"
]
]
},
{
"id": "e88b60b96a6ce42a",
"type": "inject",
"z": "8aa8799ad5afca2b",
"name": "",
"props": [
{
"p": "payload"
},
{
"p": "topic",
"vt": "str"
}
],
"repeat": "",
"crontab": "",
"once": false,
"onceDelay": 0.1,
"topic": "",
"payload": "John",
"payloadType": "str",
"x": 90,
"y": 420,
"wires": [
[
"a61df296c3a578e2"
]
]
}
]