2

I'm trying this SOQL query in the REST Explorer:

/services/data/v39.0/query/?q=SELECT+AssigneeId+PermissionSet.Id+Assignee.Name+PermissionSet.Name+PermissionSet.Label+FROM+PermissionSetAssignment+WHERE+PermissionSet.Id=[AN ID]

[AN ID] is formed like '0000'

It's saying that it's malformed at Assignee.Name.

I don't know where I'm going wrong with this query as it works in the developer console.

0

1 Answer 1

3

Your fields must be comma delimited. If you were to run the query listed in your URL in the Developer Console, it would translate to:

SELECT AssigneeId PermissionSet.Id Assignee.Name PermissionSet.Name PermissionSet.Label
FROM PermissionSetAssignment WHERE PermissionSet.Id='0000'

Of course this query will not work. The properly delimited query would be:

SELECT AssigneeId, PermissionSet.Id, Assignee.Name, PermissionSet.Name, PermissionSet.Label
FROM PermissionSetAssignment WHERE PermissionSet.Id='0000'

And the properly formed URL would be:

q=SELECT+AssigneeId,PermissionSet.Id,Assignee.Name,PermissionSet.Name,PermissionSet.Label+FROM+PermissionSetAssignment+WHERE+PermissionSet.Id='0000'

Note that the SOQL Developer Guide makes this point clear in SOQL SELECT Syntax (emphasis mine):

Syntax
fieldListsubquery

Description
Specifies a list of one or more fields, separated by commas, that you want to retrieve from the specified object. The bold elements in the following examples are fieldlists:

SELECT Id, Name, BillingCity FROM Account
SELECT count() FROM Contact
SELECT Contact.Firstname, Contact.Account.Name FROM Contact

You must specify valid field names and must have read-level permissions to each specified field. The fieldList defines the ordering of fields in the query results.

fieldList can include a subquery if the query traverses a relationship. For example:

SELECT Account.Name, (SELECT Contact.LastName FROM Account.Contacts)
FROM Account

The fieldlist can also be an aggregate function, such as COUNT() and COUNT(fieldName), or be wrapped in Translating Results.

3
  • Worked! I wish the documentation on the Salesforce would say that.
    – akcorp2003
    Mar 20, 2017 at 18:40
  • @akcorp2003 Ah, but it does. See my updated answer for citation there.
    – Adrian Larson
    Mar 20, 2017 at 18:44
  • Whoops. I meant the documentation for REST API. It's obvious that a SOQL statement has commas but the REST API documentation only shows a sample query with only 1 selected field. developer.salesforce.com/docs/atlas.en-us.api_rest.meta/…
    – akcorp2003
    Mar 20, 2017 at 21:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .