AttendeeTypes
Create, update, delete, and query all active attendee types for the company.
Table Specific Information
Select
The connector uses the SAP Concur APIs to process a filter that refers to Id. The connector processes other filters client-side within the connector.
For example, the connector will offload the processing of the following query to the SAP Concur APIs:
SELECT * FROM AttendeeTypes WHERE Id = '123456'
Insert
To insert an attendee type the following columns are required: Name, Code, AttendeeFormId, and DuplicateSearchFields.
INSERT INTO AttendeeTypes (Name, Code, AttendeeFormId, DuplicateSearchFields) VALUES ('AttendeeTypeName', '01234', '123456', 'Title,Company')
Update
To update an attendee type the following column is required: Id.
UPDATE AttendeeTypes SET Code = 'BUSGUEST' WHERE Id = 'gWjEPiokzJTpMsdq34zvJEM$ptCXpT'
Delete
Deletes are not supported for this table.
Columns
| Name | Type | ReadOnly | Description |
| ID [KEY] | String | True |
The unique identifier of the resource. |
| AttendeeFormID | String | False |
The unique identifier for the attendee form for this attendee type. |
| ConnectorID | String | False |
The unique identifier for the Application Connector that is the data source for this attendee type. When this field is empty, the Expense database is the data source. |
| AllowAttendeeCountEditing | Bool | False |
Determines whether users are allowed to edit the count for this attendee type. Format: true or false |
| AllowManuallyEnteredAttendees | Bool | False |
Determines whether users are allowed to add attendees for this attendee type. Format: true or false |
| Code | String | False |
A code that indicates the type of attendee. Examples: EMPLOYEE, SPOUSE, BUSGUEST. Maximum length: 40 characters |
| DuplicateSearchFields | String | False |
The list of Attendee field IDs used by the Add Attendee user interface to alert users that the attendee they want to add is a possible duplicate. This parent element has a DuplicateSearchField child element for each field ID. |
| Name | String | False |
The name for the attendee type. This name must be unique. Maximum length: 40 characters |
| URI | String | True |
The URI to the resource. |