Using LIKE in Salesforce Input WHERE Clause

mpurdy

I am trying to use "LIKE" in the WHERE Clause (SOQL) of the Salesforce Input but I am getting the following error:

Error trying to retrieve query. HTTP/1.1 400 Bad Request ... Data from server: [{"message":"A query string has to be specified","errorCode":"MALFORMED_QUERY"}]

I am not sure what I am missing. If I remove the "%" character then it doesn't error, but it doesn't find anything either. My statement looks like this: Data_Source_ID__c LIKE 'ABC%'.

Thanks in advance for any help that you can give.

s_pichaipillai

@mpurdy

i think i found the root casue of this issue 

from the below error message it sending the URL(API)  format with Like values. so the % operator causes the issue

Error: Salesforce Input (1): Tool #130: Iteration #1: Tool #21: Error trying to retrieve query. HTTP/1.1 400 Bad Request
... Data from server: 

<!-- ...................................................................................................
       ...................................................................................................
       ...................................................................................................
       ................................................................................................... --><table cellspacing=10>
<tr><td><span style="font-weight: bold; font-size: 12pt;">Illegal Request</span></td></tr>
<tr><td>You have sent us an Illegal URL or an improperly formatted request. </td></tr>
<tr><td></td></tr>
</table>

can you change your filter from Name like '%Gene' to m Name like '%25Gene%25'

plese check the URL Encoding ref for %

http://www.w3schools.com/tags/ref_urlencode.asp