IBM Support

Cast Iron Salesforce Connector Query Objects activity generates AGGREGATERESULT element in result schema when aggregate formula is not part of query

Troubleshooting


Problem

The problem is related to the Query Objects activity of the Salesforce connector of Cast Iron. When you specify a query in the following format : select Account.Name from Contact Salesforce returns the Contact objects; whereas, the Map Input schema in Cast Iron Studio displays AggregateResult. This happens only for queries that fetch fields from objects that are not specified in the 'from' clause.

Resolving The Problem

To resolve this issue, specify the query as:

select Account.Name, Id from Contact.

This means that at least one field from the object specified in the 'from' clause must be selected.
This ensures that the Map Inputs schema contains the Contact objects, and not the aggregate results.

[{"Product":{"code":"SSGR73","label":"IBM Cast Iron Cloud Integration"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Connectors","Platform":[{"code":"PF009","label":"Firmware"}],"Version":"6.1.0.12","Edition":"Virtual;Physical;Cloud","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
15 June 2018

UID

swg21656795

Page Feedback