QueryDefinition
The QueryDefinition object represents a SQL query activity accessed and performed by the SOAP API.
- To update a QueryDefinition where the CategoryID is greater than 0, you need the Email | Interactions | Activities | Query | Move permission.
- To start a QueryDefinition using the perform method, you need the Email | Interactions | Activities | Query | Move permission.
| Name | Data Type | Description |
|---|---|---|
| CategoryID | xsd | Specifies the identifier of the folder. |
| Client | ClientID | Specifies the account ownership and context of an object. |
| CorrelationID | xsd | Identifies correlation of objects across several requests. |
| CreatedDate | xsd | Read-only date and time of the object's creation. |
| CustomerKey | xsd | User-supplied unique identifier for an object within an object type. This property corresponds to the external key assigned to an object. |
| DataExtensionTarget | InteractionBaseObject | Indicates data extension to use as a template when auto-generating a new data extension. To ensure that the query activity targets the correct data extension, specify a unique external key for each data extension. For Enterprise 2.0 accounts, the external key must be unique among business unit and enterprise shared data extensions. |
| Description | xsd | Describes and provides information regarding the object. |
| FileSpec | xsd | Defines the file-naming pattern associated with an activity (valid substitutions include%%YEAR%%, %%MONTH%%, and %%DAY%%). |
| FileType | xsd | Specifies column delimiter of a file. Valid values include:
|
| ID | xsd | Read-only identifier for an object. Some objects use the ObjectID property as a unique ID. |
| InteractionObjectID | xsd | Returns associated ID for activities within the asynchronous process of the overall conversation or program. |
| Keyword | xsd | Reserved for future use. |
| ModifiedDate | Nullable`1 | Indicates the last time object information was modified. |
| Name | xsd | Name of the object or property. |
| ObjectID | xsd | System-controlled, read-only text string identifier for object. |
| ObjectState | xsd | Reserved for future use. |
| Owner | Owner | Describes account ownership of subscriber in an on-your-behalf account. |
| PartnerKey | xsd | Unique identifier provided by partner for an object. This property is accessible only via API. |
| PartnerProperties | APIProperty[] | A collection of metadata supplied by the client and stored by the system. These properties are accessible only via API. |
| QueryText | xsd | Specifies text associated with a query definition. |
| Status | xsd | Defines status of object. Status of an address. |
| TargetType | xsd | Indicates target type for a query definition. |
| TargetUpdateType | xsd | Indicates the target update type for a query definition. |