Cmdlets for Oracle Eloqua

Build 24.0.9060

DisplayColumnName Parameter (Connect-OracleEloqua Cmdlet)

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

Syntax

Connect-OracleEloqua -DisplayColumnName string

Data Type

cstr

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 cmdlet 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