{"version":4,"machines":[{"machine":{"id":"SJkk198Hj","name":"JSON Array Splitter","state":"stopped","metadata":{"owner":"anon","lastModified":1667996729253,"lastModifiedBy":"unknown","fileVersion":"3.0.0"},"streamsheets":[{"id":"B1xJ1c8Hs","name":"ARRAYSIMULATION","loop":{"path":"","enabled":false,"recursively":false},"inbox":{"max":20,"type":"MessageBox","id":"r1geJJ5IHo","stream":null},"sheet":{"cells":{"A2":{"value":"JSON Divider","type":"string"},"A4":{"value":"Sometimes it makes sense to divide a JSON Array into multiple Messages, to calculate each Array element individually. ","type":"string"},"A5":{"value":"This sheet sends every second a new message to the \"divider\" sheet.","type":"string"},"A8":{"value":"Simulated Array","type":"string"},"A10":{"value":"ArrayData","type":"string"},"A11":{"value":0,"type":"number"},"A12":{"value":"Temp","type":"string"},"B12":{"formula":"RANDBETWEEN(1,12)","value":6,"type":"undefined"},"A13":{"value":"id","type":"string"},"B13":{"value":"ID1","type":"string"},"A14":{"value":1,"type":"number"},"A15":{"value":"Temp","type":"string"},"B15":{"formula":"RANDBETWEEN(1,12)","value":8,"type":"undefined"},"A16":{"value":"id","type":"string"},"B16":{"value":"ID2","type":"string"},"A17":{"value":2,"type":"number"},"A18":{"value":"Temp","type":"string"},"B18":{"formula":"RANDBETWEEN(1,12)","value":12,"type":"undefined"},"A19":{"value":"id","type":"string"},"B19":{"value":"ID3","type":"string"},"A20":{"value":3,"type":"number"},"A21":{"value":"Temp","type":"string"},"B21":{"formula":"RANDBETWEEN(1,12)","value":7,"type":"undefined"},"A22":{"value":"id","type":"string"},"B22":{"value":"ID4","type":"string"},"C24":{"formula":"FEEDINBOX(ARRAYSIMULATION!A10:B22,SPLITTER!)","value":true,"type":"undefined","references":["SPLITTER!"]}},"namedCells":{},"shapes":{"shapes":[],"timestamp":0,"version":0},"properties":{"cols":[{"ref":{"col":"C"},"properties":{"attributes":{"size":2449.791666666666,"visible":true}}}],"rows":[{"ref":{"row":2},"properties":{"attributes":{"size":602.7083333333333,"visible":true}}}],"cells":[{"ref":{"col":"A","row":2},"properties":{"textFormats":{"fontsize":12}}},{"ref":{"col":"A","row":8},"properties":{"textFormats":{"fontstyle":1}}},{"ref":{"col":"A","row":10},"properties":{"attributes":{"key":true}}},{"ref":{"col":"B","row":10},"properties":{"attributes":{"key":true}}},{"ref":{"col":"A","row":11},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"B","row":11},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"A","row":12},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":12},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":13},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":13},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":14},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"B","row":14},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"A","row":15},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":15},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":16},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":16},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":17},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"B","row":17},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"A","row":18},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":18},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":19},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":19},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":20},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"B","row":20},"properties":{"attributes":{"key":true,"level":1}}},{"ref":{"col":"A","row":21},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":21},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"A","row":22},"properties":{"attributes":{"key":true,"level":2}}},{"ref":{"col":"B","row":22},"properties":{"attributes":{"key":true,"level":2}}}]},"settings":{"maxchars":1000,"minrow":1,"maxrow":100,"mincol":-2,"maxcol":50,"protected":false}},"trigger":{"type":"interval","repeat":"once","interval":1000,"intervalUnit":"ms","useDefaultInterval":true},"settings":{"maximize":false,"showGrid":true,"showHeader":true,"showInbox":true,"showFormulas":false,"greyIfRows":true,"hideMessages":false},"custom":{}},{"id":"B1xWylcLBo","name":"SPLITTER","loop":{"path":"Data.ArrayData","enabled":true,"recursively":false},"inbox":{"max":20,"type":"Inbox","id":"HJb-Jxc8ri","stream":null},"sheet":{"cells":{"A3":{"value":"The divider sheet uses \"on message arrival\" as a calulation mode. ","type":"string"},"A4":{"value":"To divide the message the \"Loop element\" is set.","type":"string"},"A8":{"formula":"READ(INBOXDATA(,,,\"Temp\"),B8,\"Number\",,TRUE)","value":"Temp","type":"undefined"},"B8":{"value":7,"type":"number"},"A9":{"formula":"READ(INBOXDATA(,,,\"id\"),B9,\"String\",,TRUE)","value":"id","type":"undefined"},"B9":{"value":"ID4","type":"string"},"B13":{"formula":"FEEDINBOX(SPLITTER!A8:B9,RECIEVER!)","value":true,"type":"undefined","references":["RECIEVER!"]}},"namedCells":{},"shapes":{"shapes":[],"timestamp":0,"version":1,"changed":298766175671},"properties":{"cols":[],"rows":[],"cells":[{"ref":{"col":"A","row":7},"properties":{"attributes":{"level":0,"key":false}}},{"ref":{"col":"B","row":7},"properties":{"attributes":{"key":false,"level":0}}},{"ref":{"col":"A","row":8},"properties":{"attributes":{"level":0,"key":true}}},{"ref":{"col":"B","row":8},"properties":{"attributes":{"key":true,"level":0}}},{"ref":{"col":"A","row":9},"properties":{"attributes":{"level":0,"key":true}}},{"ref":{"col":"B","row":9},"properties":{"attributes":{"key":true,"level":0}}}]},"settings":{"maxchars":1000,"minrow":1,"maxrow":100,"mincol":-2,"maxcol":50,"protected":false}},"trigger":{"type":"arrival","repeat":"once"},"settings":{"maximize":false,"showGrid":true,"showHeader":true,"showInbox":true,"showFormulas":false,"greyIfRows":true,"hideMessages":false},"custom":{"jsg":{"pin":{"p":{"x":{"v":"10500"},"y":{"v":"6500"}},"lp":{"x":{"f":"!WIDTH*0.5","v":"10500"},"y":{"f":"!HEIGHT*0.5","v":"6500"}}},"type":"sheet","inboxcontainer":{"split":5000,"width":6322.916666666666}}}},{"id":"H1xHixqUBi","name":"RECIEVER","loop":{"path":"","enabled":false,"recursively":false},"inbox":{"max":20,"type":"Inbox","id":"HkbBjl58Bs","stream":null},"sheet":{"cells":{"A2":{"value":"The reciever sheet uses \"on message arrival\" as a calulation mode. ","type":"string"},"A3":{"value":"Array elements are recieved in single messages and put in a small history.","type":"string"},"A6":{"formula":"READ(INBOXDATA(,),,\"Dictionary\",,TRUE)","value":"Data","type":"undefined"},"A7":{"formula":"READ(INBOXDATA(,,\"Temp\"),B7,\"Number\",,TRUE)","value":"Temp","type":"undefined"},"B7":{"value":7,"type":"number"},"A8":{"formula":"READ(INBOXDATA(,,\"id\"),B8,\"String\",,TRUE)","value":"id","type":"undefined"},"B8":{"value":"ID4","type":"string"},"A9":{"formula":"READ(INBOXMETADATA(,,\"arrivalTime\"),B9,\"Number\",,TRUE)","value":"arrivalTime","type":"undefined"},"B9":{"value":44872.59260089121,"type":"number"},"C11":{"value":"Temp","type":"string"},"D11":{"value":"id","type":"string"},"E11":{"value":"time","type":"string"},"C12":{"formula":"C13","value":3,"type":"reference"},"D12":{"formula":"D13","value":"ID4","type":"reference"},"E12":{"formula":"E13","value":44872.592565949075,"type":"reference"},"C13":{"formula":"C14","value":6,"type":"reference"},"D13":{"formula":"D14","value":"ID1","type":"reference"},"E13":{"formula":"E14","value":44872.59257748842,"type":"reference"},"C14":{"formula":"C15","value":6,"type":"reference"},"D14":{"formula":"D15","value":"ID2","type":"reference"},"E14":{"formula":"E15","value":44872.59257753472,"type":"reference"},"C15":{"formula":"C16","value":4,"type":"reference"},"D15":{"formula":"D16","value":"ID3","type":"reference"},"E15":{"formula":"E16","value":44872.59257758102,"type":"reference"},"C16":{"formula":"C17","value":5,"type":"reference"},"D16":{"formula":"D17","value":"ID4","type":"reference"},"E16":{"formula":"E17","value":44872.59257761574,"type":"reference"},"C17":{"formula":"C18","value":4,"type":"reference"},"D17":{"formula":"D18","value":"ID1","type":"reference"},"E17":{"formula":"E18","value":44872.59258913195,"type":"reference"},"C18":{"formula":"C19","value":6,"type":"reference"},"D18":{"formula":"D19","value":"ID2","type":"reference"},"E18":{"formula":"E19","value":44872.59258917824,"type":"reference"},"C19":{"formula":"C20","value":12,"type":"reference"},"D19":{"formula":"D20","value":"ID3","type":"reference"},"E19":{"formula":"E20","value":44872.59258923611,"type":"reference"},"C20":{"formula":"C21","value":2,"type":"reference"},"D20":{"formula":"D21","value":"ID4","type":"reference"},"E20":{"formula":"E21","value":44872.592589259264,"type":"reference"},"C21":{"formula":"C22","value":6,"type":"reference"},"D21":{"formula":"D22","value":"ID1","type":"reference"},"E21":{"formula":"E22","value":44872.592600752316,"type":"reference"},"C22":{"formula":"C23","value":8,"type":"reference"},"D22":{"formula":"D23","value":"ID2","type":"reference"},"E22":{"formula":"E23","value":44872.59260081018,"type":"reference"},"C23":{"formula":"RECIEVER!C24","value":12,"type":"reference"},"D23":{"formula":"D24","value":"ID3","type":"reference"},"E23":{"formula":"E24","value":44872.592600856486,"type":"reference"},"C24":{"formula":"RECIEVER!B7","value":7,"type":"reference"},"D24":{"formula":"RECIEVER!B8","value":"ID4","type":"reference"},"E24":{"formula":"RECIEVER!B9","value":44872.59260089121,"type":"reference"}},"namedCells":{},"shapes":{"shapes":[],"timestamp":0,"version":1,"changed":116878116494},"properties":{"cols":[],"rows":[],"cells":[{"ref":{"col":"A","row":6},"properties":{"attributes":{"level":0,"key":true}}},{"ref":{"col":"B","row":6},"properties":{"attributes":{"key":true}}},{"ref":{"col":"A","row":7},"properties":{"attributes":{"level":1,"key":true}}},{"ref":{"col":"B","row":7},"properties":{"attributes":{"key":true}}},{"ref":{"col":"A","row":8},"properties":{"attributes":{"level":1,"key":true}}},{"ref":{"col":"B","row":8},"properties":{"attributes":{"key":true}}},{"ref":{"col":"C","row":11},"properties":{"textFormats":{"fontstyle":1}}},{"ref":{"col":"D","row":11},"properties":{"textFormats":{"fontstyle":1}}},{"ref":{"col":"E","row":11},"properties":{"textFormats":{"fontstyle":1}}},{"ref":{"col":"E","row":12},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":13},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":14},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":15},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":16},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":17},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":18},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":19},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":20},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":21},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":22},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":23},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}},{"ref":{"col":"E","row":24},"properties":{"textFormats":{"numberformat":"h:mm:ss","localculture":"time;de"}}}]},"settings":{"maxchars":1000,"minrow":1,"maxrow":100,"mincol":-2,"maxcol":50,"protected":false}},"trigger":{"type":"arrival","repeat":"once"},"settings":{"maximize":false,"showGrid":true,"showHeader":true,"showInbox":true,"showFormulas":false,"greyIfRows":true,"hideMessages":false},"custom":{"jsg":{"pin":{"p":{"x":{"v":"10500"},"y":{"v":"6500"}},"lp":{"x":{"f":"!WIDTH*0.5","v":"10500"},"y":{"f":"!HEIGHT*0.5","v":"6500"}}},"type":"sheet"}}}],"settings":{"view":{"maximize":"B1xJ1c8Hs","showInbox":false,"showGrid":false,"showHeader":false,"showOutbox":false,"allowZoom":false,"allowScroll":true},"locale":"en","isOPCUA":false,"defaultInterval":1000,"showOutbox":false,"description":"","maximizeSheet":"none","tour":{},"image":"","categories":[]},"extensionSettings":{},"custom":{},"className":"Machine","scope":{"id":"BJ62rcEgo"},"namedCells":{},"integrations":[]},"connections":[]}]}