EloquaLinkedAccount
Lists external accounts linked to Eloqua, used for integrations and data synchronization.
Select
The driver uses the Oracle Eloqua Reporting API to access entities. To query a view, a fully qualified query consisting of both the schema name and table name is required to avoid any ambiguity.
For example, the following query specifies the schema name followed by the table name to access this view:
SELECT * FROM ActivityDetails.EloquaLinkedAccount;
Columns
| Name | Type | References | SupportedOperators | Description |
| eloquaLinkedAccountId [KEY] | Int | =,<>,>,<,>=,<=,IN,NOT IN | Unique identifier for the linked account record within Eloqua. | |
| accountAddress1 | String | Primary street address line for the linked account. | ||
| accountAddress2 | String | Secondary street address line for the linked account, if applicable. | ||
| accountAddress3 | String | Additional address details for the linked account, if applicable. | ||
| accountBusinessPhone | String | Primary business phone number associated with the account. | ||
| accountCity | String | City portion of the linked account's address. | ||
| accountCountry | String | Country portion of the linked account's address. | ||
| accountName | String | =,<>,>,<,>=,<=,IN,NOT IN | The official name of the linked account or organization. | |
| accountStateProvince | String | State or province portion of the linked account's address. | ||
| accountZipPostCode | String | ZIP code or postal code of the linked account's address. | ||
| createdDate | Datetime | Date and time when the linked account record was created in Eloqua. | ||
| lastModifiedDate | Datetime | Timestamp of the most recent update made to the linked account record. |