restSQL: SQL Resource DELETE Path

Method	DELETE
Path	/res/{resName}/{resId}
Query Params	None
Request body	None
Response body	Number of rows deleted.	Response.xsd	Content-Type: application/xml or application/json

Description

Deletes one of the following:

one row of a flat SQL Resource
parents and children of a one-to-many hierarchial SQL Resource
parents and associations to children of a many-to-many hierarchical SQL Resource

A flat SQL Resource:

DELETE /restsql/res/Actor/123 HTTP/1.1
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml

<writeResponse rowsAffected="1" />

A delete to parents and children of a one-to-many hierarchical SQL Resource:

DELETE /restsql/res/LanguageFilm/3 HTTP/1.1
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml

<writeResponse rowsAffected="13" />

A delete to parents of a many-to-many hierarchical SQL Resource (parent rows are deleted, and child rows are disassociated):

DELETE /restsql/res/ActorFilm/123 HTTP/1.1
Accept: application/xml

HTTP/1.1 200 OK
Content-Type: application/xml

<writeResponse rowsAffected="9" />

A flat SQL Resource:

DELETE /restsql/res/Actor/123 HTTP/1.1
Accept: application/json

HTTP/1.1 200 OK
Content-Type: application/json

{ "rowsAffected": 1 }

A delete to parents and children of a one-to-many hierarchical SQL Resource:

DELETE /restsql/res/LanguageFilm/3 HTTP/1.1
Accept: application/json

HTTP/1.1 200 OK
Content-Type: application/json

{ "rowsAffected": 13 }

A delete to parents of a many-to-many hierarchical SQL Resource (parent rows are deleted, and child rows are disassociated):

DELETE /restsql/res/ActorFilm/123 HTTP/1.1
Accept: application/json

HTTP/1.1 200 OK
Content-Type: application/json

{ "rowsAffected": 9 }