Getting Data from the HTTP page using get method

[Former Member]

Hi Experts,

I want to retreive the data from the http page using GET method from SAP-PI 7.3 and save it in SAP ECC.

i.e. ABAP Outbound Proxy  <===> SAP _PI 7.3 <==>WEB SITE (Synchronous)

This is the url:

http://www.oanda.com/cgi-bin/fxml/fxml?fxmlrequest=<convert><client_id>oandatest</client_id><expr>USD_EUR</expr><exch>KWD_INR</exch></convert>

If I run this url , I get the required result.I tried testing the HTTP test tool (Fiddler tool) and the test is running fine,

I got the various details of the request as well as response.

Request:

Request Count:   1

Bytes Sent:      160                    (headers:160; body:0)

Bytes Received:  928                    (headers:181; body:747)

ACTUAL PERFORMANCE

--------------

ClientConnected:          14:36:45.772

ClientBeginRequest:          14:36:45.772

GotRequestHeaders:          14:36:45.772

ClientDoneRequest:          14:36:45.772

Determine Gateway:          0ms

DNS Lookup:                     0ms

TCP/IP Connect:          4ms

HTTPS Handshake:          0ms

ServerConnected:          14:36:45.776

FiddlerBeginRequest:          14:36:45.776

ServerGotRequest:          14:36:45.777

ServerBeginResponse:          14:36:47.028

GotResponseHeaders:          14:36:47.028

ServerDoneResponse:          14:36:47.227

ClientBeginResponse:          14:36:47.228

ClientDoneResponse:          14:36:47.228

Response:

HTTP/1.1 200 OK

Via: 1.1 ABC

Connection: close

Proxy-Connection: close

Date: Wed, 12 Sep 2012 11:38:40 GMT

Content-Type: text/xml

Server: nginx

Vary: Accept-Encoding

<RESPONSE>

<EXPR>USD</EXPR>

<EXCH>KWD</EXCH>

<AMOUNT>1</AMOUNT>

<NPRICES>1</NPRICES>

<CONVERSION>

<DATE>Fri, 01 Jun 2001 17:12:09 GMT</DATE>

<ASK>3.2499</ASK>

<BID>3.2446</BID>

</CONVERSION>

<EXPR>USD</EXPR>

<EXCH>INR</EXCH>

<AMOUNT>1</AMOUNT>

<NPRICES>1</NPRICES>

<CONVERSION>

<DATE>Fri, 01 Jun 2001 14:06:30 GMT</DATE>

<ASK>0.02130</ASK>

<BID>0.02128</BID>

</RESPONSE>

Kindly suggest the config part of recever adapter ?? I have not decided which adapter to use as I am not able to get the

desired result from HTTP nor HTTP_AAE?

Regards

Rebecca

[anupam_ghosh2 · Accepted solution]

Hi Alice,

                Please confirm from the business if the webservice is rest webservice or not.

In case this is REST webservice you need to use this adapter https://www.advantco.com/product/REST .   The adapter has licencisg cost. From the nature of request and response you have posted this seems to be a REST webservice.

Regards

Anupam

[baskar_gopalakrishnan2]

PI 7.3 supports HTTP GET operation. In addition, You might want to consider using  soap axis adapter for the GET operation. Please check the michael blog and rate it if you think it is helpful. http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/01/05/michals-pi-tips-exchange-rates-fr...

[Former Member]

Hi Bhaskar,

Did you try to run the url

http://www.oanda.com/cgi-bin/fxml/fxml?fxmlrequest=<convert><client_id>oandatest</client_id><expr>USD_EUR</expr><exch>KWD_INR</exch></convert>

I assume I should created a response structure based on the output of the above url.

Meanwhile I have questions circling for the answers.

1. When to use HTTP and HTTP_AAE adapter?

2. In the parameter of HTTP adapter like prolog,epilog , could you share some documentation of real time scenarios.

3.Does by default the HTTP adapter supports GET operation?

4.I can see the option in HTTP_AEE adapter , the possibility of GET not in HTTP adapter?

Regards

Rebecca

[anupam_ghosh2]

Hi Rebecca,

                did you confirm with the business if this is rest web service? 

To resolve this problem if its REST webservice  you can

1. deploy rest adapter as I mentioned above.

2. write your own adapter module or java mapping code.

3. check this blog http://scn.sap.com/community/pi-and-soa-middleware/blog/2012/08/11/calling-synchronous-restful-web-s...

regards

Anupam