Connections

Back Next

Activities or Custom Fields Configuration

You can read from or write to the Activities object and custom fields of Contact and Account objects.

Add the metadata information in JSON format in the

Activities or Custom Fields Configuration

property under the Eloqua Bulk connection properties. The specification of Activities object and custom fields contains the following sections:

Activities: Lists all the activities as a name-value pair, where the value is an array of field names. For example,
{"EmailAddress","johns@gmail.com"}, {"FirstName","Johns"}
ActivityItem: Defines an array of fields. Each field has the following name-value pairs:

name
: Name of the field. The field name must be the same as the field name that you enter in the Activities section.
internalName
: Name of the field label. Displays the name and unique name.

datatype
: Data type of the field. Default is String data type. The activities or custom fields supports the following data types:
Number or Integer
Date or Timestamp
String

maxLength
: Maximum length or precision of the data type field.
hasReadOnlyConstraint
: Indicates whether the field is read only.
hasNotNullConstraint
: Indicates whether the field is mandatory.

hasUniquenessConstraint
: Indicates whether the field is a key.
statement
: The statement used in Eloqua REST request.
ContactItem: Defines an array of Contact custom fields. Each field has a name-value pair for the ActivityItem section.

AccountItem: Defines an array of Account custom fields. Each field has a name-value pair for the ActivityItem section.