[SalesForce] SOQL Query Opportunities REST API

First time post here and I'm quite new to the SF ecosystem as well. I'm currently trying to figure out how to properly form queries using SOQL + REST.

Ideally what I am trying to do is query an endpoint like:

services/data/v37.0/?q=SELECT+Opportunities+WHERE+id+LIKE+'ID_NUMBER'

I've read a few different ways to go about doing this, but I'm not sure if creating a query like this is the best way, or it using the query() endpoint is better.

I'm just looking for some guidance on pulling back open opportunities at this point.

Best Answer

Your query does not use valid syntax. There are a few things you need to fix:

Your SELECT clause must contain a comma delimited list of fields to return
You need a FROM clause that tells the system which object to query
- The API Name of the object you are trying to query is Opportunity, not Opportunties
You cannot use a LIKE clause on Id values. If you have an exact value to filter on, use =
If you want to pull back all open Opportunity records, filter on the IsClosed field.

If you're going to use the REST API, note also from Execute a SOQL Query in the Force.com REST API Developer Guide that you have a couple more issues you need to fix in your endpoint path:

You must add /query/ after the version (i.e. /v37.0/query/?q=...)
You must start with a leading slash (i.e. /services/...)

Putting it all together, you are looking for something along these lines:

/services/data/v37.0/query/?q=SELECT+Name+FROM+Opportunity+WHERE+IsClosed=false

Related Solutions

[SalesForce] REST & Stripe API

Solved this issue by using a Force.com site and exposing the visualforce page in the site. I then created a Remote site for the Stripe API. RestContext.request.requestBody.toString() wasn't giving me anything. Instead, I found the token in RestContext.request.params. Huge thanks to JimH for pointing this out in his question.

[SalesForce] can we query SOSL using REST API

Yes you can do SOSL query using REST Api.

The api would be - /services/data/v37.0/search/?q=SOSL search string

The SOSL search string needs to be URL encoded.

Here is a link for more details - SOSL Search using REST API

Here is an way how you can make a successful REST API call.

String salesforceHost = System.Url.getSalesforceBaseURL().toExternalForm();

String url =  salesforceHost + '/services/data/v37.0/search/?q='+EncodingUtil.urlEncode('FIND {Joe Smith} IN Name Fields RETURNING lead', 'UTF-8'); // use your own SOSL statement

HttpRequest req = new HttpRequest();

req.setMethod('GET');
req.setEndpoint(url);
req.setHeader('Content-type', 'application/json');
req.setHeader('Authorization', 'OAuth ' + UserInfo.getSessionId());

Http http = new Http();

HTTPResponse res = http.send(req);
System.debug('res'+res.getbody());

Best Answer

Related Solutions

[SalesForce] REST & Stripe API

[SalesForce] can we query SOSL using REST API

Related Topic