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.
Best Answer
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:Of course this query will not work. The properly delimited query would be:
And the properly formed URL would be:
Note that the
SOQL Developer Guide
makes this point clear in SOQL SELECT Syntax (emphasis mine):