Can we pass Dynamic values to WebService Request

[Anonymous]

 Hello Support,

How can I Build a job to pass an  excel sheet input values to Web service request and than it need to store database at the same time need to see  Web Service Output response.

Example: I have Customer Excel sheet with the columns ID, PHONE, EMAIL this values need to pass Webservice Input it contains parameter list like ID, PHONE, EMAIL after this same data it needs to store in Database with respective table along with the specific columns, Mean while i need to see response in the webservie response.

Please help me on same.

Regards,

P.Surendra.

[aashish_21nov]

To read value one by one from your excel sheet you can use tFlowToIterate component. So, your job would be like:

tFileInputExcel-->tFlowToIterate-->

and then pass it to webservice and store the result into database.

[Anonymous]

Hi Aashish,

Thanks for your Quick response .

I will check and update you.

Regards,

P.Surendra.

[Anonymous]

Hi Aashish,

My WebService Request doesn't contain any method so without method if i use twebserviceinput will it work?.

I am sharing the job designed screen shot please find.

I have created a new service with the ID , PHONE, EMAIL as input and output also ID , PHONE, EMAIL

then I got the tesbservicerequest and tesbserviceresponse. Now i need to use this request and insert data into database.

Please help me on same.

Regards,

P.Surendra.

Regards,

P.Surendra.

Regards,

P.Surendra.

JOB.JPG

[Anonymous]

It is giving an error with the publishing the URL

Starting job ABCD at 16:27 14/06/2018.

[statistics] connecting to socket on port 3368
[statistics] connected
Exception in component tWebServiceInput_1 (ABCD)
java.net.ConnectException: Connection refused: connect
at java.net.DualStackPlainSocketImpl.connect0(Native Method)
at java.net.DualStackPlainSocketImpl.socketConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.doConnect(Unknown Source)
at java.net.AbstractPlainSocketImpl.connectToAddress(Unknown Source)
at java.net.AbstractPlainSocketImpl.connect(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at sun.net.NetworkClient.doConnect(Unknown Source)
at sun.net. www.http.HttpClient.openServer(Unknown Source)
at sun.net. www.http.HttpClient.openServer(Unknown Source)
at sun.net. www.http.HttpClient.<init>(Unknown Source)
at sun.net. www.http.HttpClient.New(Unknown Source)
at sun.net. www.http.HttpClient.New(Unknown Source)
at sun.net. www.protocol.http.HttpURLConnection.getNewHttpClient(Unknown Source)
at sun.net. www.protocol.http.HttpURLConnection.plainConnect0(Unknown Source)
at sun.net. www.protocol.http.HttpURLConnection.plainConnect(Unknown Source)
at sun.net. www.protocol.http.HttpURLConnection.connect(Unknown Source)
at sun.net. www.protocol.http.HttpURLConnection.getInputStream0(Unknown Source)
at sun.net. www.protocol.http.HttpURLConnection.getInputStream(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLEntityManager.setupCurrentEntity(Unknown Source)
at com.sun.org.apache.xerces.internal.impl.XMLVersionDetector.determineDocVersion(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
at org.apache.axis.utils.XMLUtils.newDocument(XMLUtils.java:369)
at org.apache.axis.utils.XMLUtils.newDocument(XMLUtils.java:420)
at org.apache.axis.wsdl.symbolTable.SymbolTable.populate(SymbolTable.java:482)
at org.apache.axis.wsdl.gen.Parser$WSDLRunnable.run(Parser.java:361)
at java.lang.Thread.run(Unknown Source)
Jun 14, 2018 4:27:22 PM org.apache.cxf.wsdl.service.factory.ReflectionServiceFactoryBean buildServiceFromWSDL
INFO: Creating Service { http://www.talend.org/service/}CustomerUpdate from WSDL: C:/Surendra/TALEND/TOS_ESB-20170510_1410-V6.4.0/Studio/workspace/TALEND/services/CustomerUpdate_1.0.wsdl
Jun 14, 2018 4:27:23 PM org.apache.cxf.endpoint.ServerImpl initDestination
INFO: Setting the server's publish address to be http://localhost:8090/services/CustomerUpdate
2018-06-14 16:27:23.301:INFO ejs.Server:jetty-8.1.14.v20131031
2018-06-14 16:27:23.350:INFO ejs.AbstractConnector tarted SelectChannelConnector@localhost:8090
web service [endpoint: http://localhost:8090/services/CustomerUpdate] published