About carolpereira0378_2

carolpereira0378_2 · 04-28-2023

How to convert fixed length file into xml using a groovy script and group based on first field for the below sample file: 11111111111111111111111111111 +1X1X1X1X1X SSSSSS - ABC Primary11111111111111111111111111111 +1X1X1X1X1X SSSSSS - ABC Primary1111...

carolpereira0378_2 · 03-14-2024

Hi Ash,Hope the below blog helps you to answer your queryhttps://community.sap.com/t5/technology-blogs-by-members/streamlining-integration-zipping-multiple-files-in-sap-cpi/ba-p/13576941Thanks & Regards,Carol Pereira

carolpereira0378_2 · 03-11-2024

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.l...

carolpereira0378_2 · 03-07-2024

Hi Jwan,Create the hashmaps and store the source fields and then create a graphical mapping, using a custom function i.e., get method you can map the the required fields from hashmap to their respective target fields.You can refer the below blog: htt...

carolpereira0378_2 · 03-06-2024

Update: This is resolved using groovy script to convert the fixed length file into XML payload and then used XSLT mapping to group the records based on specific fields.

carolpereira0378_2 · 03-06-2024

Hello Akshay,Can you use below expression in CPI and try once count(/*:Workbook/*:Worksheet[@*:Name='Credit Cards']/*:Table/*:Row)I hope it works Regards,Carol Pereira

User Statistics

User Activity

Converting fixed length file to xml using groovy script in SAP CPI

Re: How can I enable compression in SFTP Adapter of SAP C...

Re: How to remove __Metadata from CPI json payload

Re: Multiple target fields mapping at once | Standard iFl...

Re: Converting fixed length file to xml using groovy scri...

Re: XPATH Expression to Count the Row nodes for XML ( Exc...