Skip to Content
0
Sep 14, 2018 at 07:33 AM

XML data fiter in SAP HCI

1668 Views

Dear Experts-

I have an issue with extracting certain data and send the data to XSLT mapping. I am doing a real time query to API using a Survey Key to fetch the results. I am generating multiple files which has following 2 of data in separate files..

Data 1 which works fine with my XSLT mapping as it has results for the survey key.

<?xml version='1.0' encoding='UTF-8'?>

<Root>

<Element>

<SK>319010</SK>

</Element>

<Element>

<meta/>

<data>

<ts>2017-12-01T14:12:58.000-08:00</ts>

<r>0</r>

</data>

<data>

<ts>2017-12-01T14:12:59.000-08:00</ts>

<r>0</r>

</data>

</Element>

</Root>

Data 2 which my XSLT map fails because no data for particular survey key.

<?xml version='1.0' encoding='UTF-8'?>

<Root>

<Element> <SK>216621</SK>

</Element> <Element>

<meta/>

<data/>

</Element> </Root>


I need to filter the data before sending it to map in a way that I will send only survey key data which has results. I am trying to use Filter and Router in HCI but am not successful. This is really urgent as have golive in 2 days. If you can help to get this through it would be much appreciated.

Regards

HS