Common Parameters in Query String of the API URL
In this section we will discuss about the mandatory and optional parameters that could be passed in the query string of every API call.
Auth Token is an unique token that authenticates the user to access the Zoho Account. It is equivalent to logging into Zoho service(s) from browser. Click here to know how to generate an Auth Token.
This parameter specifies the action to be performed by the API request. The allowed values are:
- ADDROW - To add a row of data into a table.
- IMPORT - To import data in bulk into a table in CSV/TSV/Tabular Text formats
- UPDATE - To update existing rows in a table.
- DELETE - To delete rows in a table.
- EXPORT - To export table or report in different formats.
- To fetch information about the databases and the reports created
within it, in your Zoho Reports account.
Note: Value of ZOHO_ACTION parameter should be in the same case(UPPER CASE) as given in this document.
This parameter specifies the output format for the response. Following are the following supported formats:
Incase ZOHO_ACTION is EXPORT then following additional formats are supported.
Specifies the output format for the response in case an error occurs when trying to process the request. Following are the supported formats:
The API version of Zoho Reports based on which the application(/service) has been written. This parameter allows the Zoho Reports to handle applications based on the older versions.
The current API version is 1.0
These parameters have to be sent in the body of the POST request.
This parameter can be used during Import of data, which has a date column, whose format is not properly identified by Zoho Reports.
View this link for more details about how to construct a custom date format.