Dear all,
First of all, I'm already very sorry, as this might to be a very basic question... But I am starting to dig into Talend and still feel quite lost :-)
What I would like to do is (I guess) pretty simple: download an xml or csv file through http, map it against an existing PostgreSql table and populate the Postrgre table with the records of the input file.
My problem is that the component tFileInputDelimited seems to accept only local files and don't recognize my http string:
http://earthquake.usgs.gov/earthquakes/catalogs/eqs1day-M1.txt Is there a particular syntax? or did I forget to do something? a component that will download the file to feed the tFileInputDelimited component?
Thanks a lot in advance for your help!
Stéphane
Hi Shong,
I followed this example as explained by you. I am getting exception as below:
Exception in component tFileFetch_1
java.lang.Exception: Method failed: HTTP/1.1 405 Method Not Allowed
at talenddemosjava.filefetchfromhttp_0_1.FileFetchFromHTTP.tFileFetch_1Process(FileFetchFromHTTP.java:427)
at talenddemosjava.filefetchfromhttp_0_1.FileFetchFromHTTP.runJobInTOS(FileFetchFromHTTP.java:1263)
at talenddemosjava.filefetchfromhttp_0_1.FileFetchFromHTTP.main(FileFetchFromHTTP.java:1125)
The settings are exactly similar as given here, only difference is, my url is https so I have selected the protocol as https. (tried with http too!)
Screenshots are attached.
Appreciate your help!!
The method specified in the Request-Line is not allowed for the resource identified by the Request-URI. The response MUST include an Allow header containing a list of valid methods for the requested resource. Try to uncheck the box 'post method'.
Best regards
Shong
