Skip to Content
0
Former Member
Aug 09, 2013 at 02:20 PM

Outbound data connectivity-parsing XML in server side javascript

146 Views

Hi all,

I am trying to get data from a CGI service which provides the data only in XML format. I have used the xshttpdest file and xsjs file to access the service. I am able to get the data as text into a variable and display is as text.

The service returns:

<body>

<script />

<response>

<status > 0

</status>

<hour value="1">

<inCount > 30

</inCount>

<outCount>

18

</outCount> </hour> </response>

</body>

But what I want to achieve is to parse the XML file and put the data accordingly into respective tables. I am aware of such a functionality in terms of JSON format. See blog http://scn.sap.com/community/developer-center/hana/blog/2013/07/01/sap-hana-sps6--various-new-developer-features

The Outbound data connectivity section explains about such feature.

But I am getting the output in XML format and need to feed this into tables. Is there a way achieve this?

Kindly suggest any thing that can be done to get the data in tables.

Thanks & Regards,

Shreepad Patil