ListItems
Create, update, delete, and query all list items based on the search criteria.
Table Specific Information
Select
The add-in uses the SAP Concur APIs to process filters on Id or on any combination of ListId, Name, ParentId, and Level1Code - Level10Code. The add-in processes other filters client-side within the add-in.
For example, the add-in 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'
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. |