Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

pedro
2012-05-17 04:43:18

Hi

You can't get value of row1.ID with this job. The value will be null.

tFileInputXML--main-->tJavaRow
           |
   Iterate
           |
tWebServiceInput--main-->tFileOutputDelimited


Regards,
Pedro

webarnes99
2012-05-16 22:53:11

Hello --

I have had a chance to read through the web service documentation and I have been able to query the data that I need from the web service, so again thank you for pointing me to the docs.  I am now trying to iterate through the results of one of my method calls to pass to another web service method.  I am trying to understand how I can send  each result to the webservice component as a parameter value.

For some background I am dumping the first method to an XML file and then I am trying to iterate through the next method by passing a field called ID from the XML file.  My setup is as follows:

tFileInputXML -> tWebServiceInput ->tFileOutputDelimited

I have tried setting the webservice parameter value to row1.ID but that does not seem to work. 

Any help is appreciated.

webarnes99
2012-05-15 05:03:41

I was trying to download the documentation earlier and had some problems with the page loading.  i was able to figure out the parameter issue as it looks like the component expects the values to be in sequence meaning that if username is the first parameter, then it gets your first value.

Thanks for pointing me to a good link.

pedro
2012-05-15 04:18:44

Hi

Have you downloaded the document [TalendOpenStudio_Components_RG_51a_EN] and read the scenarios about tWebService and tWebServiceInput?

Regards,
Pedro

webarnes99
2012-05-14 17:55:05

Hello

I am trying to grab some data from a web service using Talend and I am struggling to pass parameter key/value pairs to the service to authenticate the request.  The WSDL looks like this:

<s:element name="GetBuildings">
  <s:complexType>
    <s:sequence>
      <s:element minOccurs="0" maxOccurs="1" name="UserName" type="s:string"/>
      <s:element minOccurs="0" maxOccurs="1" name="Password" type="s:string"/>
   </s:sequence>
  </s:complexType>
</s:element>

The call returns the following:

<NewDataSet>
  <Data>
    <Description>Denver</Description>
    <BuildingCode>DEN</BuildingCode>
    <ID>1</ID>
    <TimeZoneDescription>Mountain Time</TimeZoneDescription>
    <TimeZoneAbbreviation>MT</TimeZoneAbbreviation>
    <CurrentLocalTime>2012-05-13T19:39:18.547</CurrentLocalTime>
  </Data>
  <Data>
    <Description>Seattle</Description>
    <BuildingCode>SEA</BuildingCode>
    <ID>2</ID>
    <TimeZoneDescription>Pacific Time</TimeZoneDescription>
    <TimeZoneAbbreviation>PT</TimeZoneAbbreviation>
    <CurrentLocalTime>2012-05-13T18:39:18.547</CurrentLocalTime>
  </Data>
</NewDataSet>

I have created a schema to map these return values to the output portion of the webservice component but cannot get past the username and password being sent to the service.  Any help is appreciated.

Board footer

Powered by FluxBB