ListItemsV4
Lists list items based on the search criteria.
Table Specific Information
Select
The provider uses the SAP Concur APIs to get list items based on the search criteria.
Searching list items by listId retrieves the first level of list items. In order to get all children recursively, you must set the RecursionDepth connection property to the desired depth of list. This retrieves a list that includes children up to the specified depth automaticaly.
In the following queries, the provider offloads the processing to the SAP Concur APIs:
SELECT * FROM ListItemsV4 where id IN ( '665E58E7E1226346BC424861DEC93F30','3FB790E49CDC924F8B4BA29623B18D2D') SELECT * FROM ListItemsV4 where ListId IN ( '3e5ce609-bcf7-7d49-884c-baf70588d4bc','241563a3-bf89-4842-a0fb-6cbd06c87c0c') SELECT * FROM ListItemsV4 where ListId = '3e5ce609-bcf7-7d49-884c-baf70588d4bc' AND Id = '3FB790E49CDC924F8B4BA29623B18D2D'
Columns
Name | Type | References | Description |
Id [KEY] | String | The unique identifier of the list item. | |
Code | String | List item long code. | |
ShortCode | String | List item short code. | |
Value | String | List item value. | |
ParentId | String | The unique identifier of the parent list item. | |
ListId | String | The unique identifier of the list that contains the list item. | |
Level | Int | Level of the list item within the list. | |
HasChildren | Boolean | If true, the list item has children in this particular list. | |
Lists | String | The unique identifiers of the lists that contains the list item. The list item may exist under one or more lists. | |
IsDeleted | Boolean | Indicates the deleted state of the item in a particular list. If false, the list item is not deleted from one or more lists. The lists field will include only the lists that contain the list item in a not-deleted state. isDeleted will only be true when the list item is deleted from all lists. The lists field will include all lists that contain the list item. |