#MuleSoft DataWeave5 discutindo

My input is :

[ {

"Booking Loca" : [ "Seedict Sparango","Cando Wall Communities","Maul O'donor","Ahohn kappler" ]

} ]

in this input there is a chance to get Name coming like Maul O'donor but I need to replace one single quote to Maul O''donor

The final Output Required Like below :

[Booking Loca] in ('Seedict Sparango','Cando Wall Communities','Maul O''donor','Ahohn kappler')

for this I am using below Data weave logic but at beginning and ending not getting single quote instead

%dw 2.0

output application/java

import * from dw::core::Strings

---

"[Booking Loca] in ("++((flatten(payload."Booking Loca")) map (wrapWith($,"'")) joinBy ",") replace "'" with '"' replace '","' with "','"++ ")"



%dw 2.0
 
import * from dw::core::Strings
 
var regExDateTime = /\d{4}-[01]\d-[0-3]\dT[0-2]\d:[0-5]\d:[0-5]\d\.\d+([+-][0-2]\d:[0-5]\d|Z)/
var regExDate = /^\d{4}\-(0[1-9]|1[012])\-(0[1-9]|[12][0-9]|3[01])$/
var regExBoolean = /^(true|false)$/
var id= payload.ChangeEventHeader.recordIds[0]
 
output text/plain
---
id

My DW is somewhat big having some calculation for sake of simplicity I just pasted 4 lines of code only.

In that 4 line itself I am getting below error

Scripting language error on expression '%dw 2.0
 
import * from dw::core::Strings
 
var regExDateTime = /\d{4}-[01]\d-[...'. Reason: Unable to resolve reference of payload..

I even tried by defining meta data for payload as like below

var id= payload.ChangeEventHeader.recordIds[0] as String 

var id= payload.ChangeEventHeader.recordIds[0] as String  default 'axd123'

But nothing helps

I have requirement to call PATCH method of a resource where user can update of the details mentioned in the request . Account ID which is the key is passed as URI. User can update any or all of these parameters. Since request parameters are not fixed i need to dynamically build UPDATE query.

{

   "name": "Mule",

"phone": "888888888",

"balance": "2000",

"billingCity": "London"

}

Below is the dataweave that is written to build set query. I have tried all combinations to execute update query.

%dw 2.0

import * from dw::core::Strings

output application/json 

---

((({

name: payload.name default "",

phone: payload.phone default "",

balance: payload.balance default "",

billingcity: payload.billingCity default ""

}pluck (($$)++'='++"\""++($)++"\"") ) 

reduce(item, acc="")-> acc ++ (if(!isEmpty(substringAfter(item,"="))) item++"," else "")) substringBeforeLast(",")) as String 

DB query

UPDATE account

SET :query

WHERE idaccount = :accID

Input parameters

output application/java

---

{

query: vars.query,

accID: attributes.uriParams.accID as String

}

vars.query is expected as name="Max",phone="9999999999",balance="20000",billingcity="Bangalore" to work properly. However it is not working . Tried replacing escape character with "" but then it doesnt work.

"name=\"Max\",phone=\"9999999999\",balance=\"20000\",billingcity=\"Bangalore\""

Kindly let me know if any better ideas to make this work

I am getting below error as I have a HTTP requester node where we have a PUT call so there is no response body.

So while creating inbound response we get below error on Transform node.

Unable to parse empty input, while reading `payload` as Json

If I do a setPaylod like below with empty body then it works.

<set-payload value="#{}" doc:name="Set Payload" doc:id="4d3edefb-a8c4-43af-bfa4-4625f536509f" />

However I am looking for a solution to handle this in the transform node itself.Please let me know how to handle this in transform node in the best possible way ?

unble to convert xml to json array in dataweave 2.0

output :

"employees":{

"employee":{

"name" : "abc"

},

"employee":{

"name" : "xyz"

}

}

expected output :

"employees":{

"employee" : [

{ "name" : "abc" },

{ "name" : "xyz" }

]

dataweave script :

%dw 2.0

output application/json

---

payload

How to Skip attribute or key ( eg SSN, password - sensitive )while transforming the object using mapObject

Payload:

[
  {
    "personal_information": {
      "first_name": "Emiliano",
      "middle_name": "Romoaldo",
      "last_name": "Lesende",
      "ssn": "001-08-84382"
    },
    "login_information": {
      "username": "3miliano",
      "password": "mypassword1234"
    }
  },
  {
    "personal_information": {
      "first_name": "Mariano",
      "middle_name": "Toribio",
      "last_name": "de Achaval",
      "ssn": "002-05-34738"
    },
    "login_information": {
      "username": "machaval",
      "password": "mypassword4321"
    }
  }
]

Here I have to remove ssn, password key from.

write now I have personal_information, login_information but i hv more attribute on same level

looking for dynamic way : except personal_information, login_information other attributes doesnt have sensitive information.

I have written below dataweave expression but its giving error. Can someone explain what is the error and solution

 MY code:

%dw 2.0
output application/json
// I have to remove sesitive fields like ssn, password from payload
 
---
payload map (value, key)->{
  (value mapObject(obj, objKey, index)->
   objKey match {
 
      case str if( objKey as String == "personal_information" ) -> ( obj- "ssn")
      case str if( objKey as String == "personal_information" ) -> ( obj- "password")
      else -> obj
    }
 
}

I want to create HashMap where key will be one filed and value will be whole object. Sample input is

{"Location": [{

"startDate": "1900-01-01T00:00:00",

"Code": "9001",

"abc": "text1"

},

{

"startDate": "1900-01-01T00:00:00",

"Code": "9002",

"abc" : "text2"

}]

}

Desired output with key as "Code" filed and value as whole location object. Is there any way to achieve this using dataweave. I have tried following but it produces array instead of HashMap.

%dw 1.0

%output application/java

---

location: payload.location map {

($.Code) : $

}