Rajesh A created CAMEL-10348: -------------------------------- Summary: Camel Salesforce - Unable to get aggregate query results Key: CAMEL-10348 URL: https://issues.apache.org/jira/browse/CAMEL-10348 Project: Camel Issue Type: Bug Components: camel-salesforce Affects Versions: 2.17.3 Reporter: Rajesh A
Trying to get the maximum value by executing the below query: SELECT max(Replay_Id__c) maxReplayId FROM Streaming__c WHERE Status__c != 'New' Here is the camel route endpoint: {code:title=MyRouteBuilder.java|borderStyle=solid} ..... from("timer://runOnce?repeatCount=1") .to("salesforce:query?sObjectQuery=SELECT max(Replay_Id__c) maxReplayId FROM Streaming__c WHERE Status__c != 'New'&sObjectClass=" + QueryRecordsAggregateResult.class.getName()) .process(this.initalProcessor); .... {code} But, I am not able to get the AggregateResult, this is what I see in QueryRecordsAggregateResult *BodyType:* org.apache.camel.salesforce.dto.QueryRecordsAggregateResult, Body: {"done":true,"totalSize":1,"records":[{"attributes":{"type":"AggregateResult"}}]}, Out: null: And the generated AggregateResult.java looks like this: {code:title=AggregateResult.java|borderStyle=solid} /** * Salesforce DTO for SObject AggregateResult */ @XStreamAlias("AggregateResult") public class AggregateResult extends AbstractSObjectBase { } {code} There is no documentation on how to pull aggregate results. I guess this is a defect which prevents me from getting the aggregate result from salesforce. Could you please fix this. -- This message was sent by Atlassian JIRA (v6.3.4#6332)