How to select one bundle under an array

[MotoHead47]

I receive data from a HTML Call and break it down into collections via an Array Module. My problem is I can t figure out how to use a filter to only select the collection that contains the ID I’m looking for.
Here is an example of the collection.

My goal is so select the collection with the ID of my choosing.

I tried using a filter for each area of the array module but it doesnt work. Iv tried equals to and contains with no luck.

Any ideas here?

[abhilash_naik]

Hi MotoHead47, welcome to the community.

In order to get the full collection that you want to extract from a specific index from an array you can use iterator and filter

here is an example

let’s say i have this array called data that contains details of people and i want to extract the collection having id as 56

I use an iterator to convert everything into individual bundles and pass it to the next module based on the filter

here is a json bundle if you want to try it on your own

{
  "data": [
    {
      "id": 43,
      "name": "John Doe",
      "phonenumber": "+1234567890",
      "address": "123 Maple St",
      "city": "New York",
      "status": {
        "state": "progress",
        "enabled": true
      }
    },
    {
      "id": 29,
      "name": "Jane Smith",
      "phonenumber": "+1987654321",
      "address": "456 Elm St",
      "city": "Chicago",
      "status": {
        "state": "completed",
        "enabled": false
      }
    },
    {
      "id": 56,
      "name": "Robert Brown",
      "phonenumber": "+1123456789",
      "address": "789 Oak St",
      "city": "Chicago",
      "status": {
        "state": "pending",
        "enabled": true
      }
    },
    {
      "id": 19,
      "name": "Emily Davis",
      "phonenumber": "+1321654987",
      "address": "101 Pine St",
      "city": "Houston",
      "status": {
        "state": "progress",
        "enabled": true
      }
    },
    {
      "id": 99,
      "name": "Michael Wilson",
      "phonenumber": "+1098765432",
      "address": "202 Cedar St",
      "city": "Phoenix",
      "status": {
        "state": "completed",
        "enabled": false
      }
    }
  ]
}

Iterator
input

output

Filter
input

output

Set variable
input

output

You can directly aggregate data using aggregator after the iterator module if you want an array of the filtered data from the previous array.
This can be helpful if you want to extract data as per certain condition like list of people from a particular city, you can use multiple condition in the filter to achieve more flexibility like if you want to extract collection of people whose city is chicago and statsus.state is completed.