Zoho Reports - Data APIs
Zoho Reports provides REST style Web APIs over HTTP. With this API, users/developers can extend their web applications to push or pull data into or from Zoho Reports for powerful analysis and reporting. As the API is purely HTTP based, your application could be in any of the programming languages like Java, Python, ASP etc., to use the same.
Zoho Reports also supports Zoho CloudSQL technology, thus enabling users to use SQL Querying to interact with the service. Zoho Reports also offers JDBC drivers to connect to it and execute the SQL queries. This also means that, developers need not learn the specific HTTP Web APIs to extend/develop over Zoho Reports. They just have know how to use the Zoho Reports JDBC driver and start interacting with the Service, the same way as they would interact with a on-premise database using any standard JDBC or ODBC drivers.
To show case the API usage, a sample Personal Finance application has been built over Googe AppEngine in Python. The data collected from the application gets stored in Zoho Reports using the Zoho Reports API. Reports created on the data collected are embedded back into the application interface to create cool dashboards to track income and expenses details. We also use SQL querying over CloudSQL to fetch data for Zoho Reports and display the same within the application interface. Read the tutorial to know how the Expense Tracker application has been built.
Important Links:
