Unable to access Group object in Salesforce with a Select query having a WHERE clause
Unable to access Group object in Salesforce with a Select query having a WHERE clause from 6.x version of Cast Iron Studio.
This has been identified as a product defect under APAR LI76732
Diagnosing the problem
Providing a select query like 'select id from Group where id=$paramid' will throw the following error in Studio versions 6.0 and 6.1.
Error message: 'There is a syntax error from line 1, column: 29, onwards, that is from '=' onwards. Query has not been validated'.
Resolving the problem
The workaround is to use Web Service Invoke activity with Salesforce WSDL and use a manually created schema for the output parameter.
More support for:
WebSphere Cast Iron Hypervisor Edition Standard
Software version: 220.127.116.11
Operating system(s): Windows
Software edition: Virtual
Reference #: 1595444
Modified date: 16 April 2013