Problem deleting rows with Rest API
I am posting a request to the REST API to delete a record and I receive a Internal 500 server error as follows:
HTTP/1.1 500 Internal Server Error
Date: Mon, 02 Jun 2008 18:28:41 GMT
Server: Apache
Cache-Control: max-age=10
Expires: Mon, 02 Jun 2008 18:28:51 GMT
Vary: Accept-Encoding,User-Agent
Connection: close
Transfer-Encoding: chunked
Content-Type: text/html
1f9
<!-- $Id: errorinfo.jsp,v 1.4 2006/11/16 10:49:08 muthumariappan Exp $ -->
<html>
<head>
<style>
body {
font-size: 14px;
font-family: "Verfana";
}
div {
margin-top:150px;
vertical-align: middle;
text-align: center;
}
</style>
</head>
<body>
<div>
An error has occured. It has been reported to Zoho Creator support. We will look into this issue .<br> Sorry for the inconvenience caused.<p><p>
Go to <a href='/'>Zoho Creator Home</a>
</div>
</body>
</html>
I am trying to delete the row by its id. The post data looks like:
criteria=id=180656000000006003&submit=Delete Record
First question. Does the post data have to be URL encoded?
Second, the documentation of the API is confusing. I can't tell if the criteria variable is supposed to "criteria" or "Criteria".
Third, I'm assuming that the name of the row id variable is "id" because when I look at http://creator.zoho.com/api/reference, it does not list the row ID column. Please let me know if this is incorrect.
The URL I am posting to is:
http://creator.zoho.com/api/xml/dcfoodies-event-submission/Event_Submission/delete/apikey=12345&ticket=12345
I know the documentation says to include the application owner name, but when I specify that, I receive a 404 error. When I remove that, I receive the 500 error.