Get a Row with a 1-Column Key
/mobile/platform/database/objects/{table}/{id}
Retrieves the row specified by the one-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. -
table: string
The name of the database table.
Response
- application/json
200 Response
object
Row Items
-
items(optional):
array Table Data
Title:
Table Data
Minimum Number of Items:1
Unique Items Required:true
array
Table Data
1
true
-
Array of:
object Columns
Title:
Columns
Additional Properties Allowed: additionalPropertiesColumn names and values. For example `{ "title" : "The Imitation Game"}`. String values can't exceed 4000 characters. Binary types aren't supported.
object
Columns
{
"items":[
{
"title":"The Imitation Game"
}
]
}