I am using SOQL for accessing the data of salesforce using java

Question

String uri = baseUri + "/query?q=Select+Id+from+Account+where+Id=+ ('017F00000nqmNPQAY')";

I am using SOQL for querying the data, it is working fine without where clause, but I don't know how to write it with where clause, It is throwing error when I am trying the above syntax. How can I resolve this?

Yes, without where clause i am getting the response, but with where clause it is not working. — nishant singh, May 29 '18 at 08:58
I meant is there not a better API than to create an URL like that? — Kayaman, May 29 '18 at 09:00
You need to escape the ``=`` in the query. Also I would highly recommend not to allow to pass in a whole query. Imagine ``/query?q=Delete+From+Account+where+1``. — f1sh, May 29 '18 at 09:02
Also: ``It is throwing error`` is not a problem description. — f1sh, May 29 '18 at 09:03

score 1 · Accepted Answer · answered May 29 '18 at 14:49

Why not do something like this:

URIBuilder ubuilder = new URIBuilder(baseUri);
ubuilder.setPath("/services/data/v39.0/query/")
   .setParameter("q", "SELECT Id, Name FROM Account WHERE Id = '017F00000nqmNPQAY'");
HttpGet request = new HttpGet(ubuilder.build());

I am using SOQL for accessing the data of salesforce using java

1 Answers1