Change array to object and extract certain characters from it

Hi koryknick ,

My bad, please find below a simplified version of same:

Input:

{
   "project": {
      "projectId": 2
   },
   "items": [
      {
         "description": "Architecture Fees",
         "unitPrice": "1000",
         "projectActivity": {
            "chartCodes": [
               {
                  "chartCode": {
                     "uniqueCode": "7845",
                     "supplementalType": "BOMA"
                  }
               }
            ]
         }
      },
      {
         "description": "02 Site Utilities",
         "unitPrice": "2000",
         "projectActivity": {
            "chartCodes": []
         }
      }
   ]
}

Desired output:

{
   "order": {
      "orderLineItems": {
         "orderLineItem": [
            {
               "lineItemName": "Architecture Fees",
               "unitCost": "1000",
               "contractDetails": {
                  "activity": "20_7845_9999"
               },
               "additionalCoding": {
                  "workOrderNumber": "2"
               }
            },
            {
               "lineItemName": "02 Site Utilities",
               "unitCost": "2000",
               "contractDetails": {
                  "activity": "20_null_9999"
               },
               "additionalCoding": {
                  "workOrderNumber": "2"
               }
            }
         ]
      }
   }
}

Mapping I tried inside mapper:

mapping expression I used:

$items.map(val=>{"lineItemName":val.description,"unitCost":val.unitPrice,"contractDetails":{"activity":'20_'+jsonPath($,"items[*].projectActivity.chartCodes[*].chartCode").find(x=>x.supplementalType=='BOMA').uniqueCode+'_9999'},"additionalCoding":{"workOrderNumber":JSON.stringify($project.projectId)}})

It gives me output as follows:

{
   "order": {
      "orderLineItems": {
         "orderLineItem": [
            {
               "lineItemName": "Architecture Fees",
               "unitCost": "1000",
               "contractDetails": {
                  "activity": "20_7845_9999"
               },
               "additionalCoding": {
                  "workOrderNumber": "2"
               }
            },
            {
               "lineItemName": "02 Site Utilities",
               "unitCost": "2000",
               "contractDetails": {
                  "activity": "20_7845_9999"
               },
               "additionalCoding": {
                  "workOrderNumber": "2"
               }
            }
         ]
      }
   }
}

So here, I tried many a ways to manipulate the BOMA value which should come as distinct, the way it shows up in input, like for item 1 we have value available but for item 2 we should get null (or any other value, as coming from source), but the final working mapping I could figure out is mentioned above and it's basically mapping first BOMA code encountered in all the list object values.

Appreciate any help here!

Please let me know in case additional details needed here.

Thanks,

Deepti