SAP BTP Integration Suite Learning

 Input to Content Modifier: -------------------------------------------------------------------------------------------------------- <Records>                 <Header>                                 <FieldA>H_ABC</FieldA>                                 <FieldB>H_123</FieldB>                                 <FieldC>H_XXX</FieldC>                                 <FieldD>H_567890</FieldD>                 </Header>                 <Line>             ...

 Demo Scenario : Content Modifier: Body  --------------------------------------------------------- <root xmlns="demo.sap.com"> <shop> <customerReview> <id>001</id> <rating>4</rating> </customerReview> <customerReview> <id>002</id> <rating>1</rating> </customerReview> <customerReview> <id>003</id> <rating>1</rating> </customerReview> <customerReview> <id>004</id> <rating>1</rating> </customerReview> <customerReview> <id>005</id> <rating>1</rating> </customerReview> </shop> </root> --------------------------------------------------------- Please also refer to the below blog for elaborative analysis : https://blogs.sap.com/2020/09/21/sap-cloud-platform-integration-general-splitter/

 The converter element enables you to transform an input message in one format to another.  Input: 123, Akshay, CPI Consultant 456, Akshada, Professor CSV to XML Converter : XML Schema: Choose Browse and select the file path to the XML schema file that is used as the basis for message transformation. The XML file schema format is used as the basis for creation of the payload.  Path to Target Element in XSD : XPath in the XML Schema File where the content from CSV has to be placed.  Record Marker in CSV : The corresponding record in the CSV file that has to be considered for conversion. This entry is the first text in every new record of the CSV.  If this value is not specified then all the records would be considered for conversion. Field Separator : If we want to use a field separator that is not available in the dropdown list, manually enter the character in Field Separator in CSV field. If you want to exclude headers in the first line of CSV file for convers...

 Used to calculate a digest of the payload or parts of it and store the result in a message header. We can transform part of the message, enter an XPath expression to specify the part (optional attribute). Can also define a prefix namespace mapping. Hash  Address :  https://refapp-espm-ui-cf.cfapps.eu10.hana.ondemand.com/espm-cloud-web/espm.svc/ Target Header Name: Enter the name of the target header element which is to contain the hash value (digest). This is a mandatory attribute When tested first (without changing anything in the payload), the below MD5 hash was generated : AVWgPTQU1b/X/YC/4ANlwA== -------------------------------- On the second test run, we added a new customer review in the OData WebShop API ( so we get a different response compare to earlier to view the disparity in MD5 Values) Can see below the customer review was added in the Response Payload:  As the response (input to MD5) has been changed, the resulted MD5 hash value should also b...

When to use Filter? ->  if want to filter information by extracting a specific node from the incoming message. What are different value types? ->  Sample XML Payload: (to put inside Body of Content Modifier) ---------------------------------------- <Message> <orders>  <order>  <clientId>I0001</clientId>  <count>100</count>  </order>  <order>  <clientId>I0002</clientId>  <count>10</count>  </order> </orders> </Message>  ------------------------------------------------- iFlow: Content Modifier: With value type as ' Integer ' With value type as Boolean : With Value type as 'Node' : (only first occurrence of node is considered) With Value type as 'Nodelist'  (All <count> nodes are considered )

  Address :  Specifies the host name and (optionally) a port number of the SMTP server.  Use one of the following open ports for external mail servers:  25 and 587 for SMTP+STARTTLS 465 for SMTPS If you are using GMail Server, make sure that you allow insecure applications (GMail considers only communication based on OAuth2 as secure) when configuring the server.  Can use port 25 for connections to GMail server. -------------------------------- If you want to configure multiple mail receivers, use a comma (,) to separate the addresses. The parameters From, To, Cc, Bcc, Subject, Mail Body as well as the attachment name, can be dynamically set at runtime from message headers or content.