SSIS Components for Salesforce

Build 26.0.9770

EventRelation

Manages relationships between events and related records, such as attendees and leads.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier of the event relation record.

RelationId String False

ID of the contact, lead, or user associated with the event.

EventId String False

Event.Id

ID of the related event record.

Status String False

Participation status of the related user or contact, such as Accepted or Declined.

RespondedDate Datetime False

Date and time when the participant responded to the event invitation.

Response String False

Type of response from the participant, such as Accepted, Declined, or Tentative.

CreatedDate Datetime True

Date and time when the event relation was created.

CreatedById String True

User.Id

ID of the user who created the event relation.

LastModifiedById String True

User.Id

ID of the user who last modified the event relation.

IsDeleted Bool True

Indicates whether the event relation record has been deleted.

SystemModstamp Datetime True

System-generated timestamp indicating the last modification date.

LastModifiedDate Datetime True

Date and time when the event relation was last modified.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name Type Description
RelationIdType String

Specifies the type of the 'RelationId' polymorphic field to use in the statement.

RelationIdExternalFieldName String

Specifies the external field name of the 'RelationId' polymorphic field to use in an INSERT/UPDATE/UPSERT statement

SOQL String

Specifies the SOQL query to execute against the Salesforce servers. If this pseudo column is set from the WHERE clause it will take precedence over the original query.

ExternalIdColumn String

Specifies the external Id column to use if performing an insert. If this value is specified, upsert will be used when the INSERT command is called.

FilterScope String

Optional scope to limit the records returned from queries. This property can take one of these values: Delegated, Everything, Mine, MineAndMyGroups, My_Territory, My_Team_Territory, or Team.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770