To get a list of assignments for a specific entity, use the URL <baseURL>/api/assignments/{table}/{column}/{uid}.
Query parameters to be used in WHERE clauses and predefined WHERE clauses can be provided in the form @paramname=value. Per default they have the type string. Additionally, it is possible to pass the type with the name: @otherParam[int]=3. Types originate from DbVal class.
HTTP method |
URI |
Body |
---|---|---|
Get |
<BaseURL>/api/assignments/{table}/{column}/{uid} |
None |
Parameter |
Description |
Parameter type |
Data type |
---|---|---|---|
table |
Member table name (required). |
path |
string |
column |
Column pointing to the base entity (required). |
path |
string |
uid |
GUID of the base entity (required). |
path |
string |
where |
WHERE clause. |
query |
string |
whereKey |
Predefined WHERE clause from QBMLimitedSQL (Key [UID] or ID [Ident_QBMLimitedSQL]). |
query |
string |
orderBy |
ORDER BY clause. |
query |
string |
offset |
Offset of first item. |
query |
integer |
limit |
Maximum number of results. |
query |
integer |
displayColumns |
Additional display columns, semicolon separated. |
query |
string |
loadType |
Collection load type. Specify one of the values:
|
query |
string |
noUrls |
Allow to omit the URI property from the response to reduce the response size especially if used while retrieving large M:N tables like PersonHasObject. |
query |
boolean |
Response schema:
array {
href(string),
title(string),
uid(string)
}
Example:
https://<Hostname>/AppServer/api/assignments/PersonInOrg/UID_Org/007b7087-6881-44e7-8954-82374340718f?limit=2
Response:
[
{
"href": "https://<Hostname>/AppServer/api/entity/Person/a9c6bc62-3f77-453f-b774-3afd9d4d19e0",
"title": "Abbey, Jenna (JENNAA) - KAGU Org",
"uid": "a9c6bc62-3f77-453f-b774-3afd9d4d19e0"
},
{
"href": "https://<Hostname>/AppServer/api/entity/Person/be514f69-fc8f-49c0-a791-2b79b8f5cbdf",
"title": "Abbott, James (JAMESA) - KAGU Org",
"uid": "be514f69-fc8f-49c0-a791-2b79b8f5cbdf"
}
]