How to expose a CSV file as a Service with SAP PI/PRO
Imagine you need to read a file content from a remote application and you do not want to set up a replication?
This scenario explains how to expose a CSV file (here a product list) as a WebService using the standard SOAP Adapter and the WHINT FileReader Adapter.
- Create Service Interfaces (Sender and Receiver side)
- For the receiver side you can also use the synchronous Inbound Service Interface FileReaderQueryResponse_In which is shipped with the Adapter
- Optional: Create a Mapping if you do not want to expose the result of the CSV-to-XML conversion of the MessageTransformBean
Module Configuration (MessageTransformBean: CSV->XML):
Update: I think it is obvious that the Files can be also queried with other sender channels, not only from SOAP (like e.g. REST here with a JSON response):