Lists

The driver uses the SAP Concur APIs to view your configured lists within SAP Concur products.

Table-Specific Information

Select

This API is only available to partners who have been granted access by the SAP Concur team.

The add-in uses the SAP Concur APIs to retrieve configured lists within SAP Concur products.

For example:

-- Retrieves all available lists
SELECT * FROM Lists;

-- Retrieves a specific list by Id
SELECT * FROM Lists WHERE Id = '665E58E7E1226346BC424861DEC93F30';

Columns


Name	Type	ReadOnly	References	Description
Id [KEY]	String	False		Unique identifier of a list.
Value	String	False		Name of the list.
LevelCount	Int	False		Number of levels in the list.
SearchCriteria	String	False		What attribute to search by {TEXT, CODE}.
DisplayFormat	String	False		Whether the code or value is displayed first {(CODE) TEXT, TEXT (CODE)}
CategoryId	String	False		The category of the list.
CategoryType	String	False		The category of the list.
IsReadOnly	Boolean	False		If true, the list is read-only.
IsDeleted	Boolean	False		If true, the list has been deleted. The default value is false.

Excel Add-In for SAP Concur

Lists

Table-Specific Information

Select

Columns