topic Re: [Resolved]Add a filter on an attribute in a XML File ? in Talend Studio

[Resolved]Add a filter on an attribute in a XML File ?

Eric_Talend — Sat, 16 Nov 2024 02:17:42 GMT

Hello,

I have an XML file and I want to add a filter on my attribute.

My attribute is : status

I search on the web but I didn't find the solution.

How can I add a filter on my attribute "status" with the value "valid" ?

Many thanks

Eric.

Re: [Resolved]Add a filter on an attribute in a XML File ?

manodwhb — Fri, 29 May 2020 10:21:21 GMT

@Eric_Talend , one way is get the status colmn also in tfileinputxml and then use tfileterrows component to filter on status is valid.

Re: [Resolved]Add a filter on an attribute in a XML File ?

Eric_Talend — Fri, 29 May 2020 11:27:39 GMT

Hi,

thanks for your answer.

I understood your answer.

But I have a problem to extrat the value of the attibute.

I add the column "status"in my schema, it's OK but in the column "Request XPath", how I fill this column ?

Column Request XPath

Status ??????????

I try "../catering", it's not ok

I try "../catering@status", it's not ok

I try "../catering/status", it's not ok

Re: [Resolved]Add a filter on an attribute in a XML File ?

manodwhb — Fri, 29 May 2020 11:36:48 GMT

@Eric_Talend , can you try to use below one.

/cateringrate[@status="valid"]@status

Re: [Resolved]Add a filter on an attribute in a XML File ?

Eric_Talend — Fri, 29 May 2020 12:48:20 GMT

good !

I put "@status" and it's Ok and after, I add a filter in tXMLMap.s..

Thanks.

With tfileInputXML component, it's not possible to get an XML File ie https://mywebiste.com/xml ?

I had to copy my XML file to an local directory.

Re: [Resolved]Add a filter on an attribute in a XML File ?

manodwhb — Fri, 29 May 2020 13:04:45 GMT

@Eric_Talend ,still do you have issues?

Re: [Resolved]Add a filter on an attribute in a XML File ?

Eric_Talend — Fri, 29 May 2020 13:18:35 GMT

Yes. Last one 🙂

You can see on the screenshot below that I use a local file : "/scratch/Documents/XML/restauration.xml"

So, I would like to open a XML file who is on Internet, for exemple this XML file :

https://www.w3schools.com/xml/note.xml

If I put "https://www.w3schools.com/xml/note.xml" instead of "/scratch/Documents/XML/restauration.xml", I have an error 😞

Re: [Resolved]Add a filter on an attribute in a XML File ?

manodwhb — Fri, 29 May 2020 14:07:41 GMT

@Eric_Talend , if you need to read the data in xml from website you need to use tRest or Trestclient components.

Re: [Resolved]Add a filter on an attribute in a XML File ?

manodwhb — Fri, 29 May 2020 14:09:26 GMT

@Eric_Talend ,check this example.

https://stackoverflow.com/questions/20288184/how-to-use-the-talend-trest-component-output

Re: [Resolved]Add a filter on an attribute in a XML File ?

Eric_Talend — Fri, 29 May 2020 16:15:23 GMT

Ok, I will try during this afternoon and it works

Many, many thanks.