topic Re: Communication between two web servers with XML data in Application Development and Automation Discussions

Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 10:53:43 GMT

Hi Experts,

We have a requirement .

There will be two Ticketing tools used for SAP support.

1. On SAP User side (Developed using BSP in WAS).

2. On support Team side (Third party web application).

The data between these two should be exchanged with the other server as and when it is updated .

For exaple if a Ticket information in BSP is updated by SAP user , the same should be updated into the third party application and vice versa.

I have heard that for data transfer , xml can be used . Could you please help me how can this be achieved ? I am interested in BSP side only and I am new to XML.

ie...

1. In outbound , BSP should act as a client and send data to Thirdparty web application.

2.BSP should act as a server when recieving the data sent from Thirdparty web application and update WAS database.

I would be greatful if anyone could help me . Answers would definitely be rewarded.

Thanks and Regards,

Laxman Nayak.

Re: Communication between two web servers with XML data

athavanraja — Sun, 15 Apr 2007 11:20:09 GMT

1. is BSP should send data or the third party will pull the data

2. will the third party push the data or BSP should pull the data?

for example if user enter some data in BSP and if you want this to be updated on the third party system, the thrid party system should either provide a webservice or a http service to accept data. once it is there sending data from BSP is simple.

like wise if the third party wants data from your BSP, it can call a BSP url which can pass data in xml format.

Raja

Re: Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 11:25:53 GMT

Hi Raja,

Thanks for the quick reply and for your time.

My requirement is

1. BSP should push the data to Third party application as and when the data is updated in WAS.

2. Third party application should push data to BSP as and when the data is updated in Third Party application.

Can you give some more details for the realization of the same . With some code if you have ..

Thanks and Regards,

Laxman Nayak.

Re: Communication between two web servers with XML data

athavanraja — Sun, 15 Apr 2007 11:35:22 GMT

<i>as and when the data is updated in WAS</i>

do you mean that data may be updated by some mechanism (not necessarily user entering data in bsp application and saving it in WAS) and that should trigger data push to thirdparty application?

does the other webserver provides webservices? without knowing much about the other webserver, it will be difficult.

for example some user entered info need to be captured, in such case the other webserver should either provide a webservice to receive this data or they should have a webpage for accepting this info. if its there then wecan push data to that system

Raja

Re: Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 11:45:23 GMT

Hi Raja ,

Thanks for your help.

1. User entering data in bsp application and saving it in WAS) and that should trigger data push to thirdparty application. There is no other means by which the data is updated .

2. provide a webservice to receive this data or they should have a webpage for accepting this info. Which among these two is most simple and which among these is best . I am new to this concept . Could you please explain me little more in detail?

Regards,

Laxman Nayak.

Re: Communication between two web servers with XML data

athavanraja — Sun, 15 Apr 2007 11:53:00 GMT

if they already have a webpage to accept these data then you can use that, else if they have webservices ready you can use that. (if you are on WAS6.40 i would suggest the webservice method)

please keep in mind here we have not talked about authentication. when BSP calls the other webserver, does it require uid/pwd

also when the other webserver calls BSP , that webserver has to pass on WAS authentication.

<i>I am new to this concept . Could you please explain me little more in detail?</i>

what details you want, if you can be specific, that will make it easier to answer.

(dont get confused with XML, you can use other formats as well. and the real question here is not about xml but about communicating between two systems)

Raja

Re: Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 11:59:07 GMT

Hi Raja ,

Two questions .

1. If I have to send application data thru XML to third party application considering it has a webservice or a page to accept the data , how can I do it ?

2. Also for Thrid party to send data to my WAS , what are the things that I should make available to third party application ?

Regards,

Laxman Nayak.

Re: Communication between two web servers with XML data

athavanraja — Sun, 15 Apr 2007 12:22:53 GMT

you can manually build the xml using concatenate statement or use cl_xml_document class to build the xml (search abap forum on cl_xml_document or if_ixml_document samples should be there)

you can either create a webservice out of a RFC or create a bsp page which takes some parameter and process that data and returned the results in xml format.

for example create a bsp page with following details. (while creating the page use extension .xml)

page attributes:

airline TYPE STRING (with auto check box checked)

xml_out TYPE STRING

oninitialization

data: flist type standard table of bapisfldat ,
      airline_id type bapisflkey-airlineid ,
      return type standard table of bapiret2 .
clear xml_out .
if not airline is initial .
  clear airline_id .
  move: airline to airline_id .
  call function 'BAPI_FLIGHT_GETLIST'
   exporting
     airline                = airline_id
*   DESTINATION_FROM       =
*   DESTINATION_TO         =
*   MAX_ROWS               =
   tables
*   DATE_RANGE             =
*   EXTENSION_IN           =
     flight_list            = flist
*   EXTENSION_OUT          =
   return                 =  return.
  case sy-subrc .
    when  0 .
      if flist[] is initial .
        call transformation (`ID`)
                    source output = return[]
                    result xml xml_out
                    options
                    data_refs = 'embedded' .
*                    options XML_HEADER = 'NO' .

      else.
        call transformation (`ID`)
                  source output = flist[]
                  result xml xml_out
                  options
                    data_refs = 'embedded' .

*                  options XML_HEADER = 'NO' .

      endif .
    when others .
      concatenate
      `<?xml version="1.0" ?>`
    `<asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">`
    `<error>`
    `Unknown Error`
    `</error>`
    `</asx:abap>` into xml_out .

  endcase .

else.
  concatenate
            `<?xml version="1.0" ?>`
          `<asx:abap xmlns:asx="http://www.sap.com/abapxml" version="1.0">`
          `<error>`
          `Enter Airline ID`
          `</error>`
          `</asx:abap>` into xml_out .


endif .

call method response->if_http_entity~set_cdata
  exporting
    data = xml_out.

and clear all codes from layout section.

now if you call this page with carrier id as url parameter it will return that carrier relevant data in xml format.

the url will be

http://<abaphost>.domain.com:port/sap/bc/bsp/sap/<your bsp application name/pagename.xml?airline=LH

the other webserver call call this url to get data from WAS system.

Regards

Raja

Re: Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 12:32:09 GMT

Hi Raja,

Thanks for the example . But the example looks to me more of pull approach.

Let me put my question like this .

If the user in my WAS has updated flight details of airline=LH and if this data has to be pushed to Third party application , then how should be the code ?

Thanks in advance ..

Regards,

Laxman Nayak.

Re: Communication between two web servers with XML data

athavanraja — Sun, 15 Apr 2007 12:36:58 GMT

in such a case, the third party system should have a page to update this or a webservice to update this, then we can push data to it.

Raja

Re: Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 12:52:33 GMT

Hi Raja,

Suppose the 3rd party webserver has a Page to update the data .

If I have to trigger a data push from WAS thru a BSP page , then steps would be

1. Fetch application data . (In our case carrier details).

2. Convert it to XML format using .

call transformation (`ID`)

source output = return[]

result xml xml_out

options

data_refs = 'embedded' .

3. Then send it to 3rd party application page which will post the data in 3rd party application.

Lets say the page in 3rd party application is "http://3rdparty/xml_data_recieve.htm"

Then how should we code in WAS to send xml data to page "http://3rdparty/xml_data_recieve.htm" ?

Please correct me if my understanding of the concept is wrong .

Laxman.

Re: Communication between two web servers with XML data

athavanraja — Sun, 15 Apr 2007 13:08:39 GMT

check this example on how data is sent between pages/application over http

http://www.w3schools.com/tags/tag_form.asp

for your case you have to use xmlHTTPRequest object to send data to other application. check the following weblog where the data is excanged between pages (xml) but the same applies for between different systems.

/people/sap.user72/blog/2005/08/15/ajax-and-htmlb--a-sample-bsp-application

(this is one of the ways, you can also use cl_http_client class to do similar stuff check this weblog on the same /people/brian.mckellar/blog/2004/06/25/bsp-programming-rss-httpclient-xml-xslt)

Regards

Raja

Re: Communication between two web servers with XML data

Former Member — Sun, 15 Apr 2007 13:14:23 GMT

Thanks a lot Raja .

I will go thru the links and revert to you . Thanks for all the time you have spent for me .

Regards,

Laxman Nayak.