Discussions

BULK API: Allow complex filters

claudiazoglmannclaudiazoglmann Posts: 130 Silver Badge
edited August 2017 in Dream It

Or: allow EXISTS on entity CDO

Or: provide proper error validation

2 votes

Active · Last Updated

Comments

  • Lou PatrickLou Patrick Posts: 343 Gold Badge

    Is this idea offering up two options? (1) Allow advanced filtering OR (2) Provide proper error validation

    The thread referenced was a discussion on supporting more combinations of nested criteria, but this request is specifically mentioning EXISTS on custom objects. Does this idea include more combinations of nested criteria as well?

    Could you share some details on allowing EXISTS on a custom object and the use case? (e.g. would this be for contact exports?)

  • claudiazoglmannclaudiazoglmann Posts: 130 Silver Badge

    Is this idea offering up two options? (1) Allow advanced filtering OR (2) Provide proper error validation

    The thread referenced was a discussion on supporting more combinations of nested criteria, but this request is specifically mentioning EXISTS on custom objects. Does this idea include more combinations of nested criteria as well?

    Could you share some details on allowing EXISTS on a custom object and the use case? (e.g. would this be for contact exports?)

    Both (1) and (2) would be beneficial for working with complex filters.

    Since OR is limited, the EXISTS operator is helpful when complex criteria are required.

    EXISTS on entity CDO could return all CDO records mapped to Contacts which are in Segment or in Shared Filter.

    Use case: Custom integrations where specific field values on the Contact table are prerequisite for the export of mapped CDO records.

  • 35979663597966 Posts: 3

    It would be super useful if we could specify a filter that allows us to pull all records created or modified in a specified date range (for example a single day):

    ((CreatedDate > date1) AND (CreatedDate < date2)) OR ((ModifiedDate > date1) AND (ModifiedDate < date2))

Sign In or Register to comment.