Can I query leads with multiple search criteria ?

[Anonymous]

Hi,

Can you please let me know if it is possible to query Lead databases based on multiple search criteria.

Ex. Get records where country = 'Arizona" and name starts with John.

Would appreciate if you could revert soon on this.

Thanks and Regards,

Pooja

[Adam_Carter]

Is this possible yet?

Adam

[SanfordWhiteman]

No.

[Grégoire_Miche2]

Hi Karan,

Yes, you can do almost everything you want with a smart list.

But, sorry for being direct, if you do not know how to do this, you should urgently get some training.Start with the Marketo University, some online courses will cover this.

-Greg

[Anonymous]

Hey Greg,

Thanks for your reply !

But my bad I missed to mention that i am trying to search the Leads using rest API's explained under

http://developers.marketo.com/rest-api/lead-database/leads/

GET /rest/v1/leads.json?filterType=id&filterValues=318581,318592 

Is there a way I can query with multiple filter Ex. Get lead records where country = 'Arizona" and name starts with John.

[Grégoire_Miche2]

Hey Karan,

Okay, that sounds much clearer and less a frightening question

Normally, in this end point, you can use the "get leads by filter type" one and specify filter fiels and values. What I do not know is whether Marketo will apply AND or OR between the fields.

-Greg

[SanfordWhiteman]

Normally, in this end point, you can use the "get leads by filter type" one and specify filter fiels and values. What I do not know is whether Marketo will apply AND or OR between the fields.

The filterValues are an implicit OR (since you can only specify one filterType, this makes sense).

[Grégoire_Miche2]

Second thought:

Another possibility is to have a marketo List and some smart campaigns that add / remove leads to it, then have you API to just query for the members of that list.

-Greg