ODBC Driver for Oracle Eloqua

Build 24.0.9060

DisplayColumnName

Specifies the display name for columns when using the Oracle Eloqua Bulk API. The possible settings are empty string, 'internal', and 'statement'.

Data Type

string

Default Value

""

Remarks

The response data Oracle Eloqua Bulk API Fields contains three kinds of displayName: "name","statement",and "internalName" for the same field.

The display name type chosen is simply a matter of visual preference.

As an example, suppose you have the following JSON response for an EmailAddress item.


{
    "items":[
        {
            "name":"Email Address",
            "internalName":"C_EmailAddress",
            "dataType":"emailAddress",
            "hasReadOnlyConstraint":false,
            "hasNotNullConstraint":false,
            "hasUniquenessConstraint":true,
            "statement":"{{Contact.Field(C_EmailAddress)}}",
            "uri":"/contacts/fields/100001",
            "createdAt":"1900-01-01T05:00:00.0000000Z",
            "updatedAt":"1900-01-01T05:00:00.0000000Z"
        },
       ......
    ]
}
The column name listed upon metadata discovery from the driver will be one of the following.
  • Empty String: The default value is empty string. The means the "name" of the field will be regarded as the display column name: EmailAddress.
  • internal: This means the "internalName" of the field will be regarded as the display column name: C_EmailAddress.
  • statement: It means the "statement" of the field will be regarded as the display column name: {{Contact.Field(C_EmailAddress)}}.

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