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

Outbound data connectivity-parsing XML in server side javascript


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:


<script />


<status > 0


<hour value="1">

<inCount > 30




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


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

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