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"
}
]
