iamtrask / quandl-java Goto Github PK

I download quandl-java and run Examples.java in Eclipse, and in the
constructor of QuandlConnection I use my own key accquired from
Quandl. There are the following errors, and I don't know how to fix
them.Could you help me? Thanks!

Executing Request:
http://www.quandl.com/api/v1/current_user/collections/datasets/favourites.json?auth_token=GYpZ4fRqqtmUFs6CSx3Y
log4j:WARN No appenders could be found for logger
(org.apache.http.impl.conn.SingleClientConnManager).
log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig
for more info.
java.net.UnknownHostException: www.quandl.com
at java.net.Inet6AddressImpl.lookupAllHostAddr(Native Method)
at java.net.InetAddress$1.lookupAllHostAddr(InetAddress.java:867)
at java.net.InetAddress.getAddressesFromNameService(InetAddress.java:1241)
at java.net.InetAddress.getAllByName0(InetAddress.java:1195)
at java.net.InetAddress.getAllByName0(InetAddress.java:1170)
at java.net.InetAddress.getAllByName(InetAddress.java:1117)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:126)
at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)
at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:108)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:641)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:731)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:709)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:700)
at main.java.com.quandl.api.java.QuandlConnection.curl(QuandlConnection.java:111)
at main.java.com.quandl.api.java.QuandlConnection.connectedWithGoodToken(QuandlConnection.java:83)
at main.java.com.quandl.api.java.QuandlConnection.(QuandlConnection.java:24)
at com.quandl.api.java.Examples.main(Examples.java:14)
No token... you are connected through the public api and will be rate
limited accordingly.
Executing Request:
http://www.quandl.com/api/v1/datasets/PRAGUESE/PX.json?auth_token=GYpZ4fRqqtmUFs6CSx3Y
java.net.UnknownHostException: www.quandl.com
at java.net.InetAddress.getAllByName0(InetAddress.java:1199)
at java.net.InetAddress.getAllByName0(InetAddress.java:1170)
at java.net.InetAddress.getAllByName(InetAddress.java:1117)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:126)
at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)
at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:108)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:641)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:731)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:709)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:700)
at main.java.com.quandl.api.java.QuandlConnection.curl(QuandlConnection.java:111)
at main.java.com.quandl.api.java.QuandlConnection.getDataset(QuandlConnection.java:37)
at com.quandl.api.java.Examples.main(Examples.java:20)
Executing Request:
http://www.quandl.com/api/v1/datasets/PRAGUESE/PX.json?trim_start=2012-01-01&trim_end=2012-11-26&auth_token=GYpZ4fRqqtmUFs6CSx3Y
Unexpected character (w) at position 0.
at org.json.simple.parser.Yylex.yylex(Unknown Source)
at org.json.simple.parser.JSONParser.nextToken(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at main.java.com.quandl.api.java.QDataset.(QDataset.java:42)
at main.java.com.quandl.api.java.QuandlConnection.getDataset(QuandlConnection.java:37)
at com.quandl.api.java.Examples.main(Examples.java:20)
java.net.UnknownHostException: www.quandl.com
at java.net.InetAddress.getAllByName0(InetAddress.java:1199)
at java.net.InetAddress.getAllByName0(InetAddress.java:1170)
at java.net.InetAddress.getAllByName(InetAddress.java:1117)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:126)
at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)
at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:108)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:641)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:731)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:709)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:700)
at main.java.com.quandl.api.java.QuandlConnection.curl(QuandlConnection.java:111)
at main.java.com.quandl.api.java.QuandlConnection.getDatasetBetweenDates(QuandlConnection.java:47)
at com.quandl.api.java.Examples.main(Examples.java:23)
Unexpected character (w) at position 0.
at org.json.simple.parser.Yylex.yylex(Unknown Source)
at org.json.simple.parser.JSONParser.nextToken(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at main.java.com.quandl.api.java.QDataset.(QDataset.java:42)
at main.java.com.quandl.api.java.QuandlConnection.getDatasetBetweenDates(QuandlConnection.java:47)
at com.quandl.api.java.Examples.main(Examples.java:23)
Executing Request:
http://www.quandl.com/api/v1/datasets/PRAGUESE/PX.json??trim_start=2012-09-30&auth_token=GYpZ4fRqqtmUFs6CSx3
java.net.UnknownHostException: www.quandl.com
at java.net.InetAddress.getAllByName0(InetAddress.java:1199)
at java.net.InetAddress.getAllByName0(InetAddress.java:1170)
at java.net.InetAddress.getAllByName(InetAddress.java:1117)
at org.apache.http.impl.conn.DefaultClientConnectionOperator.openConnection(DefaultClientConnectionOperator.java:126)
at org.apache.http.impl.conn.AbstractPoolEntry.open(AbstractPoolEntry.java:149)
at org.apache.http.impl.conn.AbstractPooledConnAdapter.open(AbstractPooledConnAdapter.java:108)
at org.apache.http.impl.client.DefaultRequestDirector.execute(DefaultRequestDirector.java:415)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:641)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:731)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:709)
at org.apache.http.impl.client.AbstractHttpClient.execute(AbstractHttpClient.java:700)
at main.java.com.quandl.api.java.QuandlConnection.curl(QuandlConnection.java:111)
at main.java.com.quandl.api.java.QuandlConnection.getDatasetWithParams(QuandlConnection.java:69)
at com.quandl.api.java.Examples.main(Examples.java:30)
Unexpected character (w) at position 0.
at org.json.simple.parser.Yylex.yylex(Unknown Source)
at org.json.simple.parser.JSONParser.nextToken(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at org.json.simple.parser.JSONParser.parse(Unknown Source)
at main.java.com.quandl.api.java.QDataset.(QDataset.java:42)
at main.java.com.quandl.api.java.QuandlConnection.getDatasetWithParams(QuandlConnection.java:69)
at com.quandl.api.java.Examples.main(Examples.java:30)
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index:
0, Size: 0
at java.util.ArrayList.rangeCheck(ArrayList.java:604)
at java.util.ArrayList.get(ArrayList.java:382)
at main.java.com.quandl.api.java.QDataset.getStringMatrix(QDataset.java:164)
at com.quandl.api.java.Examples.main(Examples.java:36)

I noticed you are verifying auth_token with obtaining favourites datasets.
Problem occurs when user has no favourite dataset saved and result is 404.
Api works but user will get ugly exception which is very confusing.
Can't be auth_token verified in any other way?
I also noticed other APIs do not verify token. Is it necessary to verify it?
Maybe just to mention that on info page user has to select at least one favourite dataset...

There is no search functionality in the code given. Will this be implemented soon?

www.quandl.com/api/v1/datasets.json?query=

The following use of the getDatasetWithParams(params) method gave me an org.apache.http.client.HttpResponseException

QuandlConnection q = new QuandlConnection("mytoken")

HashMap<String, String> params = new HashMap<String, String>(); params.put("trim_start","2012-09-30"); params.put("code","GDP"); params.put("source_code","FRED"); QDataset data3 = q.getDatasetWithParams(params);

It is because the getDataSetWithParams(prams) method is truncating the last character in the auth_token. Here is the output for the getDataSetWithParams(params) method: Executing request: http://www.quandl.com/api/v1/datasets/FRED/GDP.json?trim_start=2012-09-30&auth_token=mytoke

A fix for this is to change the return statement in the getDataSetWithParams(prams) method in QuandlConnection class to the following:
return new QDataset(curl(baseUrl + params.get("source_code") + "/" + params.get("code") + ".json" + paramString.substring(0, paramString.length() - 1)), "json");
More specifcially, changing the paramString.substring(0, paramString.length() - 2)
to paramString.substring(0, paramString.length() - 1)

Note: Keep in mind that this error doesn't show up until you exhaust your daily quota of 50 free queries.

using method in QuandlConnection class
getDatasetWithParams(HashMap<String, String> params)
will produce Request like

http://www.quandl.com/api/v1/datasets/OFDP/FUTURE_SMZ2005.json??rows=4&auth_token=myToken

notice two question marks in the request. it causes to ignore first parameter and query will return all rows.