How to create an array based on keys after the filter condition?

Question

I have a array as shown below which is an output of the filter condition. It has fields like documentItemName1,documentItemName2,documentItemName3 at the min it can have on and max of 3.

It's like for each contentVersion documentItemToSigner has no of number objects based on no of documentItemName{n} present in it

payload:

 [
      {
        "contentVersion": "068DQ000000lK0iYAE",
        "documentName": "ESRA with Exhibit_A",
        "documentItemName1": "Signature001",
        "typeCd1": "Signature",
        "typeCd2": null,
        "typeCd3": null,
        "subtypeCd1": "CAPTURE",
        "subtypeCd2": null,
        "subtypeCd3": null
      },
      {
        "contentVersion": "068DQ000000kK0OYAU",
        "documentName": "Agreement 1",
        "documentItemName1": "Signature001",
        "documentItemName2": "Signature002",
        "typeCd1": "Signature",
        "typeCd2": "Signature",
        "typeCd3": null,
        "subtypeCd1": "CAPTURE",
        "subtypeCd2": "LABEL",
        "subtypeCd3": null
      },
      {
        "contentVersion": "068DQ000000lK0OYAU",
        "documentName": "Agreement 2",
        "documentItemName1": "Signature001",
        "documentItemName2": "Signature002",
        "documentItemName3": "Signature003",
        "typeCd1": "Signature",
        "typeCd2": "Signature",
        "typeCd3": "Signature",
        "subtypeCd1": "CAPTURE",
        "subtypeCd2": "CAPTURE",
        "subtypeCd3": "CAPTURE"
      }
    ]

I have tried below script but not sure how to create objects based on no of documentItemName{no} in it.

For ex: From the payload I am filtering to this contentVersion = "068DQ000000lK0OYAU" which has documentItemName1,documentItemName2,documentItemName3. So, documentItemToSigner array should have 3 objects which maps like this

"documentItemToSigner": [{

documentItemName: documentItemName1,
"typeCd": typeCd1,
"subtypeCd": subtypeCd1
},
 {

documentItemName: documentItemName2,
"typeCd": typeCd2,
"subtypeCd": subtypeCd3
},
 {

documentItemName: documentItemName3,
"typeCd": typeCd3,
 "subtypeCd": subtypeCd3
}]

For ex2: From the payload, If I am filtering to this contentVersion = "068DQ000000lK0iYAE" which has only documentItemName1. So, documentItemToSigner array should have 1 object which maps like this

"documentItemToSigner": [{
        
        documentItemName: documentItemName1,
        "typeCd": typeCd1,
        "subtypeCd": subtypeCd1
        }]

"documentItemToSigner": (payload filter ((g, index) -> g.contentVersion == "068DQ000000lK0OYAU")) map ((item, index) -> {
    "typeCd": item."typeCd{n}",
    "subtypeCd": item."subtypeCd{n}",
    "eSignLiveExtension": {
      "extractInd": true
    },
    "documentItemName": item."documentItemName{n}"
  })

expected output:

{
  "documentItemToSigner": [
    {
      "typeCd": "Signature",
      "subtypeCd": "CAPTURE",
      "eSignLiveExtension": {
        "extractInd": true
      },
      "documentItemName": "Signature001"
    },
    {
      "typeCd": "Signature",
      "subtypeCd": "LABEL",
      "documentItemName": "Signature002",
      "eSignLiveExtension": {
        "extractInd": false
      }
    },
 {
      "typeCd": "Signature",
      "subtypeCd": "CAPTURE",
      "eSignLiveExtension": {
        "extractInd": true
      },
      "documentItemName": "Signature003"
    }
  ]
}

The question is unclear. Please try to describe in more detail what you are trying to do. The JSON object is hard to read, please edit the question to indent it. Your script uses dSigner but it is not defined. Be sure that you provide a minimal reproducible example and actual output. — aled
– aled, Commented Nov 25, 2024 at 14:51
There are two items with contentVersion equal to 068DQ000000kK0OYAU. Is that expected? — aled
– aled, Commented Nov 25, 2024 at 15:01
@aled, I have updated the question with proper payload and expected output — veejay
– veejay, Commented Nov 25, 2024 at 15:02

aled · Accepted Answer · 2024-11-25 17:05:47Z

I extracted the attributes from the payload that end in a number and format it in a way that is easy to map to the desired output.

This solution assumes a single digit for the suffix. Also extractInd is fixed to true, since there is no guidance on how to make it dynamic like in the example output.

%dw 2.0
output application/json
---
{
    "documentItemToSigner": 
        (payload filter ((g) -> g.contentVersion == "068DQ000000lK0OYAU")) 
    
        // convert to a list of attributes per numeric suffix of keys
        map ((item) -> 
            item groupBy (dw::core::Strings::last($$ as String, 1)) filterObject ((value, key) -> dw::core::Strings::isNumeric(key as String )) 
            pluck {index:$$, value: $}
        )

        // map the list per suffix attributes to a list of objects
        flatMap ((item, index) -> item map ((doc) ->  {
            "typeCd": doc.value[("typeCd" ++ doc.index)],
            "subtypeCd": doc.value[("subtypeCd" ++ doc.index)],
            "eSignLiveExtension": {
            "extractInd": true
            },
            "documentItemName":  doc.value[("documentItemName" ++ doc.index)]
        }))
}

Output

{
  "documentItemToSigner": [
    {
      "typeCd": "Signature",
      "subtypeCd": "CAPTURE",
      "eSignLiveExtension": {
        "extractInd": true
      },
      "documentItemName": "Signature001"
    },
    {
      "typeCd": "Signature",
      "subtypeCd": "CAPTURE",
      "eSignLiveExtension": {
        "extractInd": true
      },
      "documentItemName": "Signature002"
    },
    {
      "typeCd": "Signature",
      "subtypeCd": "CAPTURE",
      "eSignLiveExtension": {
        "extractInd": true
      },
      "documentItemName": "Signature003"
    }
  ]
}

cipherwizard · Accepted Answer · 2024-11-26 06:13:02Z

1

You can use the below solution. This will dynamically generate the array based on number of documentItemName coming in the payload for a particular content version.

%dw 2.0
output application/json
var contentVersionVar = "068DQ000000lK0iYAE"
var c=sizeOf(keysOf(payload[?($.contentVersion==contentVersionVar)][0])[?(contains($,"documentItemName"))])
var filteredPayload=payload[?($.contentVersion==contentVersionVar)][0]
---
(1 to c) map {
    typeCd: filteredPayload."$('typeCd' ++ $)",
    subtypeCd: filteredPayload."$('subtypeCd' ++ $)",
    "eSignLiveExtension": {
        "extractInd": true
      },
      "documentItemName": filteredPayload."$('documentItemName' ++ $)"
}

answered Nov 26, 2024 at 6:13

cipherwizard

212 bronze badges

Comments

Alex Martinez · Accepted Answer · 2024-11-25 15:29:40Z

0

what about this?

%dw 2.0
output application/json
var contentVersionVar = "068DQ000000lK0iYAE"
---
{
    documentItemToSigner: (payload map (item, index) -> {
        typeCd: item."typeCd$(index+1)",
        subtypeCd: item."subtypeCd$(index+1)",
        eSignLiveExtension: {
            extractInd: true // where does this come from?
        },
        documentItemName: item."documentItemName$(index+1)",
        TEMP: item.contentVersion
    }) filter ($.TEMP == contentVersionVar) map ($ - "TEMP")
}

answered Nov 25, 2024 at 15:29

Alex Martinez

111 bronze badge

2 Comments

veejay Nov 25, 2024 at 15:38

contentVersionVar has to be dynamic right? It's like for each contentVersion documentItemToSigner has no of number objects based on no of documentItemName{n} present in it.

Alex Martinez Nov 25, 2024 at 16:08

so then your output is wrong? if 068DQ000000lK0iYAE should have 1 and 068DQ000000lK0OYAU should have 3, you'd end up with 4 items in the output? making it an array of arrays. i'm not following where the filter comes from or why the extractInd is true/false

Collectives™ on Stack Overflow

How to create an array based on keys after the filter condition?

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related