Eloqua Bulk API – Export filter with EXISTS() segment to only allow system updated or created fields

Overview

With the arrival of the 19B Eloqua release (May 2019), Bulk API contact export definitions with an EXISTS() Segment, e.g. EXISTS('{{ContactSegment[<id>]}}'), will only allow up to two system updated or created date criterion.

What’s changing?

With 19B, when Bulk API contact export definitions have an EXISTS() Segment, e.g. EXISTS('{{ContactSegment[<id>]}}'), validation will be added to ensure the following:

• Only the following system date field statements can be used in the filter:

{{Contact.UpdatedAt}}

{{Contact.CreatedAt}}

{{Contact.Field(C_DateModified)}}

{{Contact.Field(C_DateCreated)}}

• Only the following logic can be used in the filter with a maximum of two date criterion: