SSIS Components for SAP Concur

Build 24.0.9060

AttendeeTypes

Create, update, delete, and query all active attendee types for the company.

Table Specific Information

Select

The component uses the SAP Concur APIs to process a filter that refers to Id. The component processes other filters client-side within the component.

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060