I am trying to avoid using any SOAP service for such simple operations as below:
- The picklist of all Lead Statuses (including inactive)
- The picklist of Stages/Statuses attached to a Record Type
- The picklist of all Task types
Taking the last requirement, this should be possible with the Tooling API with a soql query
I am told there are 3 fields:
- StandardValue (the picklist array)
How am I supposed to query this? I have tried
SELECT StandardValue FROM StandardValueSet Where Fullname = 'Task.Type' and this returns an error:
SELECT StandardValue FROM StandardValueSet ^ ERROR at Row:1:Column:8 No such column 'StandardValue' on entity 'StandardValueSet'. If you are attempting to use a custom field, be sure to append the '__c' after the custom field name. Please reference your WSDL or the describe call for the appropriate names.
How does anyone manage to work with Salesforce with such poor documentation?