Search in a XML with tag

Questions
1

Hello everyone :slight_smile:

I’m new on n8n, so sorry in advance if my question may seem trivial or a bit silly.

My question is very simple, I have an XML file like this one:

image
image1304×425 25.4 KB

https://catalogue.bnf.fr/api/SRU?version=1.2&operation=searchRetrieve&query=bib.isbn%20adj%20"978-2-01-322343-0"&recordSchema=intermarcXchange

How could I extract for example specifically the field with the tag “015” and the code “a”, which would give me “00914463” please ?

Because when I want to transform it into XML to JSON, I lose the separation by tag, I have then all the “mxc:datafield” which are added, but I really need by tag.

Thanks in advance to you

Dadourlou

2

Hi @Dadourlou, welcome to the community :tada:

Any chance you can share your XML file as text rather than a screenshot? This would make it a lot easier for peeps to give it a go :slight_smile:

You can use the option for preformatted text to share code:
image

1 Like
3

Obviously, sorry for the omission, I edited my message by putting the URL of the file (it is a French public API).

4

Perfect, thanks a lot!

I have put together an example workflow extracting 00914463 for you:

Example Workflow

In this workflow, I first convert this XML data into JSON data. Then throw away the values I am not interested in using the Set node, splitting out the results via an Item lists node to filter these for the tag in question.

I then split out the subfields for the matching tag and filter for the correct code before formatting the result:

image

Hope this helps! Let me know if you have any questions on this :slight_smile:

1 Like