Delete a Row with a 3-Column Key
/mobile/platform/database/objects/{table}/{id}/{id2}/{id3}
Deletes the row identified by the three-column primary key.
For security reasons, you can call this operation only from custom API implementations by using the custom code SDK. You can't make direct requests from client applications. This API is included in this reference merely to describe the request and response bodies for the custom code SDK calls.
Request
-
id: string
The primary key of the table.
If the primary key is composed of more than one column, then each column in the primary key must be provided in sequence, and the sequence must match the order of the columns in the
Oracle-Mobile-Primary-Keys
header when the table was implicitly or explicitly created. For example, if the primary key is the title and the year, then the URI might be/mobile/system/database/Movies/Annie/2014
. Note that when you use the Database Access operations to work with the table data, you'll need to know the order of the primary keys that you used when you created (or re-created) the table. However, when you call eitherGET /mobile/system/databaseManagement/tables
orGET /mobile/system/databaseManagement/tables/{table}
, theprimaryKeys
property lists the columns in alphabetical order, and not in the order that you used when you created or re-created the table. Therefore, you must make a note of the order when you create or re-create a table. -
id2: string
If the primary key is composed of more than one column, then this is the second column in the key.
-
id3: string
If the primary key is composed of more than one column, then this is the third column in the key.
-
table: string
The name of the database table.
Response
- application/json
200 Response
The structure of the response JSON object depends on if the table has a primary key:
Example when the table has a primary key:
{ "rowCount" : 2 }
Example when the row key is the id
column:{"items":[{"id":42},{"id":43}]}
object
Add, Update, or Delete Response
-
object Row Count
Title:
Row Count
-
object Added, Updated, or Deleted Items
Title:
Added, Updated, or Deleted Items
IDs for the rows that were added, updated, or deleted.
object
Row Count
-
rowCount:
integer
Number of rows added, updated, or deleted
object
Added, Updated, or Deleted Items
-
items:
array Row Data
Title:
Row Data
Minimum Number of Items:0
Unique Items Required:true
array
Row Data
0
true
-
Array of:
object ID
Title:
ID
object
ID
-
id(optional):
integer
Value of the `id` column.