topic Re: Salesforce Aggregation Error in Connectivity & Data Prep

Salesforce Aggregation Error

KHSDM — Thu, 05 Sep 2024 01:34:22 GMT

I'm getting the following error when trying to execute a Salesforce query:

Connector reply error: Unable to get column information for the fields that are used in the query. Please make sure you have only one SELECT statement in a query editor. Description: Aggregate functions are not supported by the connector.

I'm using the SOAP option, but still getting the error above. My query is something like this:

SELECT COUNT(Id), Created_From__c FROM <Object Name>__c GROUP BY Created_From__c;

I can execute the query if I remove the aggregation.

Salesforce connector version: 15.212.0

Re: Salesforce Aggregation Error

Vegar — Thu, 05 Sep 2024 05:40:37 GMT

I am not sure about the connector specifics, but a workaround could be like this .

LOAD COUNT(Id), Created_From__c GROUP BY Created_From__c;

SELECT Id, Created_From__c FROM <Object Name>__c GROUP BY Created_From__c;

Alternatively like this.

SF:

SELECT Id, Created_From__c FROM <Object Name>__c GROUP BY Created_From__c;

FINAL:

LOAD COUNT(Id), Created_From__c RESIDENT SF GROUP BY Created_From__c;

DROP TABLE SF:

Re: Salesforce Aggregation Error

KHSDM — Fri, 06 Sep 2024 09:08:41 GMT

Hi Vegar,

Thanks for the suggestion. But we prefer to do the aggregation in SF as the original dataset is quite huge. So, we wanted SF to summarize the data before to extract it.