SSIS Components for Salesforce

Build 26.0.9770

FlowOrchestrationWorkItem

Represents a task assigned to a user as part of a Flow orchestration stage.

Columns

Name Type ReadOnly References Description
Id [KEY] String True

Unique identifier for the record.

OwnerId String False

ID of the user who owns the record.

IsDeleted Bool True

Indicates whether the record has been moved to the Recycle Bin.

Name String True

Name of the record.

CreatedDate Datetime True

Date and time when the record was created.

CreatedById String True

User.Id

ID of the user who created the record.

LastModifiedById String True

User.Id

ID of the user who last modified the record.

LastViewedDate Datetime True

Date and time when the record was last viewed in the user interface.

LastReferencedDate Datetime True

Date and time when the record was last referenced.

StepInstanceId String False

FlowOrchestrationStepInstance.Id

ID of the StepInstance associated with this record.

Status String False

Status of the record.

RelatedRecordId String False

ID of the record associated with this feed item.

Label String False

Field containing Label information.

Description String False

Text description of the record.

AssigneeId String False

ID of the Assignee associated with this record.

ScreenFlow String False

Field containing ScreenFlow information.

ScreenFlowInputs String False

Field containing ScreenFlowInputs information.

OrchestrationName String False

Name of the Flow orchestration definition associated with this work item.

FlowType String False

Type of Flow associated with this work item.

ElapsedTimeSinceCreationInSec String True

Field containing ElapsedTimeSinceCreationInSec information.

ElapsedTimeSinceAsgntInSec String True

Field containing ElapsedTimeSinceAsgntInSec information.

ParentWorkItemId String False

FlowOrchestrationWorkItem.Id

ID of the parent work item, if this work item was created from another.

SystemModstamp Datetime True

Date and time when the record was last modified by a user or by an automated process.

LastModifiedDate Datetime True

Date and time when the record 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
OwnerIdType String

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

OwnerIdExternalFieldName String

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

RelatedRecordIdType String

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

RelatedRecordIdExternalFieldName String

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

AssigneeIdType String

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

AssigneeIdExternalFieldName String

Specifies the external field name of the 'AssigneeId' 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