ExactTarget API tip - complex filters

A couple of weeks ago I was at a client site doing ExactTarget API consulting. This client is standardizing on ExactTarget as their single source of all e-mail communications from three of their internal applications. They will use 5Buckets for the automation in certain cases, but also needed to develop their own integration with ExactTarget directly.

One of the developers posed me a question about “filters” in the ExactTarget web service. You can use
simplefilterpart() to specify what data point you want to filter on, and of course the value. For example, to filter on CustomerKey -


SimpleFilterPart sfp = new SimpleFilterPart();
sfp.Property = “CustomerKey”;
sfp.SimpleOperator = SimpleOperators.equals;
sfp.Value = new string[] { “TransactionalSendKey” };

Here you are first creating an instance of SimpleFilterPart. Then indicating that you want to filter using “CustomerKey”, indicating the operator and finally the value of the CustomerKey.

Now, if you have two filter criteria, you create two instances of the SimpleFilterPart and join the two using ComplexFilterPart (see code example in the Webserivces API guide, pg. 36)

Going back to the question that came up at client site - they wanted to know how they would add a third filter criteria. Well, it’s simple enough. Create a third instance of SimpleFilterPart and set the property and values as appropriate. Then create another instance of a ComplexFilterPart and assign you first ComplexFilterPart to the LeftOperand and the third SimpleFilterPart to the RightOperand.


ComplexFilterPart ComplexFilter2 = new ComplexFilterPart();
ComplexFilter2.LeftOperand = ComplexFilter1;
ComplexFilter2.LogicalOperator = LogicalOperators.AND;
ComplexFilter2.RightOperand = ThirdSimpleFilterPart;




Related Professional Services Automation Articles

Salesforce.com Silicon Valley City Tour


I had a chance to participate on a panel at the salesforce.com city tour in Santa Clara last week. I would say there were roughly 500 people in the audience, and it was fun for me to present as a salesforce customer. I was on the panel with Doug...

Read more about Salesforce.com Silicon Valley City Tour...

Experimentation, Prototyping and Roombas.


Will we look back on the desktop experience of today in much the same way we reflect on computer punch cards of yore? If so, when will the desktop and mouse become irrelevant? How do people who want to explore the world of technology experiences...

Read more about Experimentation, Prototyping and Roombas. ...

Search Content


Featured Content


WhitePapers


Oracle Magazine

Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest...Read More


Sales Force Automation Comparison Guide

Businesses of all sizes can benefit by automating all aspects of their sales processes with an SFA (Sales Force Automation) solution. But due to the sheer number of features that most SFA solutions...Read More


How to Buy a Phone System

Considering a new phone system for your business? The Phone System Buyer's Guide from VoIP-News provides you with all of the information you need to make a more informed decision. The Guide helps you...Read More


Which CMS Is Right For Me?

If you're wondering which CMS is the right one for your organization, this comprehensive guide will take you through the various options available, detailing the pros and cons of each. Download...Read More




View All Whitepapers