Forum Discussion

Deepti's avatar
Deepti
New Contributor II
2 years ago
Solved

Retrieve a list within another array list

Hi there, I have one input json like as follows: { "isValid": true, "logId": "9IE9BkOwxvrCwn_Ot7p4o-1699858392", "contractId": 1, "erpVendorId": "VID123", "erpVendorName": null...
  • koryknick's avatar
    koryknick
    2 years ago

    HI Deepti - update the second Mapper expression to the following:

    $items
.map(x=> x.merge(
{ "additionalCoding" : { "workOrderNumber" : $project.projectId } 
,  "contractDetails" : { "workOrderNumber" : $project.projectId } }
)
)

    So rather than an Object.extend(), we'll use Object.merge() to do a deep merge of the object, allowing us to also add the workOrderNumber into the existing contractDetails sub-element.

    Hope this gets you closer to your goal!

Deepti's avatar
Deepti
New Contributor II
2 years ago
Copy LinkReport

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

alchemiz's avatar
alchemiz
Contributor III
2 years ago
Copy LinkReport

Hi Deepti ,

Good day. Hope this helps

 

 

{'order':{'orderLineItems': {'orderLineItem': $items.map( i=> { 'lineItemName': i.get('description'), 'unitCost': i.get('unitPrice'), 'contractDetails': { 'activity': ''.concat('20_', (i['projectActivity'].get('chartCodes',[]).find((x,y,z)=> x.get('chartCode',{}).get('supplementalType','') == 'BOMA') || {}).get('chartCode',{}).get('uniqueCode','null'), '_9999')}, 'additionalCoding': {'workOrderNumber': $project.get('projectId')} })}}}



Thanks,

EmEm