9 Replies Latest reply on Nov 15, 2019 1:41 AM by Carl Wilson

    BAO Remedy request to XML container

    Rakesh Rajasekar
      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 :

      <column name="EVENT_ID" label="EVENT_ID">EV0000000000003</column>

       

      Then Moving the values to another conten item is good.

       

      <request-data>

        <remedy-action>

          <values>

            <Event_ID>EV0000000000001</Event_ID>

          </values>

          <values>

            <Event_ID>EV0000000000002</Event_ID>

          </values>

          <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

          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.

          • 2. Re: BAO Remedy request to XML container
            Aryan Anantwar

            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

            • 3. Re: BAO Remedy request to XML container
              Rakesh Rajasekar

              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>

                       <!--Optional:-->

                       <type>CRQUpdate</type>

                       <!--Optional:-->

                       <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>

              • 4. Re: BAO Remedy request to XML container
                Rakesh Rajasekar

                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=&quot;EVENT_ID&quot;]/text()" disable-output-escaping="no" />

                              </Event_ID>

                            </values>

                          </fields>

                        </items>

                      </xsl:for-each>

                    </items>

                  </xsl:template>

                </xsl:stylesheet>

                 

                in same transaction ?

                • 5. Re: BAO Remedy request to XML container
                  Aryan Anantwar

                  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

                  • 6. Re: BAO Remedy request to XML container
                    Rakesh Rajasekar

                    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

                    • 7. Re: BAO Remedy request to XML container
                      Aryan Anantwar

                      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 1 people found this helpful
                      • 8. Re: BAO Remedy request to XML container
                        Rakesh Rajasekar

                        Thanks for the help..it works

                        • 9. Re: BAO Remedy request to XML container
                          Carl Wilson

                          Hi Rakesh,

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

                           

                          Cheers

                          Carl