URL Pattern in Receiver channel using REST Adapter with OAuth Authentication

[infra_team]

Background:

We are reconfiguring one of our channels from a JDBC adapter to a REST adapter that will get the data from the source system through a REST API. The requirement is to login to the source system using a username, password and clientID. Then the source system will provide a session ID that needs to be placed as an HTTP header for our data query. In this case, we created 2 IFlows.

1st IFlow: REST Polling to File

We use REST Polling in the sender channel with a Target URL that contains the username, pw and client ID

For the receiver channel we used File as the adapter and store the response in the local ECC file directory.

2nd IFlow: FILE to REST

For the second IFlow, we used a file sender channel to get the response from ECC and send it to the REST Receiver to use the session ID in the HTTP header

FILE sender

REST receiver

In the 2nd IFlow, we encountered below challenges

1. URL Pattern

For the URL for our data query, we are using below this url (url-pattern.txt), however we were getting error and not able to extract any data. For the error we are getting (error.txt) it seems like in the url % is getting encoded twice. How can we avoid this from happening? are there any alternative way on creating a URL?

2. REST Receiver payload

Once we were able to call the URL successfully and extract the data/payload, where will the payload be stored? And are there any additional configurations needed for keeping the payload?

Any input would be appreciated!

Thanks & best regards

Infra Team