Webservice Client Stage - Data issue

Naren12345babu · Post by **Naren12345babu** » Mon Feb 08, 2016 12:57 pm

Hi ,

I am sending messages to Webservices through Webservices client Stage.
Output is XML message.

Input records :

ID , Code

1 , 123
2 , 345

Output to Webservices - two records are creating two seperate XML Objects as show below,

Code: Select all

	<Header>
          <IntegrationObjectID>ListedValues</IntegrationObjectID>
        </Header>
        <Body>
          <ListedValue>
            <ID>1</ID>
            <Code>123</Code>        
          </ListedValue>
        </Body>
      </ns1:PresentationLayerObject_ListedValues_Body>
    </ns1:PresentationLayerObject_ListedValues>
  </s:Body>
</s:Envelope>

*********
	<Header>
          <IntegrationObjectID>ListedValues</IntegrationObjectID>
        </Header>
        <Body>
          <ListedValue>
            <ID>2</ID>
            <Code>345</Code>        
          </ListedValue>
        </Body>
      </ns1:PresentationLayerObject_ListedValues_Body>
    </ns1:PresentationLayerObject_ListedValues>
  </s:Body>
</s:Envelope>

But I need to send both records of the same Toggle in a single XML Object. example is below,

Code: Select all

<Header>
          <IntegrationObjectID>ListedValues</IntegrationObjectID>
        </Header>
        <Body>
           <ListedValue>
            <ID>1</ID>
            <Code>123</Code>        
          </ListedValue>
          <ListedValue>
            <ID>2</ID>
            <Code>345</Code>        
          </ListedValue>
        </Body>
      </ns1:PresentationLayerObject_ListedValues_Body>
    </ns1:PresentationLayerObject_ListedValues>
  </s:Body>
</s:Envelope>

How can I get this using webservices client stage.

eostic · Post by **eostic** » Mon Feb 08, 2016 1:24 pm

You will have to learn how to use the xmlOutput Stage to build that xml, or for a small one like this, you could even just use a Transformer.....building the entire soap "body" and then using the "User Defined Message" option in the input link of the WSTransformer Stage to let DataStage know that YOU crafted the entire SOAP body yourself.....and it won't "re-cast" the xml but just wrap it with the remainder of the envelope and send it along.

Do some searching here in the forum...this has been discussed before...but first make sure you are able to create that body and just send it to a flat file for review before trying to send it into the WS Stage.

Ernie

Naren12345babu · Post by **Naren12345babu** » Mon Feb 08, 2016 1:48 pm

Hi Ernie,

Thank you, I will try the method you explained.

Naren12345babu · Post by **Naren12345babu** » Mon Feb 08, 2016 1:51 pm

Ernie,

Can I use WS transformer for complex XMLs? I have a complex one. I just created a sample one for illustrating example.

Also, the purpose is to avoid file storage on any disk before sending these files to Webservice.

I believe you are asking me to work using XML Output stage for testing purpose.

eostic · Post by **eostic** » Mon Feb 08, 2016 4:33 pm

Yes...you can use web services that have complex inputs/outputs.... and then the WSStage will only do the "communication".

But you have to build (and/or decipher) the request and the response.....generally it is the "body" that you are crafting (or parsing) and/or the header.

That is why goal #1 is to find out exactly what a valid body request and response look like......(a sample...use a tool like SOAP ui), and then work with the xmlOutput Stage (or Hierarchical Stage) to build exactly that Body (sending first to a flat file)....and then do the same with the xmlInput Stage, to parse the response (reading from a flat file)......and then put things together.

Ernie

Naren12345babu · Post by **Naren12345babu** » Wed Feb 10, 2016 7:43 am

Hi,

I used Hierarchiel transformer to do regrouping. And I got an XML file with desired output.

Currently my Job design is as below :

Oracle DB --> Transformer --> Hierarchical Data --> WS Client

Now I am getting te below error :

TGT_WBS_LISTEDVALUES,0: Info: JOB_INT_LISTEDVALUES_JDE_CAS_FinalStep_ToWebservices_2.TGT_WBS_LISTEDVALUES: 0030`:`com.ascentialsoftware.wsclient.ServiceInvocationException: Service invocation exception: Content is not allowed in prolog.
at com.ascentialsoftware.wsclient.ServiceInvocationException.<init>(ServiceInvocationException.java:44)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1602)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1544)
at com.ascentialsoftware.wspack.Transformer.process(Transformer.java:105)
at com.ascentialsoftware.jds.StageFactory.runStage(StageFactory.java:544)
at com.ascentialsoftware.jds.StageFactory.runTarget(StageFactory.java:348)
Caused by: org.xml.sax.SAXParseException: Content is not allowed in prolog.
at org.apache.xerces.parsers.DOMParser.parse(Unknown Source)
at org.apache.xerces.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at com.ascentialsoftware.wsclient.xml.TreeBuilder.xmlReaderToDom(TreeBuilder.java:325)
at com.ascentialsoftware.wsclient.InputRequest.buildRequestHeaderDocument(InputRequest.java:840)
at com.ascentialsoftware.wsclient.WebService.callServiceInternal(WebService.java:1624)
at com.ascentialsoftware.wsclient.WebService.callService(WebService.java:1591)

What is the meaning of this issue and how to resolve this. I have gone through old posts on the same error but could not get a solution

chulett · Post by **chulett** » Wed Feb 10, 2016 7:57 am

Perhaps?

http://illegalargumentexception.blogspo ... rolog.html

Naren12345babu · Post by **Naren12345babu** » Wed Feb 10, 2016 10:57 am

Any idea, How to resolve this issue.

chulett · Post by **chulett** » Wed Feb 10, 2016 11:26 am

As noted by Ernie, build a version of your job that drops your generated XML to a file rather than directly to the web service. Then you can see what, if anything, is wrong with it. The link I posted should give you an idea where to start looking at least.

eostic · Post by **eostic** » Wed Feb 10, 2016 12:56 pm

Hard to say. It sounds like it isn't liking the xml that you constructed, and isn't even able to make the initial invocation. Did you match the xml body that you see in something like SOAPui?

...did you make sure that your output is just a "chunk" of xml string? It cannot be a whole document --- just the "body" of the SOAP envelope.

It also could be a namespace issue.

Ernie

Naren12345babu · Post by **Naren12345babu** » Mon Feb 15, 2016 6:15 am

Hi,
I created Soap Project with wsdl in Soap UI.

I opened method and clicked on Request. I got below information with Soap Envelop. In the below text , which one is Soap Header ?

Code: Select all

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:acc="http://www.accenture.com/">
   <soapenv:Header/>
   <soapenv:Body>
      <acc:PresentationLayerObject_ListedValues>
         <!--Optional:-->
         <acc:PresentationLayerObject_ListedValues_Body>
            <Header>
               <IntegrationObjectID>?</IntegrationObjectID>
               <Timestamp>?</Timestamp>
               <MessageID>?</MessageID>
               <Sender>?</Sender>
               <Function>?</Function>
            </Header>
            <Body>
               <!--Zero or more repetitions:-->
               <ListedValue>
                  <!--Optional:-->
                  <Hostsource>?</Hostsource>
                  <ID>?</ID>
                  <SalesOrgs_LV>
                     <!--Zero or more repetitions:-->
                     <SalesOrg_LV>
                        <SalesOrgID>?</SalesOrgID>
                        <!--Optional:-->
                        <DefaultItemCode>?</DefaultItemCode>
                        <Items_LV>
                           <!--Zero or more repetitions:-->
                           <Item_LV>
                              <!--Optional:-->
                              <Status>?</Status>
                              <Code>?</Code>
                              <!--Optional:-->
                              <Sort>?</Sort>
                              <Descriptions_LV>
                                 <!--Zero or more repetitions:-->
                                 <Description_LV>
                                    <Language>?</Language>
                                    <Text>?</Text>
                                    <!--Optional:-->
                                    <ShortText>?</ShortText>
                                 </Description_LV>
                              </Descriptions_LV>
                           </Item_LV>
                        </Items_LV>
                     </SalesOrg_LV>
                  </SalesOrgs_LV>
               </ListedValue>
            </Body>
         </acc:PresentationLayerObject_ListedValues_Body>
      </acc:PresentationLayerObject_ListedValues>
   </soapenv:Body>
</soapenv:Envelope>

Naren12345babu · Post by **Naren12345babu** » Mon Feb 15, 2016 11:21 am

Hi, Finally the job finished and I am able to Post the XML file to Webservices.

Thank you eostic , Criag , ray for your valuable suggestions.

Job 1 :-

DB2 --> Transformer --> Hierarchical stage (XML File creation with groups)

Used Hierarchical stage to do grouping.

Job 2 :-

Folder stage --> Transformer --> Webservices client

Here I included Soap Header in Soap Message and all went fine.

ray.wurlod · Post by **ray.wurlod** » Mon Feb 15, 2016 4:39 pm

SOAP header (as you seem to have worked out) is empty

Code: Select all

   <soapenv:Header/>