How to map data into Array in Dataweave?

Question

I am trying to map some existing data into an array :-

      "categories": [
            {
                "value": [
                    "System"
                ],
                "displayName": "API type",
                "tagType": "category",
                "dataType": "enum",
                "key": "API type"
            },
            {
                "value": [
                    "Merchandising"
                ],
                "displayName": "Domain",
                "tagType": "category",
                "dataType": "enum",
                "key": "Domain"
            }
        ]

I want to be able to map the values array into a target field in my payload but filter out only those which are of key type 'Domain'.

So I am trying to get a payload as follows :-

{
  "organizationId": "13445",
  "organizationName": "MyOrg",
  "assetId": "myAPI",
  "businessDomains": [
       "Sales",
       "Marketing",
       "Distribution"
  ]
}

I've tried the Dataweave below but I get an array of arrays :-

%dw 1.0
%output application/json
---
{
    organizationId: flowVars.v_Org_Id,
    organizationName: flowVars.v_Org_Name,
    assetId: payload.assetId,
    businessDomains: (payload.categories filter ($.categories.key == 'Domain')).value
}

Can anyone suggest what the right Dataweave might be for this type of query

the sample input json seems incomplete, please post a full example so we can reproduce with your datweave. — utechtzs
– utechtzs, Commented Jan 22, 2019 at 17:53

Shoki · Accepted Answer · 2019-03-14 08:35:22Z

2

You could try using the flatten function.

businessDomains: flatten((payload.categories filter ($.key == 'Domain')).value)

edited Mar 14, 2019 at 8:35

Shoki

1,5488 silver badges14 bronze badges

answered Jan 22, 2019 at 16:56

Christian Chibana

5683 silver badges5 bronze badges

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

Collectives™ on Stack Overflow

How to map data into Array in Dataweave?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related