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)}}.