Skip to main content

I'm doing a feasibility on following integration modification on APP09.

 

We need to get currency rates from an extremal API and update the currency rates in IFS app09 IEE via a scheduled outbound. 

 

This is the POSTMAN tool example for the end pint request 

 

We need to pass the API Key and Base Currency as query parameters. I found that this cannot be done using Plsqlap_Server_API.Invoke_Outbound_Request_BizAPI in App09. In App10, we have Plsql_Rest_Sender_API which allows us to pass query parameters.

Could you please let me know if there are any other ways to achieve this in App09, or if it is possible using Plsqlap_Server_API?

Hi ​@harshana.kit 

 

I have tried it in many ways to achieve this in Apps9 but it’s not possible unfortunately, not only just because the query parameters, but the HTTP sender only capable of doing POST requests. You cannot achieve a GET request with HTTP sender.

There are two possible options as I see

  1.  Make the call from PLSQL using UTL_HTTP and handle the response and update the rates with a plsql package. You have some work to do by adding the endpoint to ACL and enabling the db firewall if it’s not open, but this way is proven to work.
  2. Since you are in Apps9, you have the advantage of making an own connect reader with a defined polling interval. It’s possible to make a custom connect reader which polls the currency endpoint, fetch the file and create an application message. It will eliminate the scheduling of the task since it will handle by IFS Connect polling. processing the rates can be developed as an inbound integration. If you need an example of a custom connect reader, check my repo on reading a RabbitMQ queue here. → https://github.com/knakit/RabbitMQ_Reader

Hope it gives some insights on how to continue. Good luck with your developments :)

 

Cheers!

Damith

Terms & ConditionsCookie settings