Can I query leads with multiple search criteria ?

Anonymous
Not applicable

Can I query leads with multiple search criteria ?

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

7 REPLIES 7
Grégoire_Miche2
Level 10

Re: Can I query leads with multiple search criteria ?

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
Not applicable

Re: Can I query leads with multiple search criteria ?

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
Level 10

Re: Can I query leads with multiple search criteria ?

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

Grégoire_Miche2
Level 10

Re: Can I query leads with multiple search criteria ?

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

SanfordWhiteman
Level 10 - Community Moderator

Re: Can I query leads with multiple search criteria ?

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).

Adam_Carter
Level 1

Re: Can I query leads with multiple search criteria ?

Is this possible yet?

Adam

SanfordWhiteman
Level 10 - Community Moderator

Re: Can I query leads with multiple search criteria ?

No.