SQL Resource PUT Query URL Encoded

Method PUT
Path /res/{resName}?{name}={value}
Query Params Zero or more name-value pairs. Use column labels, not names, as defined in the SQL Resource query.

Value encoding:
  • Use equals or not equals value. See Equals/Not Equals Operators for more detail.
  • Include '%' anywhere in the value for the wildcard, which is URL encoded as %25. This will use the a SQL LIKE instead of equals operator. See Like Operator for more detail.
  • Use null or not null. See Null/Not Null Operators for more detail.
  • Surround a commad-separated list in parenthesis. See In Operator for more detail.
  • Prefix one of four url encoded comparison operators at the beginning of the value. See Comparison Operators for more detail.
Request body Attribute values for update on rows matching query params. See Null/Not Null Operators for more info on null values. Content-Type: application/x-www-form-urlencoded
Response body Number of rows updated Response.xsd Content-Type: application/xml or application/json

Description

Updates one or more rows for matching query parameters.

XML Example

PUT /restsql/res/Film?title=DARK%25 HTTP/1.1
Content-Type: application/x-www-form-urlencoded
Accept: application/xml

rating=R&rental_duration=2

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

<writeResponse rowsAffected="3" />

JSON Example

PUT /restsql/res/Film?title=DARK%25 HTTP/1.1
Content-Type: application/x-www-form-urlencoded
Accept: application/json

rating=R&rental_duration=2

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

{ "rowsAffected": 3 }