Hi, We are trying to update from our legacy Salesforce connector in ADF to the new one which is mostly working to retrieve data but we cannot do a count of rows in a table with the new connector. Bulk API doesn’t support queries with any of the following: GROUP BY, OFFSET, or TYPEOF clauses Aggregate functions such as COUNT() Date functions in GROUP BY clauses (date functions in WHERE clauses are supported) Compound address fields or compound geolocations fields We have a pipeline where we need to get row counts for each of our salesforce objects. Is there a workaround for this? I was trying to set up a REST connector as well as the new Salesforce connector but I'm not sure if this is the correct approach nor do I know how to do this in ADF.

New ADF Connector for Salesforce doesn't allow for aggregate queries

JB 106

Hi,

We are trying to update from our legacy Salesforce connector in ADF to the new one which is mostly working to retrieve data but we cannot do a count of rows in a table with the new connector.

Bulk API doesn’t support queries with any of the following:

GROUP BY, OFFSET, or TYPEOF clauses
Aggregate functions such as COUNT()
Date functions in GROUP BY clauses (date functions in WHERE clauses are supported)
Compound address fields or compound geolocations fields

We have a pipeline where we need to get row counts for each of our salesforce objects. Is there a workaround for this? I was trying to set up a REST connector as well as the new Salesforce connector but I'm not sure if this is the correct approach nor do I know how to do this in ADF.

AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee

2024-08-27T06:42:51.8633333+00:00

Hi @JB ,

Thankyou for using Microsoft Q&A platform and thanks for posting your query here.

As per my understanding you are trying to find a way to use aggregate functions like count in New salesforce connector in ADF. I am reaching out to the internal team to get the workaround for the requirement as the new connector doesn't support the same. I will update once I hear back from the team. Thanks
JB 106 Reputation points

2024-09-04T21:54:31.1533333+00:00

@AnnuKumari-MSFT Thanks for checking internally, any updates? We are still hoping for a solution. Thank you!
AnnuKumari-MSFT 32,821 Reputation points Microsoft Employee

2024-09-05T03:21:23.39+00:00

Hi JB ,

We got the response from the team today that "this is the native behavior/limitation in Salesforce Bulk APIv2. We can share this with Salesforce team to understand their roadmap, but I don't expect it'd be supported shortly by Salesforce either. "
JB 106 Reputation points

2024-09-05T04:21:06.3333333+00:00

Thank you @AnnuKumari-MSFT

Share via

New ADF Connector for Salesforce doesn't allow for aggregate queries

Your answer