Question Re: SAP Cloud Platform Integration – Groovy script to remove an empty array from an object array in Technology Q&A

SAP Cloud Platform Integration – Groovy script to remove an empty array from an object array

beverely_parks2 — Fri, 20 Mar 2020 19:52:08 GMT

I'm working on an implementation where the receiver is requesting a JSON file format. I'm using integration mapping to create an XML that matches the JSON format. I'm then executing standard XML to JSON conversion followed by a groovy script to remove the "element" entries from each object array. My final step is that if an object array contains an empty element, the result should be an empty object array that looks like: "TestQualitativeMeasurement":[].

If I create the element regardless of data, convert XML to JSON, and execute my script, my results look like "TestQualitativeMeasurement":[""] (Receiver is not accepting this as an empty object)

I've tried not mapping the element if there is no data but this results in the object array end up looking like "TestQualitativeMeasurement":"" and is missing the [] object qualifers required.

Would anyone be able to advise me on how to accomplish this? I believe that I should be able to do this within my groovy script but I haven't found the right combination.

Thank you

Re: SAP Cloud Platform Integration – Groovy script to remove an empty array from an object array

catano — Sat, 21 Mar 2020 03:03:27 GMT

Hi beverely.parks2, Can you please attach XML, Groovy and/or Mapping screenshot and/or code?
What is the result if you don't execute your remove script at all just the XML > JSON mapping? BP, Peter

Re: SAP Cloud Platform Integration – Groovy script to remove an empty array from an object array

r_herrmann — Mon, 23 Mar 2020 09:58:43 GMT

Hi Beverly,

since JSON is just a "String", you could simply run a search-replace script after your JSON conversion.

import com.sap.gateway.ip.core.customdev.util.Message
def Message processData(Message message) {
    def body = message.getBody(java.lang.String) as String
    body = body.replace("[\"\"]","[]")
    message.setBody(body)
    return message
}

Re: SAP Cloud Platform Integration – Groovy script to remove an empty array from an object array

beverely_parks2 — Mon, 23 Mar 2020 13:15:44 GMT

Thank you. That worked perfectly and as I try to learn Groovy scripting, I learned about escape characters.