topic Re: Extract an XML attribute from a document in Talend Studio

Extract an XML attribute from a document

Anonymous — Wed, 17 Sep 2014 19:19:43 GMT

Hi all,
I have the following setup and I would like to extract the username from this XML. I am currently using tExtractXMLField and I've tried this xpath query /sample/@UserName but I get an error of:
Error on line 1 of document : Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.
It feels like I am missing something. Any assistance would be greatly appreciated.
Thanks!!

<?xml version="1.0" encoding="UTF-8"?>
<sample APIVersion="2013.001" SourceServer="abc123" UserName="jsmith" Operation="Search">
<Search Guid="red" />
</sample>

Re: Extract an XML attribute from a document

Anonymous — Thu, 18 Sep 2014 02:24:00 GMT

Hi,
Do you try with tFileInputXML ?

Re: Extract an XML attribute from a document

Anonymous — Thu, 18 Sep 2014 09:11:15 GMT

hi,
as Marie_Fr said, it should be easier to use tfileInputXml.
how do you propagate your xml content in tExtractedXmlField ?
What's the value of XML field ?
regards
laurent

tExtractXMLField is often use to extract a part of xml document (loop element from complex xml for example).

Re: Extract an XML attribute from a document

Anonymous — Tue, 02 Jun 2015 13:38:30 GMT

This works for me in 5.6.1:
tFixedFlowInput > tConvertType > tExtractXMLField > tLogRow
tFixedFlowInput has line separator "$", field separator "£"
tConvertType convert string to Document with "automatic conversion" checkbox activated
tExtractXMLField loop on "/", with one output field "data" with xpath "/sample/@UserName"
I think that your input XML is invalid, check this with a tLogRow. Maybe a space or a BOM ?

Re: Extract an XML attribute from a document

Anonymous — Mon, 13 Jul 2015 13:53:58 GMT

> Content is not allowed in prolog. Nested exception: Content is not allowed in prolog.
I had the same problem with a tFixedFlowInput and the XML prefixed/suffixed by ".
Then, if you see a Sax error, check if you have the character " around the XML, and remove it.