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.