If I want to use Salesforce's REST API to return campaigns who have recently had members added to them, what is the easiest way to do so? I am trying to do this externally, using authentication information to pull data from Salesforce in a different application. Is using Campaign.SystemModstamp
the best way to achieve this?
Add a comment
|
2 Answers
Not necessarily. This flag can be updated for any of a number of reasons (e.g. a user edited a field). Instead, a query might help:
SELECT Id FROM Campaign WHERE Id IN
(SELECT CampaignId FROM CampaignMember WHERE CreatedDate = TODAY)
(Replace TODAY with any other date literal or a specific date range).
-
This accomplishes what I'm looking for with a well-designed query. It wasn't immediately obvious to me how to access this data using the correct filter. Many thanks! Commented May 23, 2020 at 2:38