Web Service In kettle

[ccfiel]

Hello,

I am very new in kettle. I am interested in data integration in web service. I have test the sample "Web services lookup - convert degrees Celsius to Farenheit". It tested ok but the in and out is simple. this is the xml for the web service input.

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:adin="http://3e.pl/ADInterface">
   <soapenv:Header/>
   <soapenv:Body>
      <adin:queryData>
         <adin:ModelCRUDRequest>
            <adin:ModelCRUD>
               <adin:serviceType>QueryBPartner</adin:serviceType>
               <adin:DataRow>
                  <adin:field column="C_BP_Group_ID">
                     <adin:val>103</adin:val>
                  </adin:field>
               </adin:DataRow>

            </adin:ModelCRUD>
            <adin:ADLoginRequest>
               <adin:user>WebService</adin:user>
               <adin:pass>WebService</adin:pass>
               <adin:lang>en_US</adin:lang>
               <adin:ClientID>11</adin:ClientID>
               <adin:RoleID>50004</adin:RoleID>
               <adin:OrgID>11</adin:OrgID>
               <adin:WarehouseID>103</adin:WarehouseID>
               <adin:stage>9</adin:stage>
            </adin:ADLoginRequest>
         </adin:ModelCRUDRequest>
      </adin:queryData>
   </soapenv:Body>
</soapenv:Envelope>

Can pentaho web service input handle this? Hope somebody can give me some tips.


chris

[mark.dathorne]

The Pentaho guys added some good web services handling but it's still to be released in version 4.0.
If you can, try out the Continuous Integration release but it is a development version and "not for Production use".

Actual testing of a web service is simple enough ... follow some of the examples.

http://forums.pentaho.org/showthread.php?t=68445

Hope this helps.

Mark Dathorne

[ccfiel]

Mark,

Thanks for the reply. Did you have the success in using Get data from XML" step. as a work around for a complex types as Matt suggested? or Do I really need to wait for version 4?


Chris

[mark.dathorne]

As I remember (it was a few months ago), yes, the Get data from Xml step dealt with complex types.

Do a small test on the wsdl and see what you get. PDI is quite an nice tool to get a few small test transformations working.

Cheers,

Mark

[gutlez]

Also,

If you look around (I can't remember exactly where) there's a sample video which shows how to send a query to a WSDL server, and process the result. The result being processed included Arrays and custom data types (Movie Theater Listings, using live listings & US Zip Codes)

[ccfiel]

Hello gutlez,

Yes I have seen that video. I think this is the link
http://michaeltarallo.blogspot.com/2...tegration.html

I tried this demo and it works very good. but the demo is showing only the output of the web service with complex types. How about the input with complex types? Would this apply to?

Chris

[gutlez]

That one, I'm not sure about.
Apparently, I mis-understood that it was for complex inputs