ListItems
Create, update, delete, and query all list items based on the search criteria.
Table Specific Information
Select
The driver uses the SAP Concur APIs to process filters on Id or on any combination of ListId, Name, ParentId, and Level1Code - Level10Code. The driver processes other filters client-side within the driver.
For example, the driver will offload processing of the following queries to the SAP Concur APIs:
SELECT * FROM ListItems WHERE Id = 'ListItemId' SELECT * FROM ListItems WHERE ListId = 'sampleListId' AND Name = 'sampleName' AND Level5Code = 'code5' AND Level10Code = 'code10'You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.
Insert
To insert a list item the following columns are required: ListId, Name, and Level1Code.
INSERT INTO ListItems (ListId, Name, Level1Code) VALUES ('ListIdValue','ListItemName', 'Level1CodValue')
Update
Updates are not supported for list items.
Delete
Deletes are not supported for list items.
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
The unique identifier of the resource. | |
ListID | String | False |
The unique identifier for the list this item is a member. | |
ParentID | String | True |
The unique identifier of this item's parent. Is empty when there is no parent. | |
Level10Code | String | False |
The item code for the tenth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level1Code | String | False |
The item code for the first level of the list. All lists have at least a Level1Code. Text maximum 32 characters | |
Level2Code | String | False |
The item code for the second level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level3Code | String | False |
The item code for the third level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level4Code | String | False |
The item code for the fourth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level5Code | String | False |
The item code for the fifth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level6Code | String | False |
The item code for the sixth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level7Code | String | False |
The item code for the seventh level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level8Code | String | False |
The item code for the eighth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Level9Code | String | False |
The item code for the ninth level of the list. Empty when this level doesn't exist in the list. Text maximum 32 characters | |
Name | String | False |
The name of item. Text maximum 64 characters | |
URI | String | True |
The URI to the resource. |