Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
java client for cartodb SQL API
Java Groovy
branch: master

Merge pull request #6 from grisaf/master

Add gradle to install in local maven.
latest commit 7fca7084d1
@javisantana javisantana authored
Failed to load latest commit information.
build
lib added api key
src/com/cartodb
test/com/cartodb
.gitignore
LICENSE added LICENSE
README.md updated readme
build.gradle Add gradle to install in local maven.
build.xml Add zipfileset to build.xml so that all deps are included in JAR.

README.md

CartoDB Java Client

Description

Tiny CartoDB Java client that can be instantiated as regular (public) or secured (private). Once instantiated, you can send queries to CartoDB and get a JSON string as response.

Usage

With this library you have access to private and public tables. In order to access to public tables you do not need to be authenticated but if you want to read or write data to a private table or write data to a public table you need to.

CartoDB provides two ways to auth, oauth or api key, please read CartoDB Authentication documentation for detailed info on this topic.

Using oAuth

//Access to your private table or update your table
CartoDBClientIF cartoDBCLient= new SecuredCartoDBClient("youraccount","yourpassword","consumerKey","consumerSecret");
System.out.println(cartoDBCLient.executeQuery("UPDATE yourtable SET yourvalue = 'test' WHERE yourid = 1"));

Using API key

//Access to your private table or update your table using the api key
CartoDBClientIF cartoDBCLient= new ApiKeyCartoDBClient("youraccount", YOUR_API_KEY);
System.out.println(cartoDBCLient.executeQuery("UPDATE yourtable SET yourvalue = 'test' WHERE yourid = 1"));

Access to Public tables (no auth required)

//Access to your public table
CartoDBClientIF cartoDBCLient= new CartoDBClient("youraccount");
System.out.println(cartoDBCLient.executeQuery("SELECT * FROM yourtable LIMIT 1"));

get results as java object

executeQuery method returns the raw json response. If you want to retrieve the json already parsed into a java object you can use request method, see next example:

// get rows as a Map
CartoDBResponse<Map<String, Object>> res = cartoDBCLient.request("select * from mytable limit 1");
System.out.print(res.getTotal_rows(), 1);
System.out.print(res.getRows().get(0).get("cartodb_id"));

Dependencies

Included in lib folder

TODO

  • Include error JSON on HTTP response 400.

License

read LICENSE file

Something went wrong with that request. Please try again.