TDV Adapter for Oracle Eloqua

Build 22.0.8462

Activity_FormSubmit

Retrieve Form Submit Activities.

Table Specific Information

Select

If you are not using the Bulk API, ContactId is required to query Activity tables.

Additionally, the COUNT function is supported for this table in bulk mode.

Columns

Name Type Description
ID [KEY] Long The unique identifier of the form submit activity.
Name String The name of the form submit activity. Not supported in bulk mode.
CreatedAt Datetime The date and time the form submit activity was created.
Type String The activity type of the form submit activity.
AssetName String The name of the asset associated with the form submit activity.
AssetId Long The Id of the asset associated with the form submit activity.
AssetType String The type of the asset associated with the form submit activity.
ContactId Long The Id of the contact who performed the form submit activity.
Collection String The collection of the form submit activity. Not supported in bulk mode.
FormName String The name of the form associated with the form submit activity. Not supported in bulk mode.
FormData String The data of the form associated with the form submit activity. Not supported in bulk mode.
RawData String The raw data of the form submit activity. Only supported in bulk mode.
CampaignId Long The Id of the campaign associated with the form submit activity. Only supported in bulk mode.
VisitorId Long The Id of the visitor associated with the form submit activity. Only supported in bulk mode.
VisitorExternalId String The ExternalId of the visitor associated with the form submit activity. Only supported in bulk mode.
ExternalId String The ExternalId associated with the form submit activity. Only supported in bulk mode.
FirstName String The FirstName of the contact associated with the form submit activity.
LastName String The LastName of the contact associated with the form submit activity.
Company String The Company of the contact associated with the form submit activity.
City String The City of the contact associated with the bounceback activity.
ContactCreatedAt Datetime The date and time the contact associated with the form submit activity was created.
ContactModifiedAt Datetime The date and time the contact associated with the form submit activity was created.
Address1 String The first line address of the contact associated with the form submit activity.
Address2 String The second line address of the contact associated with the form submit activity.
Title String The Title of the contact associated with the form submit activity.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
ExportToken String The token returned from CreateExportDefinition. If Eloqua has not finished processing the request, the query will wait until the server has finished before returning data.
Depth String The depth of information requested from Eloqua.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462