How to extract information from a collection filtering by another collection

How To
, ,
1

Hi,

I’m trying to get the value from “MinRent” using map(), and I can do it using the following formula: {{map(map(map(map(toArray(3.data.response.result.ILS_Units.Unit); “value”); “Rent”); “@attributes”); “MinRent”)}}

The problem is, we need to able to filter by FloorPlanName, but I’m cant scratch my head around how to do it. I’ve looked around in the community and found that you can use objectparent.object inside map() to somewhat navigate through collections but every test I do doesnt work.

Can you guys help me with this? I can provide any information needed to find the solution.

The JSON bellow is a object of one the units, you will be able to find FloorPlanName and MinRent there.

        "5027875": {
          "@attributes": {
            "UnitNumber": "911",
            "FloorPlanName": "Studio Ayra",
            "Availability": "Disponível",
            "Status": "Vago pronto (disponível)",
            "AvailableOn": "09/15/2023",
            "FloorplanId": 1152561,
            "UnitTypeId": 653764,
            "PropertyUnitId": 5027875,
            "PropertyId": 1187263,
            "FloorId": 2676032,
            "FloorNumber": "9",
            "BuildingId": 88679,
            "BuildingName": "1",
            "OccupancyType": "Convencional",
            "IsAffordable": "0",
            "HasPricing": "1",
            "WebVisible": "1",
            "Area": "54.0000 SquareMeter"
          },
          "Rent": {
            "TermRent": [
              {
                "@attributes": {
                  "LeaseTermId": "202",
                  "LeaseTerm": "3 Meses",
                  "IsWebVisible": "1",
                  "LeaseTermName": "3 meses",
                  "Rent": "8,135.00",
                  "RateFrequency": "Por mês"
                }
              },
              {
                "@attributes": {
                  "LeaseTermId": "203",
                  "LeaseTerm": "6 Meses",
                  "IsWebVisible": "1",
                  "LeaseTermName": "6 meses",
                  "Rent": "7,028.00",
                  "RateFrequency": "Por mês"
                }
              },
              {
                "@attributes": {
                  "LeaseTermId": "237",
                  "LeaseTerm": "30 Meses",
                  "IsWebVisible": "0",
                  "LeaseTermName": "30 meses",
                  "Rent": "8,622.00",
                  "RateFrequency": "Por mês"
                }
              },
              {
                "@attributes": {
                  "LeaseTermId": "204",
                  "LeaseTerm": "12 Meses",
                  "IsWebVisible": "1",
                  "LeaseTermName": "12 meses",
                  "IsBestPrice": "verdadeiro",
                  "Rent": "6,508.00",
                  "RateFrequency": "Por mês"
                }
              }
            ],
            "@attributes": {
              "MinRent": "6,508.00",
              "MaxRent": "8,622.00"
            }
          },
          "Deposit": {
            "@attributes": {
              "MinDeposit": "0.00",
              "MaxDeposit": "0.00"
            }
          }
        },
2

This is because the key, 5027875 is dynamic as it is the propertyId, so you cannot easily reference the children properties.

What you’ve provided seems to be a partial output bundle. Could you provide the full output bundle?

2 Likes