11 Replies Latest reply on Mar 25, 2020 9:32 AM by XavierGrosfils

    Eloqua Bulk API Complex Filter Question

    54bbebce-d4da-46c0-9b25-a27abed6f56e

      Hi ,

       

      I am having a bit of an issue with the ELOQUA BULK API.

      This issue is specifically to do with filters.
      I have the below filter a combination of the Date Modified & Date created fields.

       

      "filter":"(('{{Contact.Field(C_DateCreated)}}' >= '2015-07-09' AND '{{Contact.Field(C_DateCreated)}}' < '2015-07-10') OR ('{{Contact.Field(C_DateModified)}}' >= '2015-07-09' AND '{{Contact.Field(C_DateModified)}}' < '2015-07-10'))"

       

      This seems to return some correct results but a lot of incorrect results -

      Below is an example result with the email address removed.

       

          {

            "EmailAddress": ,

            "DateCreated": "2015-07-13 03:21:07",

            "DateModified": "2015-07-15 04:30:18"

          },

       

      As you can see it doesn't satisfy the criteria I am trying to use. (On the 9th July 2015).

       

       

       

      When I use the filter seperately it seems to work perfectly. E.G.

       

      "filter":"('{{Contact.Field(C_DateModified)}}' >= '2015-07-09' AND '{{Contact.Field(C_DateModified)}}' < '2015-07-10')"


      The above returns only results with a DateModifed of the 9th of July 2015.

      Is my filter constructed wrong?

       

      Any help is greatly appreciated.

      Thanks,

      Damien.