Skip to main content
November 14, 2016
Question

Can I query leads with multiple search criteria ?

  • November 14, 2016
  • 2 replies
  • 3030 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Grégoire_Miche2
Level 10
November 14, 2016

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

November 15, 2016

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
November 15, 2016

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

Level 1
February 21, 2019

Is this possible yet?

Adam

SanfordWhiteman
Level 10
February 21, 2019

No.