10 Replies Latest reply on Nov 25, 2019 2:30 AM by Rakesh Rajasekar

BAO Remedy request to XML container

Rakesh Rajasekar Nov 6, 2019 6:05 AM

Share This:

Dear All,

I am trying to fetch data from Remedy SQL Adapter in BAO and put the value in XML as container.

But failing to split the value on requests.

SQL Request is good :

Then Moving the values to another conten item is good.

<request-data>

<remedy-action>

<Event_ID>EV0000000000001</Event_ID>

</values>

<Event_ID>EV0000000000002</Event_ID>

</values>

<Event_ID>EV0000000000003</Event_ID>

</values>

</remedy-action>

</request-data>]

But the problem here is what am getting in one string.

[Event_ID=EV0000000000001EV0000000000002EV0000000000003]

I need to put my values inside below XML

<soapenv:Body>

<tb:ABCEvent>

<tb:type>abc_event</tb:type>

<tb:version>0.5</tb:version>

<tb:id>Event_ID</tb:id>

</soapenv:Body>

Requriment is fetch data using SQL adaptor and put the values inside the XML string.

Anyone can help here please.

Thanks,

1. Re: BAO Remedy request to XML container

Matthew Highcove Nov 6, 2019 8:21 AM (in response to Rakesh Rajasekar)

It looks like you're using a transform that gets the contents of the Event_ID fields instead of adding them to XML. Please show us how you are changing this input to transform it into a single string.

Do you want all the Event_IDs in a single soapenv element, or do you want separate soapenv elements for each Event_ID? If you want the former, we need to see what the final XML format will be. If you want the latter, you have to run several transforms; XSLT can only output one XML document, so if you want to produce multiple documents, you will probably want a For activity to run some set of activities for each Event_ID.
Like Show 0 Likes(0)

Actions
2. Re: BAO Remedy request to XML container

Aryan Anantwar Nov 6, 2019 8:39 AM (in response to Rakesh Rajasekar)

Hi Rakesh,

If you are getting EVENT_ID's in below format:
<result>
<column name="EVENT_ID" label="EVENT_ID">EV0000000000001</column>
<column name="EVENT_ID" label="EVENT_ID">EV0000000000002</column>
<column name="EVENT_ID" label="EVENT_ID">EV0000000000003</column>
</result>

Then you can use this XML as input for a xslt where you can construct the SOAP envelope and insert all or specific EVENT_ID values in soap envelope using XPATH and XSLT functions in Advanced Transform Editor.

Regards,
Aryan Anantwar
Like Show 0 Likes(0)

Actions
3. Re: BAO Remedy request to XML container

Rakesh Rajasekar Nov 6, 2019 9:32 AM (in response to Aryan Anantwar)

Thanks Arayan,
any examples would be really help full.

I need to send soap message in single element to interface.

am trying to get Event ID using Xpath transformation using below ,

//Event_ID/text()

Then I get the values as like this ,

Event_ID=EV0000000000001EV0000000000002EV0000000000003]

how can I split or any sample program if you have to achieve this requirement ?

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.abc.de/service/abc_talend">
   <soapenv:Header/>
<soapenv:Body>
      <tb:abcEvent>
         
         <type>CRQUpdate</type>
         
         <version>1.0</version>
                               <abc:abcUpdateEvent xmlns:abc="http://abc.com/wos/ifaces">
    <abc:id>string</abc:id>
                                               <abc:type>string</abc:type>
                                                <abc:version>string</abc:version>
                                                <abc:updateCRQ>
                                                                <abc:release>
                                                                   <abc:id>EV0000000000001EV0000000000002EV0000000000003</abc:id>
                                                                   <abc:template>String</abc:template>
                                                                   <abc:milestone>String</abc:milestone>
                                                                   <abc:status>String</abc:status>
                                                                   <abc:source>String</abc:source>
                                                                   <abc:xaktaRelevant>true</abc:xaktaRelevant>
                                                                   <abc:properties> </abc:properties>
                                                                </abc:release>
                                                                <abc:crq>
                                                                   <abc:id>String</abc:id>
                                                                   <abc:template>String</abc:template>
                                                                   <abc:status>String</abc:status>
                                                                   <abc:workflowType>String</abc:workflowType>
                                                                   <abc:source>String</abc:source>
                                                                   <abc:statusReason>String</abc:statusReason>
                                                                   <abc:mainCI>String</abc:mainCI>
                                                                   <abc:scheduledStartDate>String</abc:scheduledStartDate>
                                                                   <abc:properties></abc:properties>
                                                                </abc:crq>
                                                   <abc:change>
                                                                  <abc:modifiedDate>String</abc:modifiedDate>
                                                                  <abc:modifiedBy>String</abc:modifiedBy>
                                                   </abc:change>
                                                </abc:updateCRQ>
                                </abc:abcUpdateEvent>
      </tb:abcEvent>
   </soapenv:Body>
</soapenv:Envelope>
Like Show 0 Likes(0)

Actions
4. Re: BAO Remedy request to XML container

Rakesh Rajasekar Nov 6, 2019 9:42 AM (in response to Matthew Highcove)

Thanks Matthew for your reply.

Is there any way I can store or copy to token element in XSLT transformation ?
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:java="http://xml.apache.org/xslt/java" version="1.0" exclude-result-prefixes="java">
<xsl:template match="/">
    <items>
      <xsl:for-each select="//row">
        <items>
          <fields>
            <values>
              <Event_ID>
                <xsl:value-of select="column[@name="EVENT_ID"]/text()" disable-output-escaping="no" />
              </Event_ID>
            </values>
          </fields>
        </items>
      </xsl:for-each>
    </items>
</xsl:template>
</xsl:stylesheet>

in same transaction ?
Like Show 0 Likes(0)

Actions
5. Re: BAO Remedy request to XML container

Aryan Anantwar Nov 7, 2019 4:31 AM (in response to Rakesh Rajasekar)

Hi Rakesh,

Can you tell us which format you want to embed EVENT_ID values in SOAP element?
Like below:
<abc:release>
   <abc:id>
    <Event_ID>EV0000000000001</Event_ID>
    <Event_ID>EV0000000000002</Event_ID>
    <Event_ID>EV0000000000003</Event_ID>
   </abc:id>
   <abc:template>String</abc:template>
   <abc:milestone>String</abc:milestone>
   <abc:status>String</abc:status>
   <abc:source>String</abc:source>
   <abc:xaktaRelevant>true</abc:xaktaRelevant>
   <abc:properties> </abc:properties>
</abc:release>

or

<abc:release>
   <abc:id>EV0000000000001</abc:id>
   <abc:template>String</abc:template>
   <abc:milestone>String</abc:milestone>
   <abc:status>String</abc:status>
   <abc:source>String</abc:source>
   <abc:xaktaRelevant>true</abc:xaktaRelevant>
   <abc:properties> </abc:properties>
</abc:release>
<abc:release>
   <abc:id>EV0000000000002</abc:id>
   <abc:template>String</abc:template>
   <abc:milestone>String</abc:milestone>
   <abc:status>String</abc:status>
   <abc:source>String</abc:source>
   <abc:xaktaRelevant>true</abc:xaktaRelevant>
   <abc:properties> </abc:properties>
</abc:release>
<abc:release>
   <abc:id>EV0000000000003</abc:id>
   <abc:template>String</abc:template>
   <abc:milestone>String</abc:milestone>
   <abc:status>String</abc:status>
   <abc:source>String</abc:source>
   <abc:xaktaRelevant>true</abc:xaktaRelevant>
   <abc:properties> </abc:properties>
</abc:release>

It would be great if you can construct manually the the expected output SOAP/XML and then we can help you to achieve it.

Regards,
Aryan Anantwar
Like Show 0 Likes(0)

Actions
6. Re: BAO Remedy request to XML container

Rakesh Rajasekar Nov 8, 2019 9:20 AM (in response to Aryan Anantwar)

am able to process the record but it is processing only one record now.

I have attached the logs can you help here please.

08 Nov 2019 12:01:58,304 Preparing to test the process.........
08 Nov 2019 12:01:58,307 Starting Local Peers on the grid........
08 Nov 2019 12:01:58,355 Started all local peers.
08 Nov 2019 12:01:58,355 ---------------------------------------------------
08 Nov 2019 12:01:58,355 -- About to Start WorkFlow Testing
08 Nov 2019 12:01:58,355 ---------------------------------------------------
08 Nov 2019 12:01:58,355 Process Details:
08 Nov 2019 12:01:58,355 Grid Name: UTSE2EGRID
08 Nov 2019 12:01:58,355 Module Name: UTS_Events
08 Nov 2019 12:01:58,355 Process ID: :UTS_Events:Outbound_Events:Infrastructure_Change
08 Nov 2019 12:01:58,396 Launch Requested
08 Nov 2019 12:01:58,418 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [ProcessStart=The process started. It is triggered by the scheduler.]
08 Nov 2019 12:01:58,681 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416]
[TEXT=---DB query response----]
[DBWOS_Response=
<sql-adapter-response>
<statement-responses>
    <statement-response>
      <statement-metadata>
        <response-set-count>0</response-set-count>
        <status>success</status>
      </statement-metadata>
      <response-sets>
        <response-set index="1">
          <response-set-metadata>
            <status>success</status>
          </response-set-metadata>
          <result-sets>
            <result-set>
              <row>
                <column name="SOAP_TALEND" label="SOAP_TALEND"><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
<soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000150</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
            <uts:id>EV0000000000150</uts:id>
            <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518184</uts:id>
                  <uts:template>change:eNode-B:HW:modify</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Cancelled</uts:status>
                  <uts:source>NETsite</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559214</uts:id>
                  <uts:template>BO-Konfig/GU_Umbau_Normal</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>Change</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason></uts:statusReason>
                  <uts:mainCI></uts:mainCI>
                  <uts:scheduledStartDate></uts:scheduledStartDate>
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:51:55</uts:modifiedDate>
                  <uts:modifiedBy>e2e3</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope></column>
              </row>
              <row>
                <column name="SOAP_TALEND" label="SOAP_TALEND"><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
<soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000151</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
            <uts:id>EV0000000000151</uts:id>
            <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518185</uts:id>
                  <uts:template>new:SDH::</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Closed</uts:status>
                  <uts:source>APT</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559216</uts:id>
                  <uts:template>GU_Aufbau Standard</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>New</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason></uts:statusReason>
                  <uts:mainCI></uts:mainCI>
                  <uts:scheduledStartDate></uts:scheduledStartDate>
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:53:18</uts:modifiedDate>
                  <uts:modifiedBy>intf</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope></column>
              </row>
              <metadata>
                <query-executed>select SOAP_TALEND from ARADMIN.UTS_WOS_Events where Action='START'</query-executed>
                <execution-milliseconds>0</execution-milliseconds>
                <row-count>2</row-count>
                <column-count>1</column-count>
                <status>success</status>
              </metadata>
            </result-set>
          </result-sets>
        </response-set>
      </response-sets>
    </statement-response>
</statement-responses>
</sql-adapter-response>]
08 Nov 2019 12:01:58,688 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416]
[TEXT=LooooooooooooooooooooooooooooopFunction]
[Count Of Records=2.0]
[Chunk=2]
[Temp=2]
[ChunkRequest=
<result>
<row>
    <column name="SOAP_TALEND" label="SOAP_TALEND"><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
<soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000151</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
            <uts:id>EV0000000000151</uts:id>
            <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518185</uts:id>
                  <uts:template>new:SDH::</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Closed</uts:status>
                  <uts:source>APT</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559216</uts:id>
                  <uts:template>GU_Aufbau Standard</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>New</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason></uts:statusReason>
                  <uts:mainCI></uts:mainCI>
                  <uts:scheduledStartDate></uts:scheduledStartDate>
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:53:18</uts:modifiedDate>
                  <uts:modifiedBy>intf</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope></column>
</row>
</result>]
[Looping=
<looper>
<chunk />
</looper>]
[loopcount=1]
08 Nov 2019 12:01:58,702 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416]
[Values=
<items>
<XMLTalend><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
<soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000151</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
            <uts:id>EV0000000000151</uts:id>
            <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518185</uts:id>
                  <uts:template>new:SDH::</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Closed</uts:status>
                  <uts:source>APT</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559216</uts:id>
                  <uts:template>GU_Aufbau Standard</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>New</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason></uts:statusReason>
                  <uts:mainCI></uts:mainCI>
                  <uts:scheduledStartDate></uts:scheduledStartDate>
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:53:18</uts:modifiedDate>
                  <uts:modifiedBy>intf</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope></XMLTalend>
</items>]
[Remedy Request=
<request-data>
<remedy-action>
    <items>
      <XMLTalend><soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
<soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000151</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
            <uts:id>EV0000000000151</uts:id>
            <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518185</uts:id>
                  <uts:template>new:SDH::</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Closed</uts:status>
                  <uts:source>APT</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559216</uts:id>
                  <uts:template>GU_Aufbau Standard</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>New</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason></uts:statusReason>
                  <uts:mainCI></uts:mainCI>
                  <uts:scheduledStartDate></uts:scheduledStartDate>
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:53:18</uts:modifiedDate>
                  <uts:modifiedBy>intf</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope></XMLTalend>
    </items>
</remedy-action>
</request-data>]
[XMLTalend=<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
<soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000151</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
            <uts:id>EV0000000000151</uts:id>
            <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518185</uts:id>
                  <uts:template>new:SDH::</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Closed</uts:status>
                  <uts:source>APT</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559216</uts:id>
                  <uts:template>GU_Aufbau Standard</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>New</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason></uts:statusReason>
                  <uts:mainCI></uts:mainCI>
                  <uts:scheduledStartDate></uts:scheduledStartDate>
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:53:18</uts:modifiedDate>
                  <uts:modifiedBy>intf</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope>]
08 Nov 2019 12:01:58,711 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416]
[TEXT=----Adapter request to prepare Soap message----]
[AdapterRequest=
<request-data>
<soap-rpc-request>
    <use-ssl-certificate>$[SLCert]</use-ssl-certificate>
    <install-certificate>false</install-certificate>
    <allow-unsigned-certificate>true</allow-unsigned-certificate>
    <passphrase>****MASKED****</passphrase>
    <http-connection-properties />
    <transport>https-rpc</transport>
    <soap-url>http://demucvpr111:8201/services/UTS_TalendBus?wsdl</soap-url>
    <soap-message>
      <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:tb="http://www.telefonica.de/service/uts_talend">
        <soapenv:Body>
          <tb:UTSEvent>
            <tb:type>uts_event</tb:type>
            <tb:version>0.5</tb:version>
            <tb:id>EV0000000000151</tb:id>
            <uts:utsUpdateEvent xmlns:uts="http://telefonica.com/wos/ifaces">
              <uts:id>EV0000000000151</uts:id>
              <uts:type>CRQUpdate</uts:type>
              <uts:version>1.0</uts:version>
              <uts:updateCRQ>
                <uts:release>
                  <uts:id>RLM000000518185</uts:id>
                  <uts:template>new:SDH::</uts:template>
                  <uts:milestone>Close Down</uts:milestone>
                  <uts:status>Closed</uts:status>
                  <uts:source>APT</uts:source>
                  <uts:xaktaRelevant>0</uts:xaktaRelevant>
                  <uts:properties />
                </uts:release>
                <uts:crq>
                  <uts:id>CRQ000002559216</uts:id>
                  <uts:template>GU_Aufbau Standard</uts:template>
                  <uts:status>Closed</uts:status>
                  <uts:workflowType>New</uts:workflowType>
                  <uts:source>x:akta</uts:source>
                  <uts:statusReason />
                  <uts:mainCI />
                  <uts:scheduledStartDate />
                </uts:crq>
                <uts:change>
                  <uts:modifiedDate>07.11.2019 13:53:18</uts:modifiedDate>
                  <uts:modifiedBy>intf</uts:modifiedBy>
                </uts:change>
              </uts:updateCRQ>
            </uts:utsUpdateEvent>
          </tb:UTSEvent>
        </soapenv:Body>
      </soapenv:Envelope>
    </soap-message>
</soap-rpc-request>
</request-data>]
08 Nov 2019 12:01:58,964 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416]
[TEXT=Adapter response from interface]
[AdapterResponse=
<soap-response>
<metadata>
    <status>success</status>
</metadata>
<soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
    <soap:Body>
      <TalendStatus xmlns="http://www.telefonica.de/service/uts_talend">
        <ErrorCode>0</ErrorCode>
        <Status>SUCCESS</Status>
      </TalendStatus>
    </soap:Body>
</soap:Envelope>
</soap-response>]
08 Nov 2019 12:01:58,969 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [TEXT=Looping chunks] [ChunkRecords=]
08 Nov 2019 12:01:58,970 [Current Time=Fri Nov 08 12:01:58 CET 2019] [Process Name=:UTS_Events:Outbound_Events:Infrastructure_Change] [Root Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [Job Id=8aae1ab921947501:-20356f35:16e4a4fc4ab:-80001-1573210918416] [ProcessTermination=The process terminated in the completed state. The process started at 08 Nov 2019 12:01:58,418, terminated at 08 Nov 2019 12:01:58,969, and the execution took 551 milliseconds.]

Thanks
Like Show 0 Likes(0)

Actions
7. Re: BAO Remedy request to XML container

Aryan Anantwar Nov 11, 2019 8:57 AM (in response to Rakesh Rajasekar)
Hi Rakesh,

After looking at above logs, it seems much straight forward solution.
you are getting already constructed Soap Envelope form DB in your DBWOS_Response context item.
Just use DBWOS_Response context item in for..loop activity with XPATH as //row and have a loop context item as row
In for.. loop add an Assign activity and extract the SoapEnvelope from row context item using XPATH as //column/* and store output in soap envelope context item
add a web service workflow and pass this oap envelope context item to it.
in for..loop the same will be repeated for all rows in the DBWOS_Response context item and records will get created for all.

described an approach here, you need to implement according to your workflows.

Regards,
Aryan Anantwar
1 of 2 people found this helpful
Like Show 0 Likes(0)

Actions
8. Re: BAO Remedy request to XML container

Rakesh Rajasekar Nov 12, 2019 10:22 AM (in response to Rakesh Rajasekar)

Thanks for the help..it works
Like Show 0 Likes(0)

Actions
9. Re: BAO Remedy request to XML container

Carl Wilson Nov 15, 2019 1:41 AM (in response to Rakesh Rajasekar)

Hi Rakesh,
please mark the answer that solved your problem "Correct Answer".

Cheers
Carl
Like Show 0 Likes(0)

Actions
10. Re: BAO Remedy request to XML container

Rakesh Rajasekar Nov 25, 2019 2:30 AM (in response to Aryan Anantwar)

Correct Answer
Like Show 0 Likes(0)

Actions