From array message, get specific columns

#1

Hello, my flow is the one at links. At the top part of the flow, i want to get from message array, the columns named “high” and “low”. What I have done returns only the first row of 60+ messages and I don’t know really know why. Thanks in advance

flow:

[{"id":"165c94f7.186b9b","type":"tab","label":"Flow 1","disabled":false,"info":""},{"id":"ed79f38d.c1016","type":"twitter-credentials","z":"","screen_name":""},{"id":"13932bb4.7a4fc4","type":"http request","z":"165c94f7.186b9b","name":"Google","method":"GET","ret":"obj","url":"https://api.iextrading.com/1.0/stock/goog/chart/3m","tls":"","x":260,"y":20,"wires":[[]]},{"id":"507328db.58d318","type":"http request","z":"165c94f7.186b9b","name":"Microsoft","method":"GET","ret":"obj","url":"https://api.iextrading.com/1.0/stock/msft/chart/3m","tls":"","x":260,"y":80,"wires":[[]]},{"id":"e3cef2f1.c1fd","type":"http request","z":"165c94f7.186b9b","name":"Facebook","method":"GET","ret":"obj","url":"https://api.iextrading.com/1.0/stock/fb/chart/3m","tls":"","x":260,"y":140,"wires":[[]]},{"id":"a1698c9b.c06f","type":"http request","z":"165c94f7.186b9b","name":"Apple","method":"GET","ret":"obj","url":"https://api.iextrading.com/1.0/stock/aapl/chart/3m","tls":"","x":250,"y":200,"wires":[[]]},{"id":"26b551b1.47b93e","type":"debug","z":"165c94f7.186b9b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"false","x":710,"y":120,"wires":[]},{"id":"43c4db0c.5d8fc4","type":"function","z":"165c94f7.186b9b","name":"get the useful stuff","func":"for(var i=0;i<msg.payload.length;i++ ){\n    var high=msg.payload[i].high;\n    var low=msg.payload[i].low;\n    msg.payload={};\n    msg.payload.high=high\n    msg.payload.low=low\n    node.send(msg);\n}\n\n\n\n\n","outputs":1,"noerr":0,"x":450,"y":20,"wires":[["26b551b1.47b93e"]]},{"id":"d70f55b5.920ad8","type":"inject","z":"165c94f7.186b9b","name":"","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":70,"y":120,"wires":[["13932bb4.7a4fc4"]]},{"id":"a6ae173d.22fb38","type":"inject","z":"165c94f7.186b9b","name":"","topic":"","payload":"","payloadType":"date","repeat":"10","crontab":"","once":false,"onceDelay":0.1,"x":90,"y":540,"wires":[["b9b00705.784688","8df2f30d.da3da","74bbe06c.9448","dc38bd0.1699c4"]]},{"id":"b9b00705.784688","type":"http request","z":"165c94f7.186b9b","name":"Google","method":"GET","ret":"txt","url":"https://api.iextrading.com/1.0/stock/goog/price","tls":"","x":260,"y":480,"wires":[["33825ff.7a210a"]]},{"id":"8df2f30d.da3da","type":"http request","z":"165c94f7.186b9b","name":"Microsoft","method":"GET","ret":"txt","url":"https://api.iextrading.com/1.0/stock/msft/price","tls":"","x":260,"y":540,"wires":[["4d70189f.a160b8"]]},{"id":"74bbe06c.9448","type":"http request","z":"165c94f7.186b9b","name":"Facebook","method":"GET","ret":"txt","url":"https://api.iextrading.com/1.0/stock/fb/price","tls":"","x":260,"y":600,"wires":[["fa0276a5.d93558"]]},{"id":"dc38bd0.1699c4","type":"http request","z":"165c94f7.186b9b","name":"Apple","method":"GET","ret":"txt","url":"https://api.iextrading.com/1.0/stock/aapl/price","tls":"","x":250,"y":660,"wires":[["b12fe624.78b6b8"]]},{"id":"efab66cb.5b9318","type":"debug","z":"165c94f7.186b9b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":650,"y":560,"wires":[]},{"id":"63b9c89c.c8b758","type":"function","z":"165c94f7.186b9b","name":"","func":"\nreturn msg;","outputs":1,"noerr":0,"x":430,"y":80,"wires":[[]]},{"id":"595574fc.3bf2cc","type":"function","z":"165c94f7.186b9b","name":"","func":"\nreturn msg;","outputs":1,"noerr":0,"x":430,"y":140,"wires":[[]]},{"id":"1a5c3c2b.9c0104","type":"function","z":"165c94f7.186b9b","name":"","func":"\nreturn msg;","outputs":1,"noerr":0,"x":430,"y":200,"wires":[[]]},{"id":"3cd4a5e8.3ac65a","type":"csv","z":"165c94f7.186b9b","name":"","sep":",","hdrin":"","hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"0","x":510,"y":780,"wires":[["44574a5a.86a0f4"]]},{"id":"9ee7e64b.fb6448","type":"csv","z":"165c94f7.186b9b","name":"","sep":",","hdrin":"","hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"0","x":510,"y":820,"wires":[["992136d3.0f0f18"]]},{"id":"4fedf238.4c3bac","type":"csv","z":"165c94f7.186b9b","name":"","sep":"-","hdrin":"","hdrout":"","multi":"one","ret":"\\n","temp":"number,timestamp","skip":"0","x":510,"y":740,"wires":[["fe7db896.b586c8"]]},{"id":"fe7db896.b586c8","type":"file","z":"165c94f7.186b9b","name":"","filename":"/home/alex/Desktop/Google.txt","appendNewline":true,"createDir":true,"overwriteFile":"false","x":710,"y":740,"wires":[]},{"id":"33825ff.7a210a","type":"function","z":"165c94f7.186b9b","name":"","func":"msg.payload.number=msg.payload;\nmsg.payload = msg.payload + \" - \" + new Date().toString();\nreturn msg;","outputs":1,"noerr":0,"x":430,"y":380,"wires":[["efab66cb.5b9318","5eee6b30.2839d4"]]},{"id":"5eee6b30.2839d4","type":"split","z":"165c94f7.186b9b","name":"","splt":"-","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":370,"y":740,"wires":[["4fedf238.4c3bac"]]},{"id":"6569e890.265318","type":"split","z":"165c94f7.186b9b","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":370,"y":780,"wires":[["3cd4a5e8.3ac65a"]]},{"id":"4d70189f.a160b8","type":"function","z":"165c94f7.186b9b","name":"","func":"msg.payload.number=msg.payload;\nmsg.payload = msg.payload + \" - \" + new Date().toString();\nreturn msg;","outputs":1,"noerr":0,"x":430,"y":420,"wires":[["efab66cb.5b9318","6569e890.265318"]]},{"id":"fa0276a5.d93558","type":"function","z":"165c94f7.186b9b","name":"","func":"msg.payload.number=msg.payload;\nmsg.payload = msg.payload + \" - \" + new Date().toString();\nreturn msg;","outputs":1,"noerr":0,"x":430,"y":480,"wires":[["efab66cb.5b9318","6d31980b.a93338"]]},{"id":"b12fe624.78b6b8","type":"function","z":"165c94f7.186b9b","name":"","func":"msg.payload.number=msg.payload;\nmsg.payload = msg.payload + \" - \" + new Date().toString();\nreturn msg;","outputs":1,"noerr":0,"x":450,"y":540,"wires":[["efab66cb.5b9318","cba6a4c9.8efae8"]]},{"id":"6d31980b.a93338","type":"split","z":"165c94f7.186b9b","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":370,"y":820,"wires":[["9ee7e64b.fb6448"]]},{"id":"cba6a4c9.8efae8","type":"split","z":"165c94f7.186b9b","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":370,"y":860,"wires":[["dfec96ff.8c8d58"]]},{"id":"dfec96ff.8c8d58","type":"csv","z":"165c94f7.186b9b","name":"","sep":",","hdrin":"","hdrout":"","multi":"one","ret":"\\n","temp":"","skip":"0","x":510,"y":860,"wires":[["e226f364.5123d"]]},{"id":"44574a5a.86a0f4","type":"file","z":"165c94f7.186b9b","name":"","filename":"/home/alex/Desktop/Microsoft.txt","appendNewline":true,"createDir":true,"overwriteFile":"false","x":710,"y":780,"wires":[]},{"id":"992136d3.0f0f18","type":"file","z":"165c94f7.186b9b","name":"","filename":"/home/alex/Desktop/Facebook.txt","appendNewline":true,"createDir":true,"overwriteFile":"false","x":720,"y":820,"wires":[]},{"id":"e226f364.5123d","type":"file","z":"165c94f7.186b9b","name":"","filename":"/home/alex/Desktop/Apple.txt","appendNewline":true,"createDir":true,"overwriteFile":"false","x":700,"y":860,"wires":[]}]
#2

Not addressing your specific question, but please take a look at this pinned topic for future reference: How to share code or flow json

I’ve edited your post to fix the flow JSON