-1

/services/data/v39.0/query/?q=SELECT+Id,Name,AccountNumber,Type+FROM+Account+limit+10

i need to add where clause here

LiKE :- /services/data/v39.0/query/?q=SELECT+Id,Name,AccountNumber,Type+FROM+Account+where+rating!=warm+limit+10

But getting 400 bad request .Please suggest

1

Your filter condition needs to use quotes around literal strings.

/services/data/v39.0/query/?q=SELECT+Id,Name,AccountNumber,Type+FROM+Account+where+rating!='warm'+limit+10
| improve this answer | |
  • Thanks ,SFDCFOX, – sandy Apr 6 at 5:10
  • Thanks ,SFDCFOX,But instead of hardcore value if i want to take one string as this api will be in for loop and value will change for rating,How to add that string in API call.. – sandy Apr 6 at 5:19
  • like String rating=acc.rating and this string i need to use in my API call – sandy Apr 6 at 5:20
  • @sandy That will depend on the code you're using (Apex, JavaScript, etc). The API itself requires these quotes to be present. – sfdcfox Apr 6 at 6:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.