Unable to access Group object in Salesforce with a Select query having a WHERE clause

Technote (troubleshooting)


Problem(Abstract)

Unable to access Group object in Salesforce with a Select query having a WHERE clause from 6.x version of Cast Iron Studio.

Cause

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.

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

WebSphere Cast Iron Hypervisor Edition Standard
Studio

Software version:

6.1.0.6

Operating system(s):

Windows

Software edition:

Virtual

Reference #:

1595444

Modified date:

2013-04-16

Translate my page

Machine Translation

Content navigation