XML FEED (Web service)

One Star

XML FEED (Web service)

Hi,
I have been given a test URL which returns a set of data if I use the XML external connector in MSAccess.   I can't, though, seem to find the right connector to use in Talend.  I have tried tHTTPRequest, tSOAP, tWebservice and tfilefetch etc but I don't really understand the makeup of the URL, which is:
.<domain>/api/get_properties.php?clientID=<long id>&passphrase=<password>.
Can anyone set out what conector to use nd how to configure the same?
Regard
The error being generated is:
Starting job JUPIX_ETL at 12:34 27/01/2017.
connecting to socket on port 3689
connected
Jan 27, 2017 12:34:12 PM com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection post
SEVERE: SAAJ0009: Message send failed
Exception in component tSOAP_1
com.sun.xml.messaging.saaj.SOAPExceptionImpl: java.security.PrivilegedActionException: com.sun.xml.messaging.saaj.SOAPExceptionImpl: Message send failed
at com.sun.xml.messaging.saaj.client.p2p.HttpSOAPConnection.call(HttpSOAPConnection.java:191)
at org.talend.soap.SOAPUtil.invokeSOAP(SOAPUtil.java:147)...........
 
Moderator

Re: XML FEED (Web service)

Hi,
.<domain>/api/get_properties.php?clientID=<long id>&passphrase=<password>.

Can you open this webservice through browser by using your test URL? Do want to fetch file from it? Can you open this webservice through browser?
Could you please give us more information about your job requirement?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.