Skip to Content
Author's profile photo Former Member

CSV File Lookup With Http Request and Response in XI


This web blog describes a simple scenario which illustrates synchronous
message flow between http sender and http receiver by performing ‘CSV File’
Lookup in the mapping.

The http sender sends  an item name and quantity
as request; a lookup is performed to fetch the price of the item. These are
sent to J2ee application using http receiver. The j2ee application calculates
total sum (price*quantity) and sends it as response.

Since the Message Flow is synchronous,response is maapped and shown at http client.

h3. Request Mapping



h3. CSV File Lookup:

I have referred Sundar’s blog for
Making CSV File Lookup Possible In SAP XI !!! .

public String findprice(String itemno, Container container){




     Connection con=DriverManager.getConnection(“jdbc:driver:””/””/”+”pciib04530/users”);

     Statement stmt=con.createStatement();

     Resultset rs=stmt.executeQuery(“select itemno,price from price where itemno=”itemno”’”);

     String price=0;






     return price;


  Catch (Exception exp){return “-1”;}



This function fetches price of the specified item from
corresponding CSV File.

h3. Response mapping:


h3. Receiver Communication channel:



Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.