The Get Request node only delivers an empty table and empty files, even though the settings seem to be correct.
Hi,
Welcome to the KNIME Forum!
A screenshot or even better, an example workflow, would help us help you in this case. I assume that you get a red question mark in the body column? In that case, you can hover your mouse over the cell and it should give you the reason why this cell is missing. You can also use the Extract Missing Value Cause node to get the info.
Kind regards,
Alex
1 Like
Hi @HGS_mbH , in general to get assistance please provide any information in a form that can be copied/pasted. To help you, it is likely that people will need to try the URL that you are using and if they have to copy it from a screenshot, experience suggest that you are less likely to get help.
If it had not been that I could paste the screenshot into a chatgpt session and ask it to give me back the URL, I probably wouldn’t be replying here either!
So, for anybody else wishing to assist:
The URL extracted from the image is:
https://data-api.ecb.europa.eu/service/data/EXR/D.AUD.EUR.SP00.A?format=jsondata
Have you tried accessing that url from a browser on the same machine that is running KNIME AP? If so, what happens?
Reason for asking is that when I put that URL into the Get Request node, as you have shown, without setting any other request/response headers etc, I get back data as a binary which I can convert to a String and read as json.
e.g.
So… I am going to make a massive leap here…
I think your problem is that you have included one or more spaces at the end of the URL in your Get Request node. It’s easily done, especially if you copy and paste the url, and if I try it, I get the same result as you.
Please let us know if that is the problem 
Yes, tried it and it downloads the full file without any complications.
That’s a good call, but I checked it and unfortunatly there are no spaces behind the URL, would have been too easy 
That is the result I am getting, caused by the missing data:
The Binary to String node is not capable of converting the data because there is no data to begin with.
When I execute the Get Request node I see this:
This is my workflow.
Data from url - forum 85039.knwf (78.8 KB)
I have done nothing special, other than enter the URL in the Get Request, so let me know if it works. Also,what version of KNIME are you using, and on what OS?
Hi!
I have also tried the GET Request node with the URL and I am getting a status code 200 and the binary data just fine. Would you be ok with sharing your full workflow with us so we can check for any misconfiguration? If there is none, I would blame the network. Corporate proxies are pretty often at fault with errors like this.
Kind regards,
Alex
2 Likes
That is my workflow, but for me the same problem occurs with takbb’s workflow too.
Hi,
If that is the case, I would check your network. Do you have a proxy configured in the KNIME preferences, or are you in a corporate network? Can you try running the workflow somewhere else?
Kind regards,
Alex
1 Like
Alexander Bro!
I spend 3 hours midnight with the same issue.
you know what, the response from server comes in 7 seconds, the get request had 2 seconds by default. As I changed it to 20 seconds, I can see all sh@t in the json. I found your messages while browsing internet for the same issue. Hope yours was also solved.
my 3 hours for 7 seconds??? @#{!!
ck:skull_and_crossbones:hec%s:skull_and_crossbones:nb!t¢h
1 Like