Client Libraries
To enable developers to easily use the Zoho Reports CloudSQL HTTP API, we have provided Client libraries in the below given programming languages.
More client libraries in other programming languages will be added very soon.
Java Client Library
Java client library wraps the HTTP API of Zoho Reports with the easy to use methods in Java language. This could be used if you do not want to use the Zoho Reports JDBC Driver.
Sample code snippet for using CloudSQL with Java client API:
ReportClient rc = Config.getReportClient();
rc.login(Config.LOGINNAME,Config.PASSWORD);
String uri = rc.getURI(Config.LOGINNAME,Config.DATABASENAME);
String sql = "select \"Customer Name \",Sales,Cost, \"Profit (Sales) \" from Sales where Region = 'East'";
rc.exportDataUsingSQL(uri,"CSV",new File("Test.csv"),sql,null);
For more details on Java client libraries, view this link
Samples
The sample code for Zoho Reports CloudSQL using Java Client library is available in this link
Python Client Library
Pytho Client Library wraps the HTTP API of Zoho Reports with the easy to use methods in Phython language.
Sample code snippet for using CloudSQL with Python client API:
ReportClient rc = ReportClient(Config.APIKEY)
rc.login(Config.LOGINNAME,Config.PASSWORD)
uri = rc.getDBURI(Config.LOGINNAME,Config.DATABASENAME)
sql = "select Region from StoreSales"
rc.exportDataUsingSQL(uri,"CSV",sys.stdout,sql,None)
For more details on Python client libraries, kindly view this link
Samples:
The Sample.py is bundled along with python client library which can be downloaded from the link
Next: Supported SQL in Zoho Reports
