To change a single entity, use the URL <baseURL>/api/entity/{table}/{uid}
Table 32: Change single entity request
|
Put |
<BaseURL>/api/entity/{table}/{uid} |
{"values": {
"StringColumn": "string",
"IntColumn": 0,
"DateColumn": "2016-05-19T11:21:33.579Z",
"BoolColumn": true
} |
Table 33: Change single entity parameters
|
table |
Table name (required) |
path |
string |
|
uid |
GUID of the entity (required) |
path |
string |
|
values |
Values to change |
body |
SampleValues |
Body schema:
SingleChangeBody {
values(SampleValues, optional)
}
SampleValues {
StringColumn(string, optional),
IntColumn(integer, optional),
DateColumn(date - time, optional),
BoolColumn (boolean, optional)
}
Response schema:
{}
Example:
https://<Hostname>/AppServer/api/entity/Person/83b10e84-c64e-4f9f-9ecb-2d0d7c94e8ec
Body:
{
"values": {
"LastName": "Garibaldi",
"IsExternal": false,
"UID_Locality": "83615878-7205-408d-a5fa-f260840c867c"
}
}
Response Code:
200
Response:
{}
To change a single entity, use the URL <baseURL>/api/entities
Table 34: Change a batch of single entities request
|
Post |
<BaseURL>/api/entities |
{
"entities": [
{
"table": "string",
"uid": "string",
"values": {
"StringColumn": "string",
"IntColumn": 0,
"DateColumn": "2016-0519T11:21:33.579Z",
"DoubleColumn": 3.14,
"BoolColumn": true
}
}
],
"insertMissing": false
} |
Table 35: Change a batch of single entities parameters
| entities |
List of entities to create (required) |
Body |
array[UpdateEntity] |
| insertMissing |
Insert entities that could not be found using the supplied keys. |
Body |
Boolean |
Body schema:
BulkChangeBodyUpdate {
entities(Array[UpdateEntity]),
insertMissing(boolean,default: false)
}
UpdateEntity {
table(string),
uid(string),
values(SampleValues, optional)
}
SampleValues {
StringColumn(string, optional),
IntColumn(integer, optional),
DateColumn(date - time, optional),
BoolColumn (boolean, optional)
}
Response Code:
204
Example 1:
This sample demonstrates the change of existing entities while omitting the insertMissing parameter in the body.
https://<Hostname>/AppServer/api/entities
Body:
{
"entities": [
{
"table": "Person",
"uid": "8a2eee88-0615-4595-a903-8388ca74d877",
"values": {
"LastName": "Coleman",
"IsExternal": false,
"ExitDate": "2032-12-31"
}
},
{
"table": "Person",
"uid": "df563a8c-203a-4132-8fcb-bc4adabb35b6",
"values": {
"FirstName": "Rosalie",
"LastName": "Meyer",
"IsExternal": True,
"BirthDate": "1991-03-21",
"Gender": 2,
"ExitDate": "2032-12-31",
}
}
]
}
Response Code:
204
Example 2:
This sample demonstrates the change of existing entities using the insertMissing parameter in the body to create non-existing entities.
https://<Hostname>/AppServer/api/entities
Body:
{
"entities": [
{
"table": "Person",
"uid": "8a2eee88-0615-4595-a903-8388ca74d877",
"values": {
"FirstName": "Jeremy",
"LastName": "Coleman",
"IsExternal": false,
"ExitDate": "2032-12-31"
}
},
{
"table": "Person",
"uid": "df563a8c-203a-4132-8fcb-bc4adaee35b6",
"values": {
"FirstName": "Rosalie",
"LastName": "Meyer",
"IsExternal": True,
"ExitDate": "2032-12-31",
}
}
]
"insertMissing": True
}
Response Code:
204
To delete a single entity, use the URL <baseURL>/api/entity/{table}/{uid}
Table 36: Delete single entity request
|
Delete |
<BaseURL>/api/entity/{table}/{uid} |
None |
Table 37: Delete single entity parameters
|
table |
Table name (required) |
path |
string |
|
uid |
Guid of the entity (required) |
path |
string |
Response schema:
{}
Example:
https://<Hostname>/AppServer/api/entity/Person/83b10e84-c64e-4f9f-9ecb-2d0d7c94e8ec
Response Code:
200
Response:
{}
To delete a single entity, use the URL <baseURL>/api/entities
Table 38: Delete a batch of single entities request
| Delete |
<BaseURL>/api/entities |
None |
Table 39: Delete a batch of single entities parameters
| entities |
List of entities to delete |
body |
DeleteEntity |
Body schema:
BulkChangeBodyDelete {
entities(array[DeleteEntity])
}
DeleteEntity {
table(string),
uid(string)
}
Response code:
204
Example:
https://<Hostname>/AppServer/api/entities
Body:
{
"entities": [
{
"table": "Person",
"uid": "8a2eee88-0615-4595-a903-8388ca74d877"
},
{
"table": "Person",
"uid": "df563a8c-203a-4132-8fcb-bc4adaee35b6"
}
]
}
Response Code:
204
