Can we pass Dynamic values to WebService Request

Six Stars

Can we pass Dynamic values to WebService Request

 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.

Seven Stars

Re: Can we pass Dynamic values to WebService Request

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.

Regards
Aashish
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Can we pass Dynamic values to WebService Request

Hi Aashish,

 

Thanks for your Quick response .

I will check and update you.

 

Regards,

P.Surendra.

Six Stars

Re: Can we pass Dynamic values to WebService Request

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.

 

 

 

Six Stars

Re: Can we pass Dynamic values to WebService Request

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:INFOSmiley Surprisedejs.Server:jetty-8.1.14.v20131031
2018-06-14 16:27:23.350:INFOSmiley Surprisedejs.AbstractConnectorSmiley Frustratedtarted SelectChannelConnector@localhost:8090
web service [endpoint: http://localhost:8090/services/CustomerUpdate] published