Filtering

1 min

You can use and or or clauses to return the exact customer data that you want. The filtering section in the payload may contain one of the following:

clause – A standalone clause for defining a filter on ODP data elements.

and (all sub-clauses) – A combination of clauses. If all of the contained clauses (which may include nested and/or clauses) evaluate to true, this data element may pass the overall filter. If any one (or more) of them do not, the data element will not pass the filter.

or (at least one sub-clause) – A combination of clauses. If any one (or more) of the contained clauses (which may include nested and or or clauses) evaluates to true, this data element may pass the overall filter. If none do, the data element will not pass the filter.

Important and or or are case-sensitive in this filter and must be all lowercase.

{      
      "format": "csv",
      "delimiter": "comma",
      "select": {
        "object": "customers",
        "fields": [
                  "email",
                  "insights.ttno_days"
                  ],
        "filter": {
			            "and": [
				                  {
				                  "field": "email",
				                  "operator": "!=",
				                  "value": null
				                  },
		                      {
		                      "field": "ccpa_opted_out",
		                      "operator": "!=",
		                      "value": true}
	                       ]
    	              }
                }
    }