SQL Resource PUT XML or JSON

Method PUT
Path /res/{resName}
Query Params None
Request body One or more rows to update. Request.xsd Content-Type: application/xml or application/json
Response body Number of rows updated. Response.xsd Content-Type: application/xml or application/json

Description

Updates one or more rows of a flat SQL Resource or the parents or the children of a hierarchial SQL Resource. Updates to both parent and children in the same request for the same parent are disallowed, even if non-pk parent attributes are provided.

XML Examples

A flat SQL Resource:
PUT /restsql/res/Actor HTTP/1.1
Content-Type: application/xml
Accept: application/xml

<request>
   <actor actor_id="123" first_name="JULIANNER "/>
   <actor actor_id="124" last_name="BENINGS" />
   <actor actor_id="125" last_name="NOLTER" />
</request>

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

<writeResponse rowsAffected="3" />

An update to parents of a hierarchical SQL Resource would look identical to the proceeding.

An update to children of one parent and another parent for a hierarchical SQL Resource:
PUT /restsql/res/ActorFilm HTTP/1.1
Content-Type: application/xml
Accept: application/xml

<request>
   <actor actor_id="123">
      <film year="2007" title="ADAPTATION HOLES 2" film_id="3" />
      <film year="2006" film_id="43" />
      <title="BERETS AGENT" film_id="67" />
   </actor>
   <actor actor_id="124" last_name="BENINGS" />
</request>

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

<writeResponse rowsAffected="4" />

JSON Examples

A flat SQL Resource:
PUT /restsql/res/Actor HTTP/1.1
Content-Type: application/json
Accept: application/json

{ "actors": [
      { "actor_id": 123, "first_name": "JULIANNER" },
      { "actor_id": 124, "first_name": "BENINGS" },
      { "actor_id": 125, "first_name": "NOLTER" }
   ]
}

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

{ "rowsAffected": 3 }

An update to parents of a hierarchical SQL Resource would look identical to the proceeding.

An update to children of one parent and another parent for a hierarchical SQL Resource:
PUT /restsql/res/ActorFilm HTTP/1.1
Content-Type: application/json
Accept: application/json

{ "actors": [
      { "actor_id": 123,
         "films": [
            { "film_id": 3, "year": 2007, "title": "ADAPTATION HOLES 2" },
            { "film_id": 43, "year": 2006 },
            { "film_id": 67, "title": "BETETS AGENT" }
         ]
      },
      { "actor_id": 124, "last_name": "BENINGS" }
   ]
}

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

{ "rowsAffected": 4 }