Unable to aggregate child values from json

Howdy Community!

I am connecting to SnipeIt and getting json back.

My goal is to output all the serial numbers from all the owned assets from a single person.

I thought the best approach would be to use the Item Lists tool and aggregate all serials into a single list. Unfortunately, I am unable to get the children values.

I continue to get the error along the lines of:
ERROR: Couldn’t find the field ‘serial’ in the input data

    "total": 3,
    "rows": [
        "id": 1,
        "name": "Name 1",
        "asset_tag": "1",
        "serial": "SERIAL1",
        "id": 2,
        "name": "Name 2",
        "asset_tag": "2",
        "serial": "SERIAL2",
        "id": 3,
        "name": "Name 3",
        "asset_tag": "3",
        "serial": "SERIAL3",

Any help would be appreciated.

Hello @n1isaac,

I am not entirely sure I understand the goal here, but as far as I can understand, you are on the right track with the Item List node; instead of using Aggregate Items, use the Split Out Items first and then with the Set node, you can grab only the serial and then use the Item List with Aggregate Items operation to put all the serials into a single item.

I am sharing a workflow with you that maybe can help.

1 Like