Salesforce Integration - SOQL - GROUP BY

Available

Robert Nilsson

• November 12, 2021 20:40

Right now the Salesforce integration forces the use of a SELECT/WHERE format for pulling data.  I would like the option to either use freeform SOQL SELECT statements or an an explicit options to use GROUP BY SOQL statements.

This would allow me to tally things like how many opportunities does an account have, how many high priority support cases, etc.  This would be a huge upgrade to the integration and would help us avoid adding unneeded summary fields in our Salesforce Records.

4

• Official comment

  

  Product Team

  • November 14, 2021 12:41

  Hi Robert,

  It is in our roadmap for 2022 to allow free SOQL filters including group by.

  The reason we did not do it initially, is that  in order to match Salesforce accounts to Totango accounts we relay on data coming from one object and not in an aggregated way of group by.

   

  Comment actions Permalink
• 

  Product Team

  • March 15, 2022 06:00

  Hi Robert,

  The SFDC Aggregation connector (using GROUP BY) is ready and will be released next Sunday (Sprint 213)

  Thanks

   

  0

  Comment actions Permalink

Please sign in to leave a comment.