TDV Adapter for SAP Concur

Build 22.0.8462

Lists

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

Table Specific Information

Select

The adapter uses the SAP Concur APIs to process filters that refer to Id. The adapter processes other filters client-side within the adapter.

For example, the adapter 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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462