Skip to Content

how to read sub elements nodes by using content filter in hana cloud integration

Hi Experts,

I have a requirement there is sub hierarchical nodes from the incoming XML message.

I'm trying to pick in that one Node with using Content Filter but not getting it.

Incoming XML message:

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/">
    <env:Header />
    <env:Body>
        <m:executeServiceResponse xmlns:m="http://webservices.com">
            <executeServiceReturn>
                <FIXML xsi:schemaLocation="http://www.finacle.com/fixml ODAcctAdd.xsd" xmlns="http://www.finacle.com/fixml" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
                    <Header>
                        <ResponseHeader>
                            <RequestMessageKey>
                                <RequestUUID>B2B_201802231113</RequestUUID>
                                <ServiceRequestId>ODAcctA</ServiceRequestId>
                                <ServiceRequest>10</ServiceRequest>
                                <ChannelId>COR</ChannelId>
                            </RequestMessageKey>
                        </ResponseHeader>
                    </Header>
                    <Body>
                        <Error>
                            <FIBusinessException>
                                <ErrorDetail>
                                    <ErrorCode>BSM</ErrorCode>
                                    <ErrorDesc>invalid.</ErrorDesc>
                                    <ErrorSource>acctCommon</ErrorSource>
                                    <ErrorType>BE</ErrorType>
                                </ErrorDetail>
                                <ErrorDetail>
                                    <ErrorCode>BSM</ErrorCode>
                                    <ErrorDesc>Customer</ErrorDesc>
                                    <ErrorSource>acctCommon</ErrorSource>
                                    <ErrorType>BE</ErrorType>
                                </ErrorDetail>
                            </FIBusinessException>
                        </Error>
                    </Body>
                </FIXML>
            </executeServiceReturn>
        </m:executeServiceResponse>
    </env:Body>
</env:Envelope>

Expected output XML message:

                    <Body>
                        <Error>
                            <FIBusinessException>
                                <ErrorDetail>
                                    <ErrorCode>BSM</ErrorCode>
                                    <ErrorDesc>invalid.</ErrorDesc>
                                    <ErrorSource>acctCommon</ErrorSource>
                                    <ErrorType>BE</ErrorType>
                                </ErrorDetail>
                                <ErrorDetail>
                                    <ErrorCode>BSM</ErrorCode>
                                    <ErrorDesc>Customer</ErrorDesc>
                                    <ErrorSource>acctCommon</ErrorSource>
                                    <ErrorType>BE</ErrorType>
                                </ErrorDetail>
                            </FIBusinessException>
                        </Error>
                    </Body>

Please suggest.

Thanks and Regrads,

Md.Thouheed

111.jpg (36.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi Mohammad. Please take a look at your open questions, and accept answers where they've helped solve the issue. Then, after accepting an answer, mark the question as closed. Regards, Morten.

  • Get RSS Feed

1 Answer

  • Best Answer
    Feb 26 at 03:58 AM

    Hi Thouheed,

    You could use xslt mapping to remove the namespaces.

    and the use filter as mentioned below.

    Hope this helps!!

    regards,

    Praveen T

    Add comment
    10|10000 characters needed characters exceeded