#MuleSoft DataWeave6 discussing

*.xxxr.usa-e2.cloudhub.io

The call fails from SAP with the following error:

SOAP:1,023 SRT: Processing error in Internet Communication Framework: ("ICF Error when receiving the response: ICM_HTTP_SSL_ERROR")

We reviewed the certificate chain presented by the CloudHub 2 endpoint and imported the following certificates into SAP STRUST:

•  CloudHub server certificate: *.xxxr.usa-e2.cloudhub.io
•  Let's Encrypt YR1 
•  ISRG Root YR 
•  ISRG Root X1 

The certificate chain validates successfully outside SAP.

However, SAP ECC still reports ICM_HTTP_SSL_ERROR when calling the MuleSoft endpoint.

Has anyone experienced this issue with SAP ECC and the newer Let's Encrypt certificate chain used by CloudHub 2?

Specifically, I would like to confirm:

1.  Which SAP STRUST PSE should contain the CA certificates for an outbound HTTPS SOAP call: SSL Client Anonymous or SSL Client Standard? 
2.  Is the CloudHub leaf/server certificate required in STRUST, or should only the CA/intermediate certificates be trusted? 
3.  Are there known compatibility issues between older SAPCRYPTOLIB versions and the newer YR1 / ISRG Root YR Let's Encrypt chain? 
4.  Does SAP ICM need to be restarted/reloaded after updating the certificate list? 
5.  Is there any special TLS/SNI configuration required when SAP ECC calls a CloudHub 2 endpoint? 

MuleSoft itself is available and the endpoint can be reached successfully from other HTTPS clients.

Any guidance on what to check in SAP SMICM/STRUST or CloudHub 2 would be appreciated.

Thanks!

My Input will get as below String like:

[{

"ComplteDate in 180 days"

}] 

The scenario like I need to filter the data from source based on field called "ComplteDate" using this date field need to fetch data with WhereClause =[ComplteDate]<= dateadd(dd,180,Cast(getdate() as date) )

Example payload in Data source :[

  {

    "PerformNumber": "C-81022",

    "Status": "In Progress",

    "ComplteDate": "2028-05-01"

  },

  {

    "PerformNumber": "C-81023",

    "Status": "In Progress",

    "ComplteDate": "2029-09-01"

  },

  {

    "PerformNumber": "C-81024",

    "Status": "In Progress",

    "ComplteDate": "2028-05-01"

  },

  {

    "PerformNumber": "C-81024",

    "Status": "In Progress",

    "ComplteDate": "2029-09-01"

  },

  {

    "PerformNumber": "C-81025",

    "Status": "In Progress",

    "ComplteDate": "2028-05-01"

  },

  {

    "PerformNumber": "C-81026",

    "Status": "In Progress",

    "ComplteDate": "2029-09-01"

  },

  {

    "PerformNumber": "C-81026",

    "Status": "In Progress",

    "ComplteDate": "2025-05-01"

  },

  {

    "PerformNumber": "C-81027",

    "Status": "In Progress",

    "ComplteDate": "2025-09-01"

  },

  {

    "PerformNumber": "C-81028",

    "Status": "In Progress",

    "ComplteDate": "2025-05-01"

  },

  {

    "PerformNumber": "C-81029",

    "Status": "In Progress",

    "ComplteDate": "2025-09-01"

  }

]

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
    }
 
}

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

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 ?