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