I have a scenario in which I need to look up in Salesforce object_field_history table. I need to group the result based on object ID. So is there any way to group the result?
On the default out of the box Salesforce connector: No
However, you have a couple of options of doing some post processing while using the Salesforce connector by combining documents on the ObjectId in a data process shape. Additionally, you could have a groovy script to combine documents based on ObjectId as well.
Alternatively, if you wanted this to happen on the Salesforce end, you could leverage the Soap Endpoint using the Enterprise WSDL, and be able to generate the SOQL statement that would be required to return the results in the format expected.
Thanks TC Sutton.
Retrieving data ...