json or xml parsing problem? help for editing

[umutcankurt]

Hi guys;
The problem with the workflow in the appendix is that I want to parse the json from the source, but I have tried it in json or xml. I’m doing something nice (I’m a novice) if you can help.

ThanksKNIME_Italy__project(2).knwf (30.8 KB)

[umutcankurt]

[mlauber71]

I tried a few things with your example but was not really able to extract any meaningful information. Maybe you would care to elaborate what it is you want to extract, how the final data would look like.

The file seems to be Json but the structure is not clear. Without that it is hard to find a suitable path to a solution.

You could have a look at this threads for inspiration

Problems with parsing a XML-like file

Hello I’m trying to parse a XML-like file test.xml (795.2 KB). What I need is all the tableRowValues that are in the “attachment” tag where the attribute name=“TICs”, e.g. 0.06304059198 118759464 0.444749184 134730432 0.821746656 126575480 1.19846315202 119222952 1.579326144 116276016 1.95593856 119685872 2.33203868802 115389088 2.70814657602 119230392 3.083884113 118585048 3.464118048 124508512 I’ve tried with “XML reader” and “XPath” nodes but without success. Any idea? Thank you! …

combine multiple xml files / How to do knime

I think you have some serious work to do on your Path definitions. They do not seem to work for some of the xml files and I think most of them that you had in your example are not going to work. I defined some of them but not all since I do not know what information you are interested in. [image] [image] kn_example_xml_loop.knar (681.0 KB)

[umutcankurt]

Hi; @mlauber71
The information I want to remove is yellow in the image and url link.
The source url address and the json url address are as follows. I don’t understand what’s weird. I would appreciate it if you check again.
Thanks

Ricerca Avanzata Bandi-Avvisi-Concorsi Regione del Veneto

https://bandi.regione.veneto.it/Public/GetListaAttiJson?parolaChiave=&tipoAttoTmp=&destinatariTmp=&struttureTmp=0&categorieTmp=&statoTmp=&materieTmp=&paginaIniziale=Ricerca&sEcho=2&iColumns=1&sColumns=&iDisplayStart=10&iDisplayLength=10&mDataProp_0=0&_=1545597126466

[umutcankurt]

I would like to learn if there is a better method of solution for your suggestion. it is not necessary to take data in this way, I am open to other methods.

[mlauber71]

I still tried a few things but in the end it seems there is no ‘real’ html page coming back just some database connection and Palladian seems not be able to retrieve it in a structured way

Like @qqilihq has mentioned here since you seem to have quite some html parsing questions/tasks it might be worth trying to use the suggested Selenium nodes.

Current Sample Request / HttpRetriever use on cookie-required websites

Hi there, to avoid confusions: the Palladian nodes are free (for use in free KNIME versions) the Selenium nodes are paid In case you’re wondering whether the Selenium Nodes are the right tool for your task, I invite you to give the free 30-day trial a go. From my experience: I’ve used the Selenium Nodes several times to crawl high amounts of pages. Of course, there is a larger performance overhead compared to a pure “download page” approach like with Palladian, but you can often optimize/p…

[umutcankurt]

Hello there;
In my opinion, JavaScript or dynamic web pages (to scan, collect data from the subjects) because the features should be developed httpretriever and parse remains as a solution.

I think Palladian nodes should be able to work efficiently on pages containing JavaScript. At least work in a non-exclusive general practice