ListItems

Create, update, delete, and query all list items based on the search criteria.

テーブル固有の情報

Select

本製品はSAP Concur API を使用して、Id フィルタ、またはListId、Name、ParentId、Level1Code - Level10Code の任意の組み合わせのフィルタを処理します。本製品はクライアント側で本製品内で他のフィルタを処理します。

例えば、本製品はSAP Concur API に次のクエリの処理をオフロードします。

SELECT * FROM ListItems WHERE Id = 'ListItemId'
SELECT * FROM ListItems WHERE ListId = 'sampleListId' AND Name = 'sampleName' AND Level5Code = 'code5' AND Level10Code = 'code10'

Insert

リストアイテムを挿入するには、次のカラムが必要です：ListId、Name、およびLevel1Code。

INSERT INTO ListItems (ListId, Name, Level1Code) VALUES ('ListIdValue', 'ListItemName', 'Level1CodValue')

Update

UPDATE は、リストアイテムではサポートされていません。

Delete

削除は、リストアイテムではサポートされていません。

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.