How to extract value from a nested collection?

How To
1

As output of a call I have a (dynamic) number of collections returned. I want to set a variable with the amount of the rate or field with ID “262249198”. Is there a way to set this?

Important: per call, the amount of bundles/collections in the response can vary. So I cannot take a fixed position of the array but I need to look for the field ID I assume…

Hereby the output of the bundle after I iterated over the array of Fields returned. I need to have the “amount” in the values of field with ID “262249198”

[
    {
        "id": null,
        "name": "Availability",
        "visible": true,
        "values": [],
        "origin": "manual",
        "fixed": true,
        "kind": "date",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 1,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "visible": true,
        "values": [],
        "origin": "manual",
        "fixed": true,
        "kind": "nationality",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 2,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "name": "Salary",
        "visible": true,
        "values": [],
        "origin": "manual",
        "fixed": true,
        "kind": "salary",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 3,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "visible": true,
        "values": [],
        "options": {},
        "origin": "manual",
        "fixed": true,
        "kind": "language_skill",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 4,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "visible": true,
        "values": [],
        "origin": "manual",
        "fixed": true,
        "kind": "skills",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 5,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "name": "Type",
        "visible": true,
        "values": [],
        "options": {
            "values": [
                "Employee",
                "Freelancer"
            ]
        },
        "origin": "manual",
        "fixed": true,
        "kind": "dropdown",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 6,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "visible": true,
        "values": [],
        "origin": "manual",
        "fixed": true,
        "kind": "education",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 7,
        "__IMTLENGTH__": 10
    },
    {
        "id": null,
        "visible": true,
        "values": [],
        "origin": "manual",
        "fixed": true,
        "kind": "experience",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 8,
        "__IMTLENGTH__": 10
    },
    {
        "id": 262249198,
        "name": "Rate",
        "visible": true,
        "values": [
            {
                "amount": "500",
                "currency": "EUR"
            }
        ],
        "origin": "manual",
        "fixed": false,
        "kind": "salary",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 9,
        "__IMTLENGTH__": 10
    },
    {
        "id": 262292631,
        "name": "Salary",
        "visible": true,
        "values": [
            {
                "amount": "3000",
                "currency": "EUR"
            }
        ],
        "origin": "manual",
        "fixed": false,
        "kind": "salary",
        "is_anonymous": false,
        "visibility": {
            "level": "public",
            "admin_ids": [],
            "role_ids": []
        },
        "__IMTINDEX__": 10,
        "__IMTLENGTH__": 10
    }
]
2

Hi @Joni_Haeck,

just recorded a quick video for you on how to do this. Really hope this helps:

:party_blob:

1 Like
3

hi @Juliusforster,

Thank you so much for your help and time in making this video, very much appreciated :pray:

I got this up and running but I’ve noticed that the field ID is not a good reference… It seems to change on the producer side for different objects.

I think it is safer to check on the name of the field “Rate”, but I’m stuck in the naming. This doesn’t return anything:

image
image1056×886 68 KB

image
image1076×850 72.3 KB

here is an image of the output of the Aggregator btw:

image
image798×820 53.2 KB

thanks!