Reports Help

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.

Mandatory Parameters:

Ticket

Ticket is a session specific ID that is to be generated and passed along with every API call. To generate the ticket id, users have to send the authentication details (user name and password) to SkyDesk Accounts. It is equivalent to logging into SkyDesk service(s) from browser. Click Here for steps for getting the ticket id.

The received ticket id has to be passed along in every API request.

Note:

  • The service name to be passed as parameter to SkyDesk Accounts for generating the Ticked ID is  "SkyDeskReports"
  • Ticket Id is a temporary id and have to be invalidated after every "session".

ZOHO_ACTION

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. 
  • DATABASEMETADATA - To fetch information about the workspaces and the reports created within it, in your SkyDesk Reports account.

Note

  • Value of ZOHO_ACTION parameter should be in the same case(UPPER CASE) as given in this document.

ZOHO_OUTPUT_FORMAT

This parameter specifies the output format for the response. Following are the following supported formats:

  • XML
  • JSON

Incase ZOHO_ACTION is EXPORT then following additional formats are supported

  • CSV
  • PDF
  • HTML
  • IMAGE

ZOHO_ERROR_FORMAT

Specifies the output format for the response in case an error occurs when trying to process the request. Following are the supported formats:

  • XML
  • JSON

ZOHO_API_KEY

As mentioned in Prerequisites you need to get an API key to use the SkyDesk Reports API. Click Here  for steps for getting the API key. This parameter should be passed with the API key that you would have got from SkyDesk.

ZOHO_API_VERSION

The API version of SkyDesk Reports based on which the application(/service) has been written. This parameter allows the SkyDesk Reports to handle applications based on the older versions.

The current API version is 1.0

Optional Parameters:

These parameters have to be sent in the body of the POST request.

ZOHO_DATE_FORMAT

This parameter can be used during Import of data, which has a date column, whose format is not properly identified by SkyDesk Reports.

Example:

ZOHO_DATE_FORMAT=dd-MMM-yyyy

View this link for more details about how to construct a custom date format.

Top