How to Change in Where Clause / Qurey in Rest API

Hi Mehul,

The link you've shared with us is from our Legacy Rest API. (Minor edit here: We recommend our customers who are on 7.x to use Rest V10.)

I'm not really sure what is your approach. If you wanna filter leads. You could use $contains operator in Filters - Developer Guide.

I hope this helps or feel free to clarify if i get you wrong.

Best Regards

Tevfik Tümer

Developer Support Engineer

Hi Tevfik Tümer

need help on query clause 

   //The SQL WHERE clause without the word "where".

         'query' => "email1 LIKE mehul@gmail.com",

example i am searching record that having this email in Lead module Using Rest API..

i have used above link.

Hi Tevfik Tümer

need help on query clause 

   //The SQL WHERE clause without the word "where".

         'query' => "email1 LIKE mehul@gmail.com",

example i am searching record that having this email in Lead module Using Rest API..

i have used above link.

Hi Mehul,

I think you are looking something like this;

$url = $base_url . "/Leads";

// $date_start = date('c');
$params = array(
    "filters" => array(
      'email1' => array(
        '$contains' => array(
          'mehul@gmail.com'
        )
      )
    )
);

$records = call($url, $oauth2_token_response->access_token, 'GET', $params);

Hope this helps.

Best Regards

Tevfik Tümer

Developer Support Engineer