Xml to Json conversion issue in REST

 I had a requirement to convert XML to JSON format using rest receiver channel.

I wanted to remove the root JSON tag in the receiver channel.


My DT was

DT_Company

 Record

   Field

     field1

     field2

   Field3

   Field4

   Field5   


Refer note - 

2743939 - XML Payload to JSON Conversion in REST receiver adapter


I used setIgnoreElements and provided value Records to remove JSON tag in Module configuration

 and checked Strip out element in the receiver channel 













This works fine for single record.

Note ->

But in case of multiple records, this doesn't work.

I also haven't explored on this part yet, but seems that this can be sorted out using XML JSON Conversion Rules.

Helpful link - 

https://blogs.sap.com/2016/01/13/rest-adapter-in-sap-pipo-enhanced-xmljson-conversion/



AMOR FATI - LOVE OF FATE


Comments

Post a Comment

Popular posts from this blog

HTTP Retry - Groovy + Looping Process Call

Image
This blog post will cover the HTTP Retry process using a Groovy script and Looping process call combination. Sometimes, we get a temporary time out error on the HTTP endpoint. To tackle this, we can use this mechanism to do a http retry for a specific interval / specific number of times.  Overall iFlow Design: Set Properties in Content modifier: For the Groovy script to work, we need to declare the below properties. Looping Process Call: HTTP Retry Groovy Script: If the HTTP Response code is greater than or equal to 400, the script will retry depending on the retry_interval and retry_limit properties. ------------------------------------------------------------------------------------------------------------- import com.sap.gateway.ip.core.customdev.util.Message; import java.util.HashMap; def Message processData(Message message) {         def map = message.getHeaders();         def  httpStatusCode = map.get("CamelHttpResponseCode") as In...
Read more

Content Modifier - Concatenate Array Inputs ( Dynamic Parent Node)

Image
   Requirement is to extract the repeated XML node with Dynamic Parent Nodes. Here, we are passing the below payload directly in Content Modifier - Message Body -------------------------------------------------------------------------------------------------------------------- <message>     <header>       <messageId>1</messageId>       <masterMsgId>33300453700</masterMsgId>       <equipment>         <serialNumber>API TestSNVin</serialNumber>         <make>CAT</make>         <model>D100</model>         <nickname>API Test Asset</nickname>       </equipment>       <moduleCode>API TestDeviceSN</moduleCode>       <moduleTime>2022-02-16 10:45:14</moduleTime>       <recei...
Read more

Headers and Exchange Properties

Message Header: This is transferred as part of Message Headers. If using an HTTP-based receiver adapter, these parameters are converted to HTTP headers and transferred as such to the receiver. Content Modifier helps to manipulate the Headers transmitted to the Receiver system. ----------------------------------------------------------------------------------------------------------------------------- Note:  If the message header exceeds a certain value, the receiver may not be able to accept the inbound call (this applies to all HTTP-based receiver adapters). The limiting value depends on the characteristics of the receiver system, but typically ranges between 4 and 16 KB. To overcome this issue, you can use a subsequent Content Modifier step to delete all headers that are not supposed to be part of the outbound message. ----------------------------------------------------------------------------------------------------------------------------- Exchange Property: Its like a Data Co...
Read more