Splitting up API Oject Array

[ryanprel]

I'm looking for some help with fleshing out a flow. The background: Rapt is a company that produces digital hydrometers that float in a tank and check sugar levels that I use for monitoring fermentations in about 17 different tanks, some simultaneously. I have used webhooks in the past but they're pretty unreliable and since they have an API, I'd prefer using that. Using the below flow, I get the attached screenshot results. I'd like to segment these out and send each independent tank information to the proper dashboard components for that tank, all based on the name used in each object returned with the API request. Does anyone have an example of how to do something similar that I can work from?

[
    {
        "id": "910122750895da49",
        "type": "debug",
        "z": "15f71001.075b9",
        "name": "debug 32",
        "active": true,
        "tosidebar": true,
        "console": false,
        "tostatus": false,
        "complete": "false",
        "statusVal": "",
        "statusType": "auto",
        "x": 680,
        "y": 2160,
        "wires": []
    },
    {
        "id": "959053dd05d1dee1",
        "type": "rapt-pull",
        "z": "15f71001.075b9",
        "account": "",
        "name": "Pills",
        "endpoint": "GetHydrometers",
        "topic": "",
        "split": false,
        "x": 270,
        "y": 2160,
        "wires": [
            [
                "719872fe65dd71b6"
            ]
        ]
    },
    {
        "id": "b6ad4230c91f7ddf",
        "type": "inject",
        "z": "15f71001.075b9",
        "name": "",
        "props": [
            {
                "p": "payload"
            },
            {
                "p": "topic",
                "vt": "str"
            }
        ],
        "repeat": "",
        "crontab": "",
        "once": false,
        "onceDelay": 0.1,
        "topic": "",
        "payload": "",
        "payloadType": "date",
        "x": 140,
        "y": 2160,
        "wires": [
            [
                "959053dd05d1dee1"
            ]
        ]
    },
    {
        "id": "719872fe65dd71b6",
        "type": "split",
        "z": "15f71001.075b9",
        "name": "",
        "splt": "\\n",
        "spltType": "str",
        "arraySplt": 1,
        "arraySpltType": "len",
        "stream": false,
        "addname": "",
        "x": 390,
        "y": 2160,
        "wires": [
            [
                "910122750895da49"
            ]
        ]
    }
]

[jbudd]

The data you have shown us [a picture of] is not an array but an object.

The difference is that an array contains a sequence of values:

[17.71, 67.804706, 13.8208]

while an object also has keys to identify each value

{"temperature": 17.71, "gravity": 67.804706, "battery": 13.8208}

You can refer to these values by their key.

msg.payload.gravity

It looks like you want to direct the messages according to msg.payload.name like this

[ryanprel]

The name would be the unique-ID here (or the MAC address but name is easier to track and is unique). The data actually comes in as an array first but the split node segments it up into individual objects. It looks like a switch node might do the trick for me - thanks for the assist!

[E1cid]

You would split the array, then assign the name (or mac) to a msg.property (msg.topic) you can then split the object. You can then use two switch nodes to route by msg.topic(name) and msg.parts.key(object key) to the dashboard nodes you wish.
e.g.

[{"id":"b6ad4230c91f7ddf","type":"inject","z":"d1395164b4eec73e","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[{\"name\":\"pill-1\",\"temp\":20,\"gravity\":60},{\"name\":\"pill-2\",\"temp\":22,\"gravity\":62},{\"name\":\"pill-3\",\"temp\":23,\"gravity\":63}]","payloadType":"json","x":130,"y":2740,"wires":[["719872fe65dd71b6"]]},{"id":"719872fe65dd71b6","type":"split","z":"d1395164b4eec73e","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":250,"y":2740,"wires":[["4bdac1700cc016e4"]]},{"id":"4bdac1700cc016e4","type":"change","z":"d1395164b4eec73e","name":"","rules":[{"t":"set","p":"topic","pt":"msg","to":"payload.name","tot":"msg"}],"action":"","property":"","from":"","to":"","reg":false,"x":420,"y":2740,"wires":[["236174b293100639"]]},{"id":"236174b293100639","type":"split","z":"d1395164b4eec73e","name":"","splt":"\\n","spltType":"str","arraySplt":1,"arraySpltType":"len","stream":false,"addname":"","x":170,"y":2840,"wires":[["d478d12436bb33f6"]]},{"id":"d478d12436bb33f6","type":"switch","z":"d1395164b4eec73e","name":"","property":"topic","propertyType":"msg","rules":[{"t":"eq","v":"pill-1","vt":"str"},{"t":"eq","v":"pill-2","vt":"str"},{"t":"eq","v":"pill-3","vt":"str"}],"checkall":"true","repair":false,"outputs":3,"x":310,"y":2840,"wires":[["ae4caa4e8b30f31a"],["2341b6d24041e7f0"],["cc3caef94484ef38"]]},{"id":"ae4caa4e8b30f31a","type":"switch","z":"d1395164b4eec73e","name":"","property":"parts.key","propertyType":"msg","rules":[{"t":"eq","v":"name","vt":"str"},{"t":"eq","v":"temp","vt":"str"},{"t":"eq","v":"gravity","vt":"str"}],"checkall":"true","repair":false,"outputs":3,"x":510,"y":2800,"wires":[["910122750895da49"],["91b961eb9b086c1c"],["e34d09a70b2ef782"]]},{"id":"2341b6d24041e7f0","type":"switch","z":"d1395164b4eec73e","name":"","property":"parts.key","propertyType":"msg","rules":[{"t":"eq","v":"name","vt":"str"},{"t":"eq","v":"temp","vt":"str"},{"t":"eq","v":"gravity","vt":"str"}],"checkall":"true","repair":false,"outputs":3,"x":510,"y":2920,"wires":[["7413f0a978a44f1f"],["5e39f253656b56cf"],["aae1b702a7d1d477"]]},{"id":"cc3caef94484ef38","type":"switch","z":"d1395164b4eec73e","name":"","property":"parts.key","propertyType":"msg","rules":[{"t":"eq","v":"name","vt":"str"},{"t":"eq","v":"temp","vt":"str"},{"t":"eq","v":"gravity","vt":"str"}],"checkall":"true","repair":false,"outputs":3,"x":510,"y":3040,"wires":[["c4d5dbbf069882cf"],["c77f0f4ddb9e288f"],["81ef4a5cf1cd1492"]]},{"id":"910122750895da49","type":"debug","z":"d1395164b4eec73e","name":"name","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":2780,"wires":[]},{"id":"91b961eb9b086c1c","type":"debug","z":"d1395164b4eec73e","name":"temp","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":2820,"wires":[]},{"id":"e34d09a70b2ef782","type":"debug","z":"d1395164b4eec73e","name":"gravity","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":2860,"wires":[]},{"id":"7413f0a978a44f1f","type":"debug","z":"d1395164b4eec73e","name":"name","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":2900,"wires":[]},{"id":"5e39f253656b56cf","type":"debug","z":"d1395164b4eec73e","name":"temp","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":2940,"wires":[]},{"id":"aae1b702a7d1d477","type":"debug","z":"d1395164b4eec73e","name":"gravity","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":2980,"wires":[]},{"id":"c4d5dbbf069882cf","type":"debug","z":"d1395164b4eec73e","name":"name","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":3020,"wires":[]},{"id":"c77f0f4ddb9e288f","type":"debug","z":"d1395164b4eec73e","name":"temp","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":3060,"wires":[]},{"id":"81ef4a5cf1cd1492","type":"debug","z":"d1395164b4eec73e","name":"gravity","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":690,"y":3100,"wires":[]}]

p.s. Please share data in text format not as a picture. It makes it easier for others to help you. preferably in an inject node as people can then just hit the inject and run your data.

There’s a great page in the docs (Working with messages : Node-RED) that will explain how to use the debug panel to find the right path/value for any data item.

Pay particular attention to the part about the buttons that appear under your mouse pointer when you over hover a debug message property in the sidebar.