The below query is being used by offshore team in Mulesoft to query IsDeleted Campaign Members for specific Campaign ID. When tested in Developer console it seems to work but via API Integration pulling query in Mule (for ExactTarget) they are not returning expected results for specific Campaign (only one deleted/removed campaign member where there should be several over period of time). Need to find out how to trouble shoot or come up with better query.  Objective: To provide ExactTarget updated Campaign Members every 30 minutes (New Campaign Member add query does appear to be working).

select Campaign.ET_Activity_ID__c,CampaignId,Id,ContactId,Contact.Email,Contact.FirstName,Contact.LastName,Campaign_Member_Source__c, IsDeleted,LastModifiedDate,LeadId,Lead.LeadSource,Status from CAMPAIGNMEMBER where IsDeleted=true

Any assistance greatly appreciated.
 

The below query is being used by offshore team in Mulesoft to query IsDeleted Campaign Members for specific Campaign ID. When tested in Developer console it seems to work but via API Integration pulling query in Mule (for ExactTarget) they are not returning expected results for specific Campaign (only one deleted/removed campaign member where there should be several over period of time). Need to find out how to trouble shoot or come up with better query.  Objective: To provide ExactTarget updated Campaign Members every 30 minutes (New Campaign Member add query does appear to be working).

select Campaign.ET_Activity_ID__c,CampaignId,Id,ContactId,Contact.Email,Contact.FirstName,Contact.LastName,Campaign_Member_Source__c, IsDeleted,LastModifiedDate,LeadId,Lead.LeadSource,Status from CAMPAIGNMEMBER where IsDeleted=true

Any assistance greatly appreciated.