Remove obj from array if condition

[vosy]

Hi i have this data and i want to remove attribute where “is_allowed” : false

{
  "_lang": "eu",
  "attribute": [
    {
      "#": "1PCSETUP",
      "@id": "balici_jednotka",
      "allowed_ids": [
        "balici_jednotka_oversized_2",
        "balici_jednotka_oversized_3"
      ],
      "is_allowed": false
    },
    {
      "#": "PCS",
      "@id": "balici_jednotka_2",
      "allowed_ids": [
        "balici_jednotka_oversized_2",
        "balici_jednotka_oversized_3"
      ],
      "is_allowed": false
    },
    {
      "#": "PCS",
      "@id": "balici_jednotka_3",
      "allowed_ids": [
        "balici_jednotka_oversized_2",
        "balici_jednotka_oversized_3"
      ],
      "is_allowed": false
    },
    {
      "#": "1",
      "@id": "balici_jednotka_oversized",
      "allowed_ids": [
        "balici_jednotka_oversized_2",
        "balici_jednotka_oversized_3"
      ],
      "is_allowed": false
    },
    {
      "#": "1",
      "@id": "balici_jednotka_oversized_2",
      "allowed_ids": [
        "balici_jednotka_oversized_2",
        "balici_jednotka_oversized_3"
      ],
      "is_allowed": true
    },
    {
      "#": "2",
      "@id": "balici_jednotka_oversized_3",
      "allowed_ids": [
        "balici_jednotka_oversized_2",
        "balici_jednotka_oversized_3"
      ],
      "is_allowed": true
    }
  ]
}

or create array allowed_values with value of “#” where is_allowed=true

[m.arief]

Hi @vosy ,

Maybe you can try Value setter with Jmespath below?

[vosy]

damn backticks around true, thank you very much!. i tried without or with single 2 hours away , thank you very much! again.

[vosy]

thank you very much!, again, and how to elegantly convert the strings ‘2’,‘3’ in array to int? 2,3. thank you very much!

[vosy]

.to_number(“#”) nice

[m.arief]

Hi @vosy

is it working by .to_number(“#”)?

You can also try below mapper