SSIS Components for Oracle Eloqua

Build 24.0.9062

DisplayColumnName

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

データ型

string

デフォルト値

""

解説

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 本製品 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.9062