OPA REGO deconstructing nested array

Question

I got data something like this:

{
  "TENANT1":{ <-- Multiple tenants
    "SITE1":{ <-- Every tenant can have multiple sites
      "SITE1_DEVICE1":[ <-- Every site can have multiple devices
        "TEMP", <-- Just types
        "SET",
        "HUM"
      ],
      "SITE1_DEVICE2":[
        "TEMP"
      ]
    },
    "SITE2":{
      "SITE2_DEVICE1":[
        "TEMP",
        "HUM"
      ]
    }
  }
}

I want to list every device with types that given tenant is authorized for. This is what I tried:

test[devices] {
    devices = data["TENANT1"][_]
}

with result:

{
  "test":[
    {
      "SITE1_DEVICE1":["TEMP","SET","HUM" ],
      "SITE1_DEVICE2":["TEMP"]
    },
    {
      "SITE2_DEVICE1":["TEMP","HUM"]
    }
  ]
}

Is it somehow possible to have them all on the same level, not divided but it's sites, something like this:

{
  "test":[
      "SITE1_DEVICE1":["TEMP","SET","HUM" ],
      "SITE1_DEVICE2":["TEMP"],
      "SITE2_DEVICE1":["TEMP","HUM"]
  ]
}

Thanks in advance!

NPE · Accepted Answer · 2023-08-04 03:43:20Z

1

Please use the below rule:

Rule:

test[devices] := ret {
    some key, value in input.TENANT1[_]
    devices := key
    ret := value
}

Output:

{
    "test": {
        "SITE1_DEVICE1": [
            "TEMP",
            "SET",
            "HUM"
        ],
        "SITE1_DEVICE2": [
            "TEMP"
        ],
        "SITE2_DEVICE1": [
            "TEMP",
            "HUM"
        ]
    }
}

answered Aug 4, 2023 at 3:43

NPE

5126 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

OPA REGO deconstructing nested array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related