Dealing with an csv-ish API response - help please! :)

[alaegs]

Hi All

I’m relatively new with Knime and found great help so far by listening and reading all the helpful replies to all kinds of subjects. I now find my self in a situation where I can’t seem to find a thread that touch base on exactly my issue - so any help would be greatly appreciated.

I’m calling an API via the GET request, but there is unfortunately a restriction in the API that only allow the response to appear in an CSV-ish kind of format. I have attached a workflow with my output.

I now really want to extract my data and end up with the following:

Column1 Column2 Column3
KW Metric 1 Metric 2
KW Metric 1 Metric 2

All the best
Alex

KNIME_project2.knar.knwf (8.0 KB)

[amartin]

Hi @alaegs,

The solution for your problem is a bit complex:

Please find attached the workflow.

ParseGetResults.knar.knwf (25.4 KB)

[alaegs]

Thank you very much for your response! It does make a lot of sense - really appreaciate it.

When I try to execute the workflow, I get the following error in the loop end node.

What am I doing wrong?

[amartin]

Hi @alaegs,

I’ve corrected the workflow:

Best,
Anna

ParseGetResults.knar.knwf (25.4 KB)

[alaegs]

Hi @amartin

Thank you so much! However, when I download the workflow, it appears to be the same you posted earlier on. Can you try to upload again?

All the best
Alex

[alaegs]

Ah, I fixed it according to your screenshot. Again thank you very much. Extremely helpful!

[amartin]

Hi @alaegs,

Oh, I am sorry. Hopefully the last try

ParseGetResults.knar.knwf (25.1 KB)

[alaegs]

Thanks! Works like a charm!