Skip to main content

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

 

@* Marketing Cloud Engagement * 

1 个回答
0/9000