Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am reading data from REST endpoint which is in XML format. Below is the format of data.
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<ns2:GetRawDataOutputElement xmlns:ns2="http://xml.ws.abc.com/">
<conversations>
<conversationId>6d0ef73c</conversationId>
<conversationTimestamp>2020-01-25T03:43:43.398Z</conversationTimestamp>
<clickedLinkURL>
<URL>https://service.abc.com/c/portal/iframe/977729/</URL>
<URL>https://service.abc.com/c/portal/iframe/860182/</URL>
</clickedLinkURL>
</conversations>
</ns2:GetRawDataOutputElement>
</soap:Body>
</soap:Envelope>
Here if you see the clickedLinkURL has 2 URL tags in it but using the below SQL query I get only one. Any help here to get both the URL?
Below is the SQL script.
SQL SELECT
"attr:soap" AS "soap",
"__KEY_Envelope",
(SELECT
"__KEY_Body",
"__FK_Body",
(SELECT
"attr:ns2" AS "ns2",
"__KEY_GetRawDataOutputElement",
"__FK_GetRawDataOutputElement",
(SELECT
"conversationId",
"conversationTimestamp",
"__KEY_conversations",
"__FK_conversations",
(SELECT
"URL"
,"__FK_clickedLinkURL"
FROM "clickedLinkURL" FK "__FK_clickedLinkURL")
FROM "conversations" PK "__KEY_conversations" FK "__FK_conversations")
FROM "GetRawDataOutputElement" PK "__KEY_GetRawDataOutputElement" FK "__FK_GetRawDataOutputElement")
FROM "Body" PK "__KEY_Body" FK "__FK_Body")
FROM XML "Envelope" PK "__KEY_Envelope" with connection( BODY "$(vRequestBody)");