Get List of Data Table Columns
get
/rest/v16/datatables/{tableName}/fields
This endpoint returns all data table column properties for the specified data table.
Request
Path Parameters
-
tableName(required): string
The data table name.
Query Parameters
-
orderby: string
The column to sort by
Response
Default Response
Column details
Root Schema : dataTableField-collection
Type:
Show Source
object
-
items:
array Columns list
Title:
Columns list
List of columns
Nested Schema : Columns list
Type:
array
Title:
Columns list
List of columns
Show Source
-
Array of:
object dataTableField
Data table column model
Nested Schema : dataTableField
Type:
object
Data table column model
Show Source
-
_proxy_id:
string
Title:
Proxy Id
Proxy Id -
dateAdded:
string
Title:
Date Created
The date the column was created. -
dateModified:
string
Title:
Date Last Modified
The date of the last column modification. -
description:
string
Title:
Column Description
The column description. -
id:
integer(int64)
Title:
Column Id
The unique identifier of the column. -
index:
boolean
Title:
Index
This attribute identifies if the column is indexed. -
key:
boolean
Title:
Key
This attribute identifies if this is a key column. A key, also known as a 'Natural Key' can be a single column or a combination of several columns that produce a unique identifier for each record (row) for faster access to the data. -
links:
array Links
Title:
Links
Links to the related objects -
name:
string
Title:
Column Name
The name of the data table column. -
order:
integer
Title:
Column Display Order
Order of the column within the table. -
relationship:
object relationship-response
-
type:
string
Title:
Column Data Type
The data type of the column. -
validation:
object validation-response
Nested Schema : Links
Type:
array
Title:
Links
Links to the related objects
Show Source
-
Array of:
object Reference Links
Title:
Reference Links
Reference links for the Parent, Self, Children and Related as applicable
Nested Schema : relationship-response
Type:
Show Source
object
-
name:
string
Title:
Relationship Name
Name of the relationship -
refField:
object referenceField-response
-
refOnDelete:
string
Title:
Reference On Delete
Allowed Values:[ "On Delete No Action", "On Delete Cascade", "On Delete Set Null" ]
On delete behavior for the relationship -
refTable:
object referenceTable-response
Nested Schema : validation-response
Type:
Show Source
object
-
attribute:
string
Title:
Attribute Name
The name of the attribute the column is mapped to. -
hierarchy:
string
Title:
Attribute Hierarchy
Attribute hierarchy -
links:
array Links
Title:
Links
Links to the related objects. -
type:
string
Title:
Validation Type
Allowed Values:[ "Config", "Commerce" ]
Type of the validation.
Nested Schema : Reference Links
Type:
object
Title:
Reference Links
Reference links for the Parent, Self, Children and Related as applicable
Show Source
-
href:
string
Title:
href
URL to the related object -
rel:
string
Title:
Link
Link relationship to the current object
Nested Schema : referenceField-response
Type:
Show Source
object
-
links:
array Links
Title:
Links
Links to the related objects. -
name:
string
Title:
Referencing Column
the name of the referencing column.
Nested Schema : referenceTable-response
Type:
Show Source
object
-
links:
array Links
Title:
Links
Links to the related objects. -
name:
string
Title:
Reference Table Name
Name of the referencing table
Nested Schema : Links
Type:
array
Title:
Links
Links to the related objects.
Show Source
-
Array of:
object Reference Links
Title:
Reference Links
Reference links for the Parent, Self, Children and Related as applicable
Nested Schema : Links
Type:
array
Title:
Links
Links to the related objects.
Show Source
-
Array of:
object Reference Links
Title:
Reference Links
Reference links for the Parent, Self, Children and Related as applicable
Nested Schema : Links
Type:
array
Title:
Links
Links to the related objects.
Show Source
-
Array of:
object Reference Links
Title:
Reference Links
Reference links for the Parent, Self, Children and Related as applicable
Examples
The following example shows how to get a list of data table columns by submitting a GET request to the REST resource using cURL. For more information about cURL, see Use cURL.
curl -X GET -i -H "Authorization: Basic dXNlcm5hbWU6cGFzc3dvcmQg" -H "Accept: application/json" https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields
Response Body Sample
{ "items": [{ "id": 41367525, "dateModified": "10/23/2019 10:43 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/DateUpdated" } ], "name": "DateUpdated", "dateAdded": "10/23/2019 10:32 AM", "type": "String", "order": 1, "index": false, "key": false }, { "id": 41366838, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/Type" } ], "name": "Type", "description": "This field identifies the component type.", "dateAdded": "10/21/2019 11:15 AM", "type": "String", "order": 1, "index": false, "key": false }, { "id": 41366839, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/SubType" } ], "name": "SubType", "dateAdded": "10/21/2019 11:15 AM", "type": "String", "order": 2, "index": false, "key": false }, { "id": 41366840, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/Selector" } ], "name": "Selector", "dateAdded": "10/21/2019 11:15 AM", "type": "Integer", "order": 3, "index": false, "key": false }, { "id": 41366841, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/SelectorString" } ], "name": "SelectorString", "dateAdded": "10/21/2019 11:15 AM", "type": "String", "order": 4, "index": false, "key": false }, { "id": 41366842, "dateModified": "10/23/2019 10:32 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/Height" } ], "name": "Height", "description": "This field identifies the height of the component.", "dateAdded": "10/21/2019 11:15 AM", "type": "Integer", "order": 5, "index": false, "key": false }, { "id": 41366843, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/Power" } ], "name": "Power", "dateAdded": "10/21/2019 11:15 AM", "type": "Integer", "order": 6, "index": false, "key": false }, { "id": 41366844, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/UsageInt" } ], "name": "UsageInt", "dateAdded": "10/21/2019 11:15 AM", "type": "Integer", "order": 7, "index": false, "key": false }, { "id": 41366845, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/UsageString" } ], "name": "UsageString", "dateAdded": "10/21/2019 11:15 AM", "type": "String", "order": 8, "index": false, "key": false }, { "id": 41366846, "dateModified": "10/21/2019 11:15 AM", "links": [{ "rel": "parent", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields/Descriptor" } ], "name": "Descriptor", "dateAdded": "10/21/2019 11:15 AM", "type": "String", "order": 9, "index": false, "key": false } ], "links": [{ "rel": "canonical", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields" }, { "rel": "next", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields?offset=1000&limit=1000&totalResults=false" }, { "rel": "self", "href": "https://sitename.oracle.com/rest/v16/datatables/Rack_Domain/fields?offset=0&limit=1000&totalResults=false" } ] }