How to remove __Metadata from CPI json payload

[Akash]

Hi,

Please suggest, how to remove __metadata from json payload using groovy script.

[Akash]

Please suggest

[NTeunckens]

Do you really need to use Groovy syntax for that?
An alternative could be the use of a Regular Expression ...

[Akash]

• If it is possible without groovy then no need to implement script.

[carolpereira0378_2]

Hi Akash,

Use below code to remove "__metadata" syntax: 

import com.sap.gateway.ip.core.customdev.util.Message;

import groovy.json.JsonSlurper;

import groovy.json.JsonBuilder;

def Message processData(Message message)

{

    def body = message.getBody(java.lang.String) as String;

    def jsonParser = new JsonSlurper();

    def data = jsonParser.parseText(body);  

    data.d.results.each{ results ->

    results.remove('__metadata')

    }

    def JsonOutput = new JsonBuilder(data).toPrettyString()

    message.setBody(JsonOutput );

    return message;

}

Regards,

Carol Pereira

[Akash]

thanks @carolpereira0378_2 . it is working.