Jump to

• Request
• Response

Get a Row with a 4-Column Key

get

/mobile/platform/database/objects/{table}/{id}/{id2}/{id3}/{id4}

Retrieves the row specified by the four-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

Path Parameters

• 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 either GET /mobile/system/databaseManagement/tables or GET /mobile/system/databaseManagement/tables/{table}, the primaryKeys 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.
• id4: string
  If the primary key is composed of more than one column, then this is the fourth column in the key.
• table: string
  The name of the database table.

Back to Top

Response

Supported Media Types

• application/json

200 Response

Body ()

Root Schema : Row Items

Type: object

Title: Row Items

Show Source

• items(optional): array Table Data
  Title: Table Data

  Minimum Number of Items: 1

  Unique Items Required: true

{
    "title":"Row Items",
    "properties":{
        "items":{
            "$ref":"#/definitions/tableData"
        }
    },
    "type":"object"
}

Nested Schema : Table Data

Type: array

Title: Table Data

Minimum Number of Items: 1

Unique Items Required: true

Show Source

• Array of: object Columns
  Title: Columns

  Additional Properties Allowed: additionalProperties

  Column names and values. For example `{ "title" : "The Imitation Game"}`. String values can't exceed 4000 characters. Binary types aren't supported.

{
    "title":"Table Data",
    "items":{
        "$ref":"#/definitions/rowData"
    },
    "minItems":1,
    "uniqueItems":true,
    "type":"array"
}

Nested Schema : Columns

Type: object

Title: Columns

Additional Properties Allowed

Show Source

• string

{
    "title":"Columns",
    "description":"Column names and values. For example `{ \"title\" : \"The Imitation Game\"}`. String values can't exceed 4000 characters. Binary types aren't supported.",
    "additionalProperties":{
        "type":"string"
    },
    "type":"object"
}

Column names and values. For example `{ "title" : "The Imitation Game"}`. String values can't exceed 4000 characters. Binary types aren't supported.

Example Response (application/json)

{
    "items":[
        {
            "title":"The Imitation Game"
        }
    ]
}

Back to Top