Hello Community!
I read a json output from an internal http Adress. For the Request I must specify some parameters like
http://…index.php?key=XYZ&format=json
With the new JSON Reader I get an error, that the specific file ‘…/index.php’ does not exists. Calling index.php without the parameter will result in a http error 500 internal server error. The JSON Reader Node does not execute and shows the error "Execute failed. The specified file /…index.php does not exists. I asume this error is because of the http-500 error if I call index.php without parameters. Is there a work around?
Hello @ipazin ,
yes, in v4.3 everything worked as expected. I entered the URL as String and did receive the JSON Data.
This is my current work around, leaving the JSON Reader (depreciated) untouched.
thanks
Matthias
I did not mention this, because this works fine. I use a node to make a path variable out of the string variable and forward it to the JSON node.
Thanks for your time & effort
Matthias
did you select Custom/KNIME URL when creating path flow variable from string flow variable? I assume you are using String to Path (Variable) node. If not which one are you using?
As you see, I am using (as you asumed) String to Path (Variable) node. You also see, the old JSON Reader is working, the new claimes, that the index.php file des not exist.
best regards
Matthias
tnx. Seems everything is configured properly. One more thing to clarify. If you are not using flow variable in new JSON Reader node are you getting same error or it works as expected?
Hy @ipazin !
If I paste the flow variable directly in the browser, I get a JSON result (So it is working). If I past the same string as text - instead of a flow variable - it results in the same error. So this is not a issue of using the flow variable.
thanks in advanced
Matthias
tnx for confirmation. Have opened up a ticket (Internal reference: AP-17329) for someone to take a deeper look at it. Upon news someone will update this topic.
Although you have a workaround by using deprecated JSON Reader another option might be GET Request node.
We are trying to reproduce the issue and it seems like something specific that happens with the URL that you are trying to read from.
Could you please run this command in your terminal with the actual URL and let us know the output?
Hello @Moditha!
Here we go. I did 2 get requests. One with the parameter and one up to index.php.
For security reason I had to remove names, IP-Adr, and some of the parameters.
In the first request I get the JSON result set (which I truncated)
One thing I just found: I did a curl without surrounding "
e.g. curl - v http://XXX.YYY.ZZZ.at&user=ABC&apikey …
→ the curl command truncted the call at the first & which resulted in the same 500 error, as without parameters.
Maybe this helps
best regards
Matthias
Hello @Moditha !
Did you find out something about the failing request of the new JSON Reader?
The old one is deprecated, the new one is still not working in KNIME 4.5
thanks for a reply!
Matthias