Nested Schema Issue in SAP BODS

[Former Member]

Hi BODS Gurus,

We have created a Real time service, flow of messages is as below:

Synchronous scenario:

Request:

Third party(Web service call)-> SAP BODS(Request XSD) -> SAP CRM(Function Module)

Response:

SAP CRM(Function Module) -> SAP BODS(Response XSD) -> Third Party (Web service call)

Third party has shared the request and response XSD; in BODS we have used these XSD's and shared the wsdl file with them to send the request data and receive the response back.

Request XSD contains deep nested structure.

Issue we are facing here:

When we receive the request data(nested data) and we are converting this deep nested structure and removing single level of nesting.

few fields (XML tags) are getting repeated multiple times even if in request data field occurring only once.

We have generated the files at very first level where request is received and after one query where we have removed level of nesting.

Attached screenshot of Input data and Query (where single level of nesting is removed) and below output files data for few records where is getting repeated.

Request Data:

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

<test1>

<mfResortProfileID>5775710</mfResortProfileID>

<Time>2016.01.29 10:46:30</Time>

</test1>

First Query Output Data:

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

<test2>

<mfResortProfileID>5775710</mfResortProfileID>

<Time>2016.01.29 10:46:30</Time>

<mfResortProfileID>5775710</mfResortProfileID>

<Time>2016.01.29 10:46:30</Time>

<mfResortProfileID>5775710</mfResortProfileID>

<Time>2016.01.29 10:46:30</Time>

</test2>

Please help us in resolving iissue?

Waiting for your valuable feedback.

Thanks in advance.

Regards,

SV

[former_member187605]

Have you ever had a look at the wiki pages on DS and Real-time jobs, more specifically One table to NRDM - Enterprise Information Management - SCN Wiki?

You're most probably missing the Row_Generation transform.

[Former Member]

look at it like this unnesting means you're joining two tables. Unless they dont have to a key to bind they there is going to be multiple records. try using xml pipeline transform.

Thanks

Krishna