Is there any advanced filtering of date range expressions available in Eloqua Activity Bulk API?

User_48F57

Hello all,

We are looking for any advanced ways of filtering activity bulk API exports via definition criteria. From the online documentation, from what I can tell that we can create a new definition with filter criteria looking based on a specific date/time stamp, but not necessarily anything beyond that.

For example, the documentation shows the following:

"filter":"'{{Activity.Type}}' = 'EmailClickthrough' AND '{{Activity.CreatedAt}}' >= '2014-08-01' AND '{{Activity.CreatedAt}}' < '2014-09-01'"

We would be looking for something similar to:

'{{Activity.CreatedAt}}' >= NOW - INTERVAL 10 MINUTES

Or, similarly something that can give us X minutes worth of data since the last time the definition was synced against.

Any good ideas? Anything I'm missing from the documentation?

Cheers.

Lou Patrick

There are no dynamic dates available in Bulk API filters. Actual date values must be entered, so any date value calculations need to occur prior to creating the Bulk API definition.