Retrieves items from lists based on the specified search criteria.

Table Specific Information

Select

The cmdlet uses the SAP Concur APIs to retrieve list items based on the search criteria.

By default, the cmdlet returns only the first level of items for each list.

In the following queries, the cmdlet offloads the processing to the SAP Concur APIs:

-- Retrieves a specific list item by Id
SELECT * FROM ListItems WHERE Id = '3e5ce609-bcf7-7d49-884c-baf70588d4bc';
-- Retrieves multiple list items by Id
SELECT * FROM ListItems WHERE Id IN ( '665E58E7E1226346BC424861DEC93F30','3FB790E49CDC924F8B4BA29623B18D2D');
-- Retrieves all list items for a specific list
SELECT * FROM ListItems WHERE ListId = '665E58E7E1226346BC424861DEC93F30';
-- Retrieves list items for multiple lists
SELECT * FROM ListItems WHERE ListId IN ( '3e5ce609-bcf7-7d49-884c-baf70588d4bc','241563a3-bf89-4842-a0fb-6cbd06c87c0c');

Insert

Use the following syntax to add new list items to an existing list:

-- Adds a new custom list item to the specified list
INSERT INTO ListItems (value, shortCode, listid) 
VALUES ('MyCustomListItem','VFAL1','4c392113-c827-4e9c-9b2f-80c473018081');

Update

ListItems cannot be updated, but the item itself can. See the Items table.

Delete

ListItems cannot be deleted, but the item itself can. See the Items table.

Columns