Remove array from JSON when it appears

Question

I receive a JSON and sometimes, not always, I can receive an array in "resources" instead of a single value. I need to always transform this to a single value, keeping only the first one.

{
"result": {
"data": [
{
"postman": "12345",
"recordCase": "12",
"TypOfClient": "Small",
"active": "Yes",
"validFrom": "2020-09-03",
"activeGrades": [
{
"resources": "100",
"accounts": "1234551"
}
],
"validTo": "4712-12-31"
},
{
"postman": "12345",
"recordCase": "12",
"TypOfClient": "Small",
"active": "Yes",
"validFrom": "2020-09-03",
"activeGrades": [
{
"resources": ["100", "200", "500"],
"accounts": "1234551"
}
],
"validTo": "4712-12-31"
}
],
"lastPage": true
},
"status": "Finished"
}

desire result

{
"result": {
"data": [
{
"postman": "12345",
"recordCase": "12",
"TypOfClient": "Small",
"active": "Yes",
"validFrom": "2020-09-03",
"activeGrades": [
{
"resources": "100",
"accounts": "1234551"
}
],
"validTo": "2026-12-31"
},
{
"postman": "224499",
"recordCase": "13",
"TypOfClient": "Small",
"active": "Yes",
"validFrom": "2020-09-11",
"activeGrades": [
{
"resources": "100",
"accounts": "1234551"
}
],
"validTo": "2025-12-31"
}
],
"lastPage": true
},
"status": "Finished"
}

Is that possible? I tried a couple of things but it always erase the entire line or keeps all the values.

Answer 1

You can use a cardinality operation in this case.

"resources": "ONE" with cardinality means to pick the first element of array and create a single object out of it.

[
  {
    "operation": "cardinality",
    "spec": {
      "result": {
        "data": {
          "*": {
            "activeGrades": {
              "*": {
                "resources": "ONE"
              }
            }
          }
        }
      }
    }
  }
]

Hope this helps you!