topic Re: Read XML file in Talend Studio

Read XML file

gtaware — Thu, 14 Nov 2019 18:14:28 GMT

Hi Team,

Can please help me to read attached XML ?

Re: Read XML file

Anonymous — Fri, 15 Nov 2019 08:22:46 GMT

Hi
It is a simple XML file, not difficult to read data from it, which data do you want to extract?
As a newbie, you can create a XML metadata following the wizards in Repository-->Metadata-->FileXML, then, drag and drop the XML metadata you just created to a job, and select tFileInputXML component to read it.

Regards
Shong

Re: Read XML file

gtaware — Mon, 18 Nov 2019 08:38:22 GMT

Thanks Shong . I tried it and I am able to read a data when I click on Refresh Preview .

I have used Xpath Loop Expression as : @id , @extid and Payment Type .. But when I am using tInputXML then it is throwing me error as :

[statistics] connecting to socket on port 3964
[statistics] connected
Unparseable date: "1-800-81-3399"
[statistics] disconnected

Re: Read XML file

Anonymous — Mon, 18 Nov 2019 09:09:28 GMT

check the data type of phoneNumber column on the schema, it seems you are reading this column with Date type, if so, change it to string type.

Re: Read XML file

gtaware — Wed, 20 Nov 2019 10:42:03 GMT

Thanks Its Worked.