dataweave map function unable to get values in array

Question

I am unable to transform the below input payload in json to expected output. Below is the input I got, and the mapping which I tried, I have to ignore when the value of bea_order is blank which can we done with the filter, however my requirement is to pickup all the values from inside the array and club them together with values from other arrays.

Input:

[
   {
      "bea_order":[
         
      ]
   },
   {
      "bea_order":[
         {
            "PO_Receipt_Date__c":"2021-08-13",
            "Id":"a3I1T000003E6SQUA0"
         },
         {
            "PO_Receipt_Date__c":null,
            "Id":"a3Iq0000000OhnREAS"
         },
         {
            "PO_Receipt_Date__c":null,
            "Id":"a3Iq0000000OhnWEAS"
         }
      ]
   },
   {
      "bea_order":[
         {
            "PO_Receipt_Date__c":"2022-05-06",
            "Id":"a3I1T000003E6SOUA0"
         }
      ]
   },
   {
      "bea_order":[
         
      ]
   }
]

Output:

[
   {
      "id":"a3I1T000003E6SQUA0",
      "flag":"false"
   },
   {
      "id":"a3Iq0000000OhnREAS",
      "flag":"false"
   },
   {
      "id":"a3Iq0000000OhnWEAS",
      "flag":"false"
   },
   {
      "id":"a3I1T000003E6SOUA0",
      "flag":"false"
   }
]

Mapping I tried:

 %dw 2.0
output application/json
---
payload.bea_order filter ($.Id != null) map () -> {
    id : $.Id,
    flag : 'false'
}

How to get the expected output?

Salim Khan · Accepted Answer · 2023-01-13 08:01:15Z

1

You could try with this approach:

%dw 2.0
output application/json
---
flatten(payload..bea_order - []) map {
    id: $.Id,
    flag: false
}

answered Jan 13, 2023 at 8:01

Salim Khan

4,31313 silver badges15 bronze badges

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

Comments

aled · Accepted Answer · 2023-01-13 01:54:21Z

0

Try with flatMap() instead of map().

answered Jan 13, 2023 at 1:54

aled

26.5k4 gold badges36 silver badges52 bronze badges

Comments

blurfus · Accepted Answer · 2023-01-13 02:11:51Z

0

I think this will do the trick:

%dw 2.0
output application/json
---
payload filter ((item, index) -> sizeOf(item.bea_order) > 0) 
        flatMap ((item, index) -> (item.bea_order)) 
        map ((order, index) -> {
    "flag": false,
    "id" : order.Id
})

This is the output I get

[
  {
    "flag": false,
    "id": "a3I1T000003E6SQUA0"
  },
  {
    "flag": false,
    "id": "a3Iq0000000OhnREAS"
  },
  {
    "flag": false,
    "id": "a3Iq0000000OhnWEAS"
  },
  {
    "flag": false,
    "id": "a3I1T000003E6SOUA0"
  }
]

Basically, first I filter out the elements with empty bea_order, then flatMap the results and map them to their new element shape (with the 'flag' attribute)

answered Jan 13, 2023 at 2:11

blurfus

14.1k9 gold badges63 silver badges69 bronze badges

Comments

T.Gounelle · Accepted Answer · 2023-01-17 10:36:57Z

0

Step by step :

%dw 2.0
output application/json
---
payload map $.bea_order                 // get bea-order content  
        flatMap $                       // flatten arrays and remove empty ones 
        map {                           // transform to wanted result
          ($ - "PO_Receipt_Date__c"),
          "flag": false
        }

answered Jan 17, 2023 at 10:36

T.Gounelle

6,0631 gold badge24 silver badges33 bronze badges

Comments

jarus · Accepted Answer · 2023-01-19 04:45:15Z

0

Apart from merging the sub arrays, flatten also does the trick of omitting the empty sub arrays. Hope this helps.

%dw 2.0
output application/json
---
flatten(payload.bea_order) map {
    "id": $.Id,
    "flag":"false"
}

answered Jan 19, 2023 at 4:45

jarus

3061 silver badge5 bronze badges

Collectives™ on Stack Overflow

dataweave map function unable to get values in array

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related