Hi, I have a Send Log data extension (Send Logging Marketing Cloud Email Sends (salesforce.com) ),
having columns JobID (number), Batch (Id) and few more. For a particular job id, there are multiple batch ids. e.g.
JobId BatchId
100 1
100 1
100 2
100 2
100 3
Requirement is to retieve distinct combination of Job id and Batch id using SFMC Soap api.
The result for above data will be :- (100,1) ; (100,2); (100,3)
I could not find a simple operator (https://developer.salesforce.com/docs/marketing/marketing-cloud/guide/simpleoperators.html?q=simple) using which i can achieve this in an optimised way. I donot want to retrieve all the records and then find distinct at my end.
Is there a way to achieve this via SFMC soap?
Thanks
Hi,
Sorry for the inconvenience. If you don't receive a response here, we recommend reaching out to our support team for further assistance.
You can do so by visiting
https://help.salesforce.com/s/articleView?id=000393090&language=en_US&type=1