Delete Column

Tags:  

Delete Column


     
Introduction


The Delete Column API is used to delete a column in Zoho Reports Table. The account Administrator and the Database Owner alone can use this API to delete a column in a  Zoho Reports table.

Getting Started


It is recommended to go through the Zoho Reports API Prerequisites before using Delete Column API.

Request

The following is the sample request URL to delete a column.

https://reportsapi.zoho.com/api/your_account@zoho.com/SalesDB/Sales?ZOHO_ACTION=DELETECOLUMN
&ZOHO_COLUMNNAME=SalesRegion&
&ZOHO_OUTPUT_FORMAT=XML&ZOHO_ERROR_FORMAT=XML
&authtoken=g38sl4j4856guvncrywox8251sssds&ZOHO_API_VERSION=1.0

Note: In case of database owner deleting a column, they need to specify the login E-mail ID of the account Administrator only.

Query String Parameters

The following table shows the list of Query String parameters that has to be passed along with the request URL.

This parameters should be in the same case as given in this document.

Parameter Name Description
ZOHO_ACTION This parameter value should be DELETECOLUMN.
 
ZOHO_COLUMNNAME The name of the column to be deleted in Zoho Reports Table.

Example:
ZOHO_COLUMNNAME=Region

authtoken
The authtoken parameter should hold the Auth Token of the Database Owner Account.

Response

The following sample response will be sent from the server after successfully deleting the column.

XML Format:

<response uri="/api/your_account@zoho.com/SalesDB/Sales" action="DELETECOLUMN">
<result>
Column deleted successfully
</result>
</response>

JSON Format:

{
"response":
{
"uri":"\/api\/your_account@zoho.com\/SalesDB\/Sales",
"action":"DELETECOLUMN",
"result": {"message":"Column deleted successfully"}
}
}

Error Handling


The following is a sample error response format in case of failure of Delete Column API.

XML Format:

<response uri="/api/your_account@zoho.com/SalesDB/Sales" action="DELETECOLUMN">
<error>
<code>7107</code>
<message>
Column Region does not exists
</message>
</error>
</response>

JSON Format:

{
"response":{
"uri":"\/api\/your_account@zoho.com\/SalesDB\/Sales",
"action":"DELETECOLUMN",
"error":{
"code":7107,
"message":"Column Region does not exists"
}
}
}

Error Codes:

The following table shows the list of error codes sent from server on failure of Rename Column API Request along with the reason and the solution for the same.

Error Code Reason Solution
7107 The column does not exists in the specified Zoho Reports Table
Provide the correct name of the column to be deleted in the ZOHO_COLUMNNAME parameter
7159 The column to be deleted is used in Reports, Formula Columns, Query Tables, etc. The column with dependent views cannot be deleted. Please delete the dependent views and formula columns associated with this column before calling this delete column API.
7161 The Zoho Reports Table specified in this API is a system table (created for Service Integration)
Deleting columns in System Table is not allowed. You could only delete a column in a user created/defined table using this API.

In case of any error other than the above said, mail the API request URL parameters and error response details to support@zohoreports.com. Zoho Reports will get back to you with the best possible solution.


    Post a comment

    Your Name or E-mail ID (mandatory)

    Note: Your comment will be published after approval of the owner.




     RSS of this page