Prerequisites for using the API
Users have to fullfill the below given prerequisites to use Zoho Reports API
Zoho ID
Users should have a valid Zoho login id to use the API.
API key
In order to use the API, each third party application(/service) need to obtain an API key. We use the API key to track usage from the various applications(/services). The API key has to be passed as parameter in every API request made.
Click here for registering for API Key
Once we receive the request, we will send the API Key to the Email ID that the user has specified during the registration process. Please do not distribute or use the key for creating multiple applications/services. You should request for an API key for each of your individual application(/service) that you plan to create. Any violations will result in the cancellation of the API Key.
Note: Getting the API Key is a one time process.
Database
To use the API, users should have already created atleast a reporting database with tables and reports in the Zoho Reports service using the browser based web client provided. You cannot use the API, if there are no Databases available in your user account in Zoho Reports
How can I Get Zoho DB %26 Reports Ticket
https://accounts.zoho.com/login?servicename=???FROM_AGENT=true%26LOGIN_ID=zzeeshann@gmail.com%26PASSWORD=asdasd
Hi zzeeshann,
The service name to be passed as parameter to Zoho Accounts for generating the Ticked ID is "ZohoReports".
For example:
https://accounts.zoho.com/login?servicename=ZohoReports%26FROM_AGENT=true%26
LOGIN_ID=[Zoho ID/Email ID]%26PASSWORD=[Password]
--Manohar Nixon
I have a zoho Account & API key.
I also have a Zoho DB & Zoho Creator application.
IS it possible for me to sumbit data into report via my zcreator form.
Please advice.
Regards
Deepa Govind
Hi Deepa,
Yes you can create forms in Zoho Creator that adds records to Zoho Reports. We have created a sample application as per you requirement, refer this http://creator.zoho.com/dummyaccount/zohodb/#.
To know about scripting you can copy this application to your account by following steps:
* Go to the Live Mode of the application and select 'More Action' menu in the top right corner.
* And click 'Copy Application' from the drop down.
We believe that the above will help you.
Thanks,
Saminathan,
Zoho Reports.
Hi,
Thank you very much for the guidance.
But it seems that my form is able to add only single record to the table
The field types in ZC & Report are single line field
The data is getting added to my creator view, but not at the table
I have placed the copy of code here,
http://export.writer.zoho.com/public/deepa7476/ZC-Reports_API2
Please help
Regards
Deepa
Hi Deepa,
Kindly make sure the following are proper in your script:
1. Same user name should be used to fetch the ticket(using accounts.zoho.com URL) as used in the ADDROW API URL(i.e Deepa7476)
2. Kindly make sure the table name and database name are same as that displayed in the Zoho Reports login.
You can also send your queries to support@zohoreports.com
Thanks for your time.
Regards,
Saminathan,
Zoho Reports.
Thank you,
i have mailed the support team
Regards
Deepa
Is there some way to get a list of databases and / or table names for a given database? If not... do you plan on providing that in the future? If so... when?
@ cmodien,
Hi,
We are working on this and soon we will provide you the API to get database metadata information. We shall keep you posted.
Thanks,
Kovil Pillai.