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