topic Re: tInputFileXML returns null values in Open Studio 7.1 in Talend Studio

tInputFileXML returns null values in Open Studio 7.1

spr654 — Tue, 19 Feb 2019 14:13:06 GMT

Hi,

Using an xml that I have entered as metadata (I don't know why, but xsd files are not working 100% with the mapping), I have imported it as tInputFileXML in a job. This file is in attachment. This is the structure in the metadata:

In the file I have 2 transactions, and in each transactions I have 2 changeEvents. 2 of the events are of type QualificationInformationChangeEvent; and 2 are customsqualificationValidityChangeEvent.

The issue: when I try to get the 4 records, I get nulls everywhere. This is the loop XPath query that I use:

"/ns0:replicationMessage/body/transaction/changeEvent"

and the results:

What went wrong? Any help is welcome.

Re: tInputFileXML returns null values in Open Studio 7.1

Anonymous — Tue, 19 Feb 2019 14:57:53 GMT

Have you configured your XPaths? Can you show us the configuration of your tFileInputXML?

Re: tInputFileXML returns null values in Open Studio 7.1

spr654 — Tue, 19 Feb 2019 16:25:07 GMT

Hi,

thanks. Of course, here it is:

Re: tInputFileXML returns null values in Open Studio 7.1

Anonymous — Tue, 19 Feb 2019 17:07:58 GMT

I see your loop shows a namespace, but your XPaths do not. Namespaces can be a bit of a pain here. You have a couple of options, you can add your namespaces to your XPaths. This will be a bit of a pain, but means you are being 100% accurate. Alternatively, goto the "Advanced Settings" and click on the "ignore the namespaces". See if that changes anything

Re: tInputFileXML returns null values in Open Studio 7.1

spr654 — Tue, 19 Feb 2019 20:06:02 GMT

Hi rahll, Thank you very much for your help. How can I add a namespace in a xpath? Could you show a picture of what you mean? Where should I add it? Thanks for your help and support.

Re: tInputFileXML returns null values in Open Studio 7.1

Anonymous — Tue, 19 Feb 2019 22:50:17 GMT

I'm afraid I do not have any jobs where I have done this on the machine I am currently using. I tend to be lazy and just use the "ignore the namespace" option in most cases 🙂

However, this should help you (https://stackoverflow.com/questions/3931817/xpath-expression-from-xml-with-namespace-prefix)

Re: tInputFileXML returns null values in Open Studio 7.1

spr654 — Wed, 20 Feb 2019 09:48:58 GMT

Hi rahll,

ignoring the namespaces didn't work. Any ideas? I'm loosing hope...

Re: tInputFileXML returns null values in Open Studio 7.1

Anonymous — Wed, 20 Feb 2019 11:24:39 GMT

Can you give an example of your actual XML file (remove any private data) and the XPaths you have just tried please? I will take a look and see what I can suggest

Re: tInputFileXML returns null values in Open Studio 7.1

spr654 — Wed, 20 Feb 2019 15:31:43 GMT

Hi rahll,

The test I am doing since yesterday is with the file example.xml. The result is exactly the same I get with the real data. If I get to make work example.xml, that's it. The problem is that the file doesn't produce 4 records with data in Talend. It produces 4 records with null values. If I solve the problem with example.xml, I have solved the problem.

Any help is welcome.

Re: tInputFileXML returns null values in Open Studio 7.1

spr654 — Wed, 20 Feb 2019 15:54:02 GMT

Update:

I have created a new job and I have mapped manually some fields. It is working now, but it is going to take me ages to fix all the mapping manually. Here is the mapping:

Re: tInputFileXML returns null values in Open Studio 7.1

Anonymous — Wed, 20 Feb 2019 16:42:11 GMT

Sorry, I didn't see the example XML you posted originally.

Your new layout makes sense having seen that. You need to loop on the element that is the key to your row data. My assumption previously was that you had the loop element correct since you were getting the correct number of rows, albeit with nulls. This would normally be a symptom of a namespace issue from my experience. I may have jumped to that conclusion, so I apologise for sending you down the wrong track.

I know populating the XPaths like this will be time consuming, but there is no easier way of doing this. I've had to interrogate XML files with multiple nested loops which have required multiple components and hundreds of XPaths, so know it is not fun.

Re: tInputFileXML returns null values in Open Studio 7.1

spr654 — Thu, 21 Feb 2019 14:01:08 GMT

Hi,

I have finally used the wizard to create the metadata.

Taking my example file, I have created a new input xml

Then I select only the fields from QualificationInformationChangeEvent.

then, in a new job, I dragdropped the metadata as tInputXMLFile, and connected it to a tLogRow.

and it found all the records (2).

Rahll, thanks for your support. I will open now another ticket with my next issue...