Retrieves items from lists based on the specified search criteria.

Table Specific Information

Select

The add-in uses the SAP Concur APIs to retrieve list items based on the search criteria.

By default, the add-in returns only the first level of items for each list.

In the following queries, the add-in 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