Lists
Create, update, delete, and query all lists based on the search criteria.
Table Specific Information
Select
The provider uses the SAP Concur APIs to process filters that refer to Id. The provider processes other filters client-side within the provider.
For example, the provider will offload the processing of the following query to the SAP Concur APIs:
SELECT * FROM Lists WHERE Id = '123456'
Insert
To insert a list item the following columns are required: Name, DisplayCodeFirst, IsVendorList, and SearchCriteriaCode.
INSERT INTO Lists (Name, DisplayCodeFirst, IsVendorList, SearchCriteriaCode) VALUES ('NameValue', true, true, 'CODE')
Update
UPDATEs are not supported for this table.
Delete
Deletes are not supported for this table.
Columns
Name | Type | ReadOnly | References | Description |
ID [KEY] | String | True |
null | |
ConnectorID | String | False |
Optional. Defines the encrypted ConnectorID. If not provided then the list isn't associated with a connector. | |
DisplayCodeFirst | Bool | False |
Required. Defines whether CODE should appear before TEXT, or vice-versa. | |
ExternalThreshold | Int | False |
Optional. Default value is 1. Defines the threshold from where the level starts being external. This value can only be set if a ConnectorID is provided. | |
IsVendorList | Bool | False |
Required. Defines whether it is a vendor list. | |
Name | String | False |
Required. Defines a name for the list. This name must be unique. | |
SearchCriteriaCode | String | False |
Required. Defines whether the search criteria should apply to the CODE or to the TEXT. | |
URI | String | True |
null |