{dataClass}
Dataclass names can be used directly in the REST requests to work with entities and entity selections, or class functions of the dataclass.
Available syntaxes
Syntax | Beispiel | Beschreibung |
---|---|---|
{dataClass} | /Employee | Returns all the data (by default the first 100 entities) for the dataclass |
{dataClass}({key}) | /Employee(22) | Returns the data for the specific entity defined by the dataclass's primary key |
{dataClass}:{attribute}(value) | /Employee:firstName(John) | Returns the data for one entity in which the attribute's value is defined |
{dataClass}/{DataClassClassFunction} | /City/getCity | Executes a dataclass class function |
{dataClass}({EntitySelectionClassFunction} | /City/getPopulation/?$filter="ID<3" | Executes an entity selection class function |
{dataClass}({key})/{EntityClassFunction} | City(2)/getPopulation | Executes an entity class function |
Function calls are detailed in the Calling ORDA class functions section.
{dataClass}
Returns all the data (by default the first 100 entities) for a specific dataclass (e.g., Company
)
Beschreibung
When you call this parameter in your REST request, the first 100 entities are returned unless you have specified a value using $top/$limit
.
Here is a description of the data returned:
Property | Typ | Beschreibung |
---|---|---|
__entityModel | String | Name of the dataclass. |
__COUNT | Zahl | Number of entities in the dataclass. |
__SENT | Zahl | Number of entities sent by the REST request. This number can be the total number of entities if it is less than the value defined by $top/$limit . |
__FIRST | Zahl | Entity number that the selection starts at. Either 0 by default or the value defined by $skip . |
__ENTITIES | Collection | This collection of objects contains an object for each entity with all its attributes. All relational attributes are returned as objects with a URI to obtain information regarding the parent. |
Each entity contains the following properties:
Property | Typ | Beschreibung |
---|---|---|
__KEY | String | Value of the primary key defined for the dataclass. |
__TIMESTAMP | Datum | Timestamp of the last modification of the entity |
__STAMP | Zahl | Internal stamp that is needed when you modify any of the values in the entity when using $method=update . |
If you want to specify which attributes you want to return, define them using the following syntax {attribute1, attribute2, ...}. Beispiel:
GET /rest/Company/name,address
Beispiel
Return all the data for a specific dataclass.
GET /rest/Company
Result:
{
"__entityModel": "Company",
"__GlobalStamp": 51,
"__COUNT": 250,
"__SENT": 100,
"__FIRST": 0,
"__ENTITIES": [
{
"__KEY": "1",
"__TIMESTAMP": "2020-04-10T10:44:49.927Z",
"__STAMP": 1,
"ID": 1,
"name": "Adobe",
"address": null,
"city": "San Jose",
"country": "USA",
"revenues": 500000,
"staff": {
"__deferred": {
"uri": "http://127.0.0.1:8081/rest/Company(1)/staff?$expand=staff"
}
}
},
{
"__KEY": "2",
"__TIMESTAMP": "2018-04-25T14:42:18.351Z",
"__STAMP": 1,
"ID": 2,
"name": "Apple",
"address": null,
"city": "Cupertino",
"country": "USA",
"revenues": 890000,
"staff": {
"__deferred": {
"uri": "http://127.0.0.1:8081/rest/Company(2)/staff?$expand=staff"
}
}
},
{
"__KEY": "3",
"__TIMESTAMP": "2018-04-23T09:03:49.021Z",
"__STAMP": 2,
"ID": 3,
"name": "4D",
"address": null,
"city": "Clichy",
"country": "France",
"revenues": 700000,
"staff": {
"__deferred": {
"uri": "http://127.0.0.1:8081/rest/Company(3)/staff?$expand=staff"
}
}
},
{
"__KEY": "4",
"__TIMESTAMP": "2018-03-28T14:38:07.430Z",
"__STAMP": 1,
"ID": 4,
"name": "Microsoft",
"address": null,
"city": "Seattle",
"country": "USA",
"revenues": 650000,
"staff": {
"__deferred": {
"uri": "http://127.0.0.1:8081/rest/Company(4)/staff?$expand=staff"
}
}
}
.....//more entities here
]
}
{dataClass}({key})
Returns the data for the specific entity defined by the dataclass's primary key, e.g., Company(22) or Company("IT0911AB2200")
Beschreibung
By passing the dataclass and a key, you can retrieve all the public information for that entity. By passing the dataclass and a key, you can retrieve all the public information for that entity. For more information about defining a primary key, refer to the Modifying the Primary Key section in the Data Model Editor.
For more information about the data returned, refer to {DataStoreClass}.
If you want to specify which attributes you want to return, define them using the following syntax {attribute1, attribute2, ...}. Beispiel:
GET /rest/Company(1)/name,address
If you want to expand a relation attribute using $expand
, you do so by specifying it as shown below:
GET /rest/Company(1)/name,address,staff?$expand=staff
Beispiel
The following request returns all the public data in the Company dataclass whose key is 1.
GET /rest/Company(1)
Result:
{
"__entityModel": "Company",
"__KEY": "1",
"__TIMESTAMP": "2020-04-10T10:44:49.927Z",
"__STAMP": 2,
"ID": 1,
"name": "Apple",
"address": Infinite Loop,
"city": "Cupertino",
"country": "USA",
"url": http://www.apple.com,
"revenues": 500000,
"staff": {
"__deferred": {
"uri": "http://127.0.0.1:8081/rest/Company(1)/staff?$expand=staff"
}
}
}
{dataClass}:{attribute}(value)
Returns the data for one entity in which the attribute's value is defined
Beschreibung
By passing the dataClass and an attribute along with a value, you can retrieve all the public information for that entity. The value is a unique value for attribute, but is not the primary key.
GET /rest/Company:companyCode(Acme001)
If you want to specify which attributes you want to return, define them using the following syntax {attribute1, attribute2, ...}. Beispiel:
GET /rest/Company:companyCode(Acme001)/name,address
If you want to use a relation attribute using $attributes, you do so by specifying it as shown below:
GET /rest/Company:companyCode(Acme001)?$attributes=name,address,staff.name
Beispiel
The following request returns all the public data of the employee named "Jones".
GET /rest/Employee:lastname(Jones)