Which all formats are compatible as input by Process Integration SAP

The answer to your question is that a lot of formats are supported by process integration for processing. The basic concept is that you need to define a mapping which will parse the incoming file and then converts it to the output format. Since you are getting a file from service as an input, it will be better if it is in CSV or .xls.